SQL Clone
SQLServerCentral is supported by Redgate
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,698 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 and restore
Rating: |  Discuss |   Briefcase | 2,785 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,645 reads

When sp_depends fails

sp_depends may not always return accurate information 
By Jano Petras 2008/05/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,527 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,841 reads
   Items 1 to 6 of 6