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

Articles with tags Administering, Configuring, Stored Procedures, SQL Server 7, 2000 Rss

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

Miscellaneous (4)     Indexing (2)     Distributed Queries (1)     Programming (1)    
T-SQL (4)     Security (2)     English Query (1)     Replication (1)    
Basic Querying (3)     Triggers (2)     Monitoring (1)     UpdateGrams (1)    
Installation (3)     User-Defined functions (2)     OpenXML (1)     Visual Basic 6 (1)    
Backup and Recovery (2)     Basics (1)     Performance Tuning (1)     XML (1)    
DTS (2)     Database Design (1)     Performance Tuning and Scaling (1)     XSL (1)    

Search for any content tagged Administering & Configuring & Stored Procedures & SQL Server 7, 2000

   Items 1 to 6 of 6   
 

Attach and Detach..Again

Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!   Read more...
By Andy Warren 2006/06/23 (first posted: 2002/04/05) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 22,830 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first posted: 2002/02/11) | Source: SQLServerCentral.com | Category: Installation
Rating: |  Discuss |  Briefcase | 32,922 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: Installation
Rating: (not yet rated) |  Discuss |  Briefcase | 17,269 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: Installation
Rating: (not yet rated) |  Discuss |  Briefcase | 6,283 reads

Attach and Detach..Again

Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!   Read more...
By Andy Warren 2006/06/23 (first posted: 2002/04/05) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 22,830 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first posted: 2002/02/11) | Source: SQLServerCentral.com | Category: Installation
Rating: |  Discuss |  Briefcase | 32,922 reads
   Items 1 to 6 of 6