SQLServerCentral: Content tagged SQL Server 7

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,105 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day. Read more...

By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 10,460 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

Generate SQL Scripts from Database

Simulate EM's Generate SQL Scripts with DMO and VBS Read more...

By Absinthe 2011/12/16 | Source: SQLServerCentral.com | Category: dmo

Rating: (not yet rated) |

Discuss |

Briefcase | 3,712 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,309 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,854 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed. Read more...

By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore

Rating:

|

Discuss |

Briefcase | 3,908 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,728 reads

SQL Server 7 Build List

A list of builds and versions for SQL Server 7. Read more...

By Steve Jones 2013/05/23 | Source: SQLServerCentral.com | Category: sql server 7

Rating: (not yet rated) |

Discuss |

Briefcase | 159 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,186 reads

Get DDL for any SQL 2000 table

a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything. Read more...

By Lowell Izaguirre 2009/07/28 | Source: SQLServerCentral.com | Category: sql server 7

Rating:

|

Discuss |

Briefcase | 653 reads

Meta Data Services

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

Differential Backup Store Procedure for SQL Server 2000

The Store Procedure can be use for generating Differential Backup datewise in SQL Server 2000. Read more...

By Swapnil Tawde 2009/07/14 | Source: SQLServerCentral.com | Category: backup / restore

Rating: (not yet rated) |

Discuss |

Briefcase | 686 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

The Automated DBA: Batch Database File Grower - SQL 2000 Version

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup. Read more...

By Jesse Roberge 2009/06/25 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 541 reads

Content with tag SQL Server 7