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

Scripts with tag SQL Server 7 Rss

Search for any content tagged sql server 7

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 21 to 31 of 31   
 

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...
By Chad Miller 2008/05/08 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,453 reads

Available bytes for row expansion (adding columns) in a table

This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.   Read more...
By ruchir-628038 2008/04/03 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 788 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

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,037 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,808 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 | 4,272 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,061 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

Check Availability Window - SQL2k

This script allows you to check the several availability windows for the current day.  Read more...
Rating: |  Discuss |   Briefcase | 1,042 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,402 reads

usp_ShowOrphanUsers - SQL 2k

Check Orphaned logins ie, not associated with any database on the current instance.  Read more...
By Pedro Lopes MS 2007/10/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 869 reads
<< Newer    Items 21 to 31 of 31