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

Scripts by Jano Petras

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Searching through SPs, Tables, Views

Find quickly all stored procedures, tables and views that are somehow related to the search term.  Read more...
By Jano Petras 2011/02/09 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 2,658 reads

Restore Database from network location

When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.  Read more...
By Jano Petras 2010/05/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,765 reads

Delimited String Parser

Parses delimited string into a table of up to 9 varchar fields.  Read more...
By Jano Petras 2008/12/17 | Source: SQLServerCentral.com | Category: parse
Rating: |  Discuss |   Briefcase | 2,500 reads

When sp_depends fails

sp_depends may not always return accurate information  Read more...
By Jano Petras 2008/05/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,477 reads

Get DATE part of the DATETIME

A quick and elegant way to obtain date part of the datetime values  Read more...
By Jano Petras 2011/06/14 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 5,785 reads
   Items 1 to 6 of 6