<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
syscomments
Items 1 to 3 of 3
Potential Issue with Re-Naming Stored Procedures
In this article Mohammad Meimandi explains an issue faced while using SQL-DMO to copy database objects.
Read more...
By
Mohammad Meimandi
2010/10/07
|
Source:
SQLServerCentral.com
|
Category:
syscomments
Rating:
|
Discuss
|
Briefcase
|
7,812 reads
Find all Procedures, Views, Functions that have been renamed
Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.
Read more...
By
David Hay
2009/08/17
|
Source:
SQLServerCentral.com
|
Category:
sp_rename
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
732 reads
Tables referenced by a stored proc (2000)
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
Read more...
By
David McKinney
2008/12/30
|
Source:
SQLServerCentral.com
|
Category:
sql server 7
Rating:
|
Discuss
|
Briefcase
|
953 reads
Items 1 to 3 of 3
Tags
dependencies
(1)
functions
(1)
procedures
(1)
sp_rename
(1)
sql server 7
(1)
sql-dmo
(1)
views
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
