Sign in
|
Help
Search
Tomaz.tsql
Home
RSS
Atom
Comments RSS
Recent Posts
viewing files on disk
happy new year 2013
Delete trigger does not catch table truncation
simple word randomization based on dictionary
CTP3
Tags
2013
access
anagram
ansi_nulls
ansi_paddings
catalog views
checksum
create synonym
cross apply
CTE
cube
database
datefirst
dateformat
datetime
dbcc
DDL
delete trigger
deploy
DWH
ETL
execution plan
files
for xml path
GUID
index
information_schema
insert into
language
lock_timeout
manage access
manage report
naming convention
objects
OLAP
optimization
ORDER BY
problems
process
query optimization
regular expression
reporting
script
set
set transaction isolation level
size
solution
sp_msforeachdb
sp_msforeachtable
split
spt_values
sql 2008
SQL BITS
sql joke
SSAS
SSRS SQL 2008 R2
stored procedure
string
sys.dm_fts_parser
table
Tally table
Team Foundation Server
textsize
TFS
timestamp
top with ties
t-sql new year's card
useroption
views
while loop
with
xml for path
xp_dirtree
Navigation
Home
Blogs
Photos
Downloads
Archives
January 2013 (1)
December 2012 (1)
August 2012 (1)
January 2012 (1)
July 2011 (3)
February 2011 (1)
January 2011 (3)
December 2010 (1)
November 2010 (1)
October 2010 (5)
September 2010 (2)
August 2010 (6)
July 2010 (3)
Browse by Tags
All Tags
»
views
(
RSS
)
catalog views
information_schema
sql 2008
stored procedure
Stored procedure and how to script them
Imagine having hundred of stored procedures in your database and you want to move them to another database. There are several ways to move them. 1) In MMSM you can right-click each procedure and select "script stored procedure as -> create to...
Posted:
Aug 31 2010, 06:09 PM
by
Tomaz.tsql
| with
no comments
Filed under:
sql 2008
,
views
,
information_schema
,
catalog views
,
stored procedure