SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Peter Sloboda

SQLServerCentral.com profile

   Items 1 to 6 of 6   

Object dependencies in xml format

Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio. It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.  Read more...
By Peter Sloboda 2014/07/21 | Source: SQLServerCentral.com | Category: object dependencies
Rating: (not yet rated) |  Discuss |   Briefcase | 863 reads

Hassle free parameters in dynamic SQL

An alternative solution to passing parameters to sp_executesql. 
Rating: |  Discuss |   Briefcase | 4,027 reads

Just for fun

Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.  Read more...
By Peter Sloboda 2010/09/03 | Source: SQLServerCentral.com | Category: word
Rating: |  Discuss |   Briefcase | 2,625 reads

Custom Logging in a transaction

Ever happened that your custom log got rolled back and you were left with nothing but an error_message()? Try to log into a table variable.  Read more...
By Peter Sloboda 2010/07/22 | Source: SQLServerCentral.com | Category: custom logging
Rating: |  Discuss |   Briefcase | 1,126 reads

SP and function dependencies

Extracts all calls to SPs and functions (down to depth of 32)  Read more...
By Peter Sloboda 2010/07/15 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,851 reads

Print Tree

Stored proc which crawls a tree structure and dumps it in text and grid formats.  Read more...
By Peter Sloboda 2010/07/19 | Source: SQLServerCentral.com | Category: tree
Rating: |  Discuss |   Briefcase | 2,473 reads
   Items 1 to 6 of 6