SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag SQL Server 2000 Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (6)     Alias Data Types (2)     DMO (1)     Recovery (1)    
Backup (3)     DTS (2)     Enterprise Manager (1)     Registered Servers (1)    
Monitoring (3)     Miscellaneous (2)     Lock and Connection Management (1)     Restore (1)    
T-SQL Aids (3)     T-SQL (2)     Maintenance and Management (1)     SQL Server 7 (1)    
Administration (2)     Capacity planning (1)     powershell (1)    
   Items 1 to 17 of 17   
 

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 2008/06/17 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 18 reads

Blocking

By Kev Riley 2008/05/16 | Category: Lock and Connection Management
Rating: (not yet rated) |  Discuss |  Briefcase | 1,353 reads

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 | 601 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 S. 2008/05/02 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,263 reads

Reverse engineering alias data types - Part 5

Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.  Read more...
By Yakov Shlafman 2008/04/17 | Source: SQLServerCentral.com | Category: SQL Server 2000
Rating: (not yet rated) |  Discuss |  Briefcase | 763 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 2008/04/03 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 339 reads

SQL Server DBA Fights a Demon

An interesting tale of David Bird's fight with tempdb.  Read more...
By David Bird 2008/03/17 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 5,807 reads

Generate SQL Scripts from Database

Simulate EM's Generate SQL Scripts with DMO and VBS  Read more...
By Absinthe 2008/02/15 | Source: SQLServerCentral.com | Category: DMO
Rating: (not yet rated) |  Discuss |  Briefcase | 1,192 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 2008/02/12 | Source: SQLServerCentral.com | Category: Restore
Rating: |  Discuss |  Briefcase | 883 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.  Read more...
By TJay Belt 2008/02/05 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 7,823 reads

Check Availability Window - SQL2k

This script allows you to check the several availability windows for the current day.  Read more...
By Pedro Lopes 2008/01/18 | Source: SQLServerCentral.com | Category: Maintenance and Management
Rating: |  Discuss |  Briefcase | 582 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2008/01/17 | Source: SQLServerCentral.com | Category: Backup
Rating: |  Discuss |  Briefcase | 2,506 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 2007/12/19 | Source: SQLServerCentral.com | Category: SQL Server 2000
Rating: |  Discuss |  Briefcase | 917 reads

Monitoring on a Budget

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...
By Bert Carles 2007/11/19 | Source: SQLServerCentral.com | Category: Monitoring
Rating: |  Discuss |  Briefcase | 6,684 reads

Reverse Engineering Alias Data Types in SQL Server 2000 - Part IV

In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).  Read more...
By Yakov Shlafman 2007/11/01 | Source: SQLServerCentral.com | Category: SQL Server 2000
Rating: |  Discuss |  Briefcase | 1,308 reads

Migrating SQL Server 2000 DTS Packages Across Environments

Many of us still have SQL Server 2000 DTS packages running throughout our environment. New author Owais Bashir Ahmed brings us an interesting technique for moving those packages between servers that might come in handy as you continue to work on these packages in SQL Server 2000.  Read more...
By Owais Bashir Ahmed 2007/10/09 | Source: SQLServerCentral.com | Category: DTS
Rating: |  Discuss |  Briefcase | 4,078 reads

Recovery to a Point in Time

This is one of the very useful features in SQL Server 2000 and if you ever have the need to perform this actiom, you will appreciate the knowledge in this article.   Read more...
By Grant Fritchey 2005/06/15 | Source: SQLServerCentral.com | Category: Backup
Rating: |  Discuss |  Briefcase | 11,290 reads
   Items 1 to 17 of 17   
 
Most popular

Monitoring on a Budget

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...
By Bert Carles 2007/11/19 | Source: SQLServerCentral.com | Category: Monitoring
Rating: |  Discuss |  Briefcase | 6,684 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2008/01/17 | Source: SQLServerCentral.com | Category: Backup
Rating: |  Discuss |  Briefcase | 2,506 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.  Read more...
By TJay Belt 2008/02/05 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 7,823 reads