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

Articles with tags Miscellaneous, Stored Procedures, Configuring Rss

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

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

Search for any content tagged Miscellaneous & Stored Procedures & Configuring

   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,964 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 | 33,146 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: |  Discuss |  Briefcase | 17,382 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,301 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,964 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 | 33,146 reads
   Items 1 to 6 of 6