Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts by Peter Sloboda profile

   Items 1 to 5 of 5   

Hassle free parameters in dynamic sql.

An alternative solution to passing parameters to sp_executesql. 
Rating: (not yet rated) |  Discuss |   Briefcase | 6 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: | Category: word
Rating: |  Discuss |   Briefcase | 2,556 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: | Category: custom logging
Rating: |  Discuss |   Briefcase | 1,092 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: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,803 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: | Category: tree
Rating: |  Discuss |   Briefcase | 2,394 reads
   Items 1 to 5 of 5