Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 | 697 reads

Hassle free parameters in dynamic sql.

An alternative solution to passing parameters to sp_executesql.  Read more...
Rating: |  Discuss |   Briefcase | 1,510 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,581 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,104 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,818 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,409 reads
   Items 1 to 6 of 6