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


 

Scripts with tag DBA Rss

Search for any content tagged dba

Add a script

   Items 1 to 6 of 6   
 

sp_who3

A compatibility view for DBAs used to using sp_who2  Read more...
By gerhard-356547 2011/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 2,090 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 0001/01/01 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 3,818 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 2,428 reads

Function to Add Leading 0's (Zeros) to an INT

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...
By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |  Briefcase | 1,478 reads

Function to Return Date and Time String for File Archiving

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...
By Joshua A. Walker 2009/02/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |  Briefcase | 1,257 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 0001/01/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |  Briefcase | 6,721 reads
   Items 1 to 6 of 6   
 
 
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.