SQLServerCentral: Content tagged SQL Server 7, SQL Server 2005

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so. Read more...

By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers

Rating:

|

Discuss |

Briefcase | 3,114 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005. Read more...

By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 2,200 reads

Comprehensive Backup Script

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans. Read more...

By Simon Facer 2011/12/22 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 3,245 reads

Check Instance Info

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance. Read more...

By Pedro Lopes MS 2011/12/15 | Source: SQLServerCentral.com | Category: sql server 7

Rating:

|

Discuss |

Briefcase | 3,310 reads

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005. Read more...

By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 2,731 reads

Set standard database options

Ensure all your databases have standardised options by running this script weekly. Read more...

By Ed Vassie 2011/09/19 | Source: SQLServerCentral.com | Category: sql server 7

Rating:

|

Discuss |

Briefcase | 2,027 reads

Backup Stored Proc

Script to backup 2000/2005 databases. Read more...

By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 8,752 reads

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions. Read more...

By Ed Vassie 2011/09/08 | Source: SQLServerCentral.com | Category: sql server 7

Rating:

|

Discuss |

Briefcase | 4,856 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model). Read more...

By Rafal Skotak 2011/05/25 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 9,730 reads

A Failed Jobs Monitoring System

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008) Read more...

By TJay Belt 2009/09/04 (first published: 2008/02/05) | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 22,187 reads

Table Index Store and Create

Query to save all index metadata Read more...

By Jorge Novo-@ETLDEVDBA 2009/07/17 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 816 reads

Sending E-mail from SQL Server 200X

From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008. Read more...

By Additional Articles 2009/07/01 | Source: DevX | Category: database mail

Rating:

Rate this |

Briefcase | 4,222 reads

Enhancing the readability of your code: Table aliasing in sql

When writing SQL, picking good tables aliases can greatly enhance the readability of your code Read more...

By Sylvia Moestl Vasilik 2009/05/07 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 7,788 reads

Yet Another Deleting Duplicate Records (in-place)

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column. Read more...

By Peter Petrov 2009/01/15 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 1,817 reads

Proxy Accounts in SQL Server

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them Read more...

By Additional Articles 2008/12/30 | Source: Database Journal | Category: proxy accounts

Rating: (not yet rated) Rate this |

Briefcase | 3,259 reads

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so. Read more...

By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers

Rating:

|

Discuss |

Briefcase | 3,114 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order. Read more...

By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,088 reads