Top "Sql-server-2000" questions

SQL Server Tempdb LOG file growing

On a SQL Server 2000 system, I have a templog.ldf file that seems to grow without bound! But when I …

sql-server-2000 size transaction-log tempdb

Extra spaces being added at the tail in the column

When I am saving data into a table, extra spaces being added to the valued at the tail. I observed …

sql-server sql-server-2005 database-design sql-server-2000

SQL Profiler (SQL Server 2000), how to filter only my activities?

We have a big system with several hundred concurrent users so sql profiler gives a bit too much information without …

sql-server sql-server-2000 sql-server-profiler

How can I find unindexed foreign keys in SQL Server

I have a SQL Server 2000 database with approximately 220 tables. These tables have a number foreign key relationships between them. Through …

sql sql-server sql-server-2000 foreign-keys

How can I use sp_xml_preparedocument on result of NTEXT query in SQL 2000?

I know NTEXT is going away and that there are larger best-practices issues here (like storing XML in an NTEXT …

sql-server xml sql-server-2000 types sqlxml

Removing All Primary Keys

This is going to sound like a crazy request. The databases that I report from do not have any foreign …

tsql sql-server-2000 constraints information-schema

SQL Server Deadlock Fix: Force join order, or automatically retry?

i have a stored procedure that performs a join of TableB to TableA: SELECT <--- Nested <--- TableA …

sql-server error-handling sql-server-2000 deadlock database-deadlocks

SQL Server Error: maximum number of prefixes. The maximum is 3. with join syntax

Trying to run a cross-server update: UPDATE ASILIVE.CustomerManagementSystem.dbo.Sessions SET ASILIVE.CustomerManagementSystem.dbo.Sessions.VarianceAmount=Variances.VarianceAmount FROM …

sql-server sql-server-2000 linked-server

Export to excel from SQL Server 2000 using Query Analyzer code

What's the easiest way to export data to excel from SQL Server 2000. I want to do this from commands I …

sql sql-server sql-server-2000 query-analyzer

Why can't I get the @@rowcount value?

Below is a simplified version of SQL script I have. print @RowNum always shows 0, rather than the real record number …

sql sql-server sql-server-2000 rowcount