I've configured my SQL Server 2000 database maintenance plan so that everything works—except the transaction log backups. Why will full backups work but not transaction log backups...
I have a huge table that doesn't have a clustered index but has a couple of nonclustered indexes. Because this table is so large, we occasionally receive index corruption errors such as "The index entry from row ID...
How can I determine whether my SQL Server (which is running on Windows NT) is using the domain account or the local account as its Windows user account?
Service information—such as information about dependen...
I'm running SQL Server 2000 Standard Edition on a Windows Server 2003 system with 2GB of RAM, and one of my SQL Servers is showing a large number of connections, hundreds of which have a connection status of EXECUTE...
I'm trying to debug a T-SQL stored procedure, but when I start debugging, after getting the parameter dialog box from Query Analyzer, I get the following error message...
Let's say I have a Sunday full backup and Monday through Friday differential backups, and I restore to Monday's differential backup by restoring the Sunday full backup followed by a Monday differential. If some of the...
I have two servers, and I want to call a stored procedure with the server name as the parameter and have the stored procedure's T-SQL query run against the appropriate server, as in the following code...
I need to see all the articles for a given publication in my replication setup. Is there a system stored procedure that lists all a publication's articles...
I've implemented an Active/Passive failover cluster for SQL Server 2000. How is Active/Active mode different from Active/Passive mode? And is it possible to perform Active/Active clustering for this version of the...
