I have saved a trace file from SQL Profiler using the tuning template. I have
3 questions related to running this against the tuning advisor:
1) When I try to run the trace in the tuning advisor, I get "98% of consumed
workload has syntax errors". What does this mean?

I did a SQL 2k to 2k5 migration using the detach/attach method. The
migration went successful. After the migration the SQL logins were disabled.
The password complexity was enabled in 2k5. I unchecked password complexity
and enabled the SQL login, however I am still unable to log ...

I am working on a Access Sql system where I need to put a new release for a
system. This system involves transactional replication. Most of new screens
and code relate to client side sql server and the main server. When I am
trying to test some functionality on the server (main) ...

set transaction isolation level read committed
alter database mydatabase set read_committed_snapshot on
From the Sql Server docs :
"Row versioning is used to present each statement within the transaction

Hi.  In SSMS (9.00.3042) I'm trying to generate a single file containing
ALTER statements for all the SPs, views and UDFs in a database.  In the
Generate Scripts wizard, I've only been able to generate create and drop
statements.  Any tips are appreciated.

Tomorrow AM, I am going to reinstall SQL 2000 on a new server for a client
of ours as this client's soon-to-be old server has run out of disk space.
I hope to obtain the SQL license key in a timely manner from their IT
department.  In case I cannot get this key as quickly as I'd ...

Just wondering if anyone can offer me any advice on a new SQL server
setup I am putting together.  We are trying to squeeze as much
performance out of a new server as possible.
We are looking at getting a DL380 with a quad core xeon, 4gb ram and

We have a server in a workgroup that users in our active directory
will need to access.
How can we configure an odbc connection to use a different username
and password (windows not sql) than the one they are currently logged

I'm moving to SQL Server 2005 on a new box.  In SQL 2000 I have a three step
SQL job that:
1. truncates data
2. runs a DTS package

Hello,
I have SQL Server 2000 with the latest service packs. I also have Visual Source Safe 6.0. My application has a lot of Stored Procedures and user defined functions with SQL Server. What is the best way for me to track changes of these procedures within VSS. I am developing ...

If I purchase a single proc license for SQl 2005 Standard, can I use that on
a 2-node failover cluster witout any additional licensing?
If yes, could you please point me to some MS link?
Thanks.

i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database on
customer site installed on C Partition ....MDF file is 300 MB but LDF file
became 12 GB  which took all of the C Partition Space.. Our Tech Supp Person
have moved these Physical Files From C to D ...

I am new to MS sql server (2000) and have couple question regarding the
backup.
We are running sql server 2000 and the enterprise manager is configured
to perform a full database backup daily. My question is do I have to

I'm experiencing a strange problem with query performance runing on
SQL2005. The database has 10+ tables, but we need to run really
specific queries in only 1 table with these caracteristics :
- 1 million rows

Can you please help me with the following problem:
My website keeps crashing and the FullText Search cannot start. I keep
getting errors 7003 in the Event Log with the following message:
Event Type: Error