You're missing the pertinent point. Yes, you need a query window to issue the command, but you must not have a connection to your warm standby database.

Close QA and...

In that case the client will need to get the application customised for SQL 7.0.

Cheers,

- Mark

Sorry but no.

BTW. There's no need to crosspost your question... it will get answered.... usually

Cheers,

- Mark

Although I hate to resort to it... you can try an index hint in the query to force the clustered index use.

Cheers,

- Mark

Although I hate to resort to it... you can try an index hint in the query to force the clustered index use.

Cheers,

- Mark

I think your client is stuck with upgrading to 2000.

Cheers,

- Mark

Why don't you run the same query from OSQL and send the output to a file?

Cheers,

- Mark

Maybe you query overuses HAVING and WHERE would be most appropriate. Can you state what the query is trying to accomplish?

Cheers,

- Mark

quote:

---

I made sure no one but me is using the database

---

Make sure EVEN YOU...

I did have a problem once when setting up a 5-digit port - not wanting to interfere with any well-known ports, and it was reset (by SQL?) to a 4-digit...

Why don't you create 'USTRESACC\cccsqladmin' as a login on the other server?

Or, in linked servers, for that server, change from windows authentication to SQL authentication, and give the credentials of...

I don't think you can modify sa'a sysadmin privilege

Cheers,

- Mark

Some suggestions:

1) if you're using 1 statement to delete all 14 million rows, try to avoid doing so. Try a series of deletes that delete batches.

2) if you're using...

If MSSQLSERVER is running under an admin account you certainly can.

Reminds me of the time I used it (for security purposes) to stop sqlserveragent, start sqlserveragent, stop dhcp,...

It appears to be a fixed number.

There's registry key:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL Query Analyzer\Recent File List

but playing with it has no effect.

Cheers,

- Mark