Good to hear.

Yeah, replication can be a pain sometimes. Glad you came right.

I'll give it a try, but it won't be in the next couple of days. I've got *real work* that needs doing :crying:

It's as easy as changing the properties of the server, no hacks necessary. A restart of the SQL instance is required for the change to take effect

All SQL logins will...

I wouldn't call 200000 rows small. 🙂

Check the number of pages in the table. Don't worry too much about tables with < 100 pages.

How big are the tables in question? How many pages? (you can see that from the full output of index physical stats)

My guess is that the tables are very small...

Can you post the code please? There are places where you would have to explicitly cast as varchar/nvarchar(max) or be cut off at 4000/8000 characters. Considering the length is...

Depends on the plan the optimiser comes up with. Sometimes it does, sometimes it doesn't. The order...

If there's an existing index on a table on (for example) columns A, B, C...

Can you check the connection string that the app uses, see if it specifies an initial database. Also check what the default database is for sa.

A properly set up account...

Can you please post the table definitions, the index definitions and the execution plan?

To get the exec plan on SQL 2000, run the query with SHOWPLAN_ALL on, run to grid,...

That...

Congrats. Is this your first time speaking?

State 16 means that the default DB or the DB requested by the login is not available. Check what DB the app in question wants and make sure that it's...

Do you know why the transaction log is growing? If you have regular log backups, it should not be continually growing.

Query the sys.databases view and see what the log_reuse_wait_desc column...

Unless you had one of the traceflags on or a profiler trace running with the deadlock events, there's no way to tell now what happened.