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

Content with tags SQL Server 7, SQL Server 2005 Rss

   Items 1 to 20 of 71    Older >>
 

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,268 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,264 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,340 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,427 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,775 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,082 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,878 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 | 5,077 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,819 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,433 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 | 863 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,360 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,828 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,850 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,483 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,268 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,139 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,596 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,284 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,264 reads
   Items 1 to 20 of 71    Older >>
 
Tags
administration (26)    
security (6)    
t-sql (6)    
performance tuning (5)    
miscellaneous (4)    
monitoring (4)    
advanced querying (3)    
arrays (3)    
counter (3)    
delimited strings (3)    
development (3)    
news (3)    
nums (3)    
parse (3)    
sqlinsider scripts (3)    
strategies (3)    
string manipulation (3)    
table of numbers (3)    
tally (3)    
backup / restore (2)    
indexing (2)    
replication (2)    
sql server 2008 (2)    
best practices (1)    
database mail (1)    
database roles (1)    
databases (1)    
disaster recovery (dr) (1)    
dts (1)    
integration services (ssis) (1)    
jobs (1)    
logins (1)    
maintenance (1)    
metadata (1)    
naming standards (1)    
passwords (1)    
permissions (1)    
proxy accounts (1)    
random numbers (1)    
setup (1)    
sql agent (1)    
sql server 2000 (1)    
sql server 6.5 (1)    
sysobjects (1)    
table aliases (1)    
upgrading (1)    
writing readable code (1)    
xml (1)    
xp_sendmail (1)