If this is very large, I tend to delete in batches of 100, 1000, whatever works.

DTS is probably the simplest if it's a few tables and you are doing it rarely. Be sure you check the "keep identity" box.

IE 5? Mozilla 1.6? There are a few issues. IE 6 seems to be the most stable.

Apologies, this has been a tough bug...

The patch should apply fine and you shouldn't experience any problems from the admin side, however the functionality of SP3 is slightly different. Lots of security changes, but also some...

Total is what it's using, Target is what it wants. If this is different, then there will be more swapping to disk and performance can be affected. It could appear...

I believe you can script this from EM. right click the database, generate scripts and check the permissiosn item.

Note: the logins and users must already be the same on the...

I'd double check that it is truly recreated correctly on the right table, same owner, etc.

Use quotes around the path

run \\myserver\c$\program files\microsoft SQL Server\80\tools\isqlw.exe

I'd guess your SP is corrupted somehow. Can you reapply it?

Check that the ODBC connection is configured to use Window Auth. I believe it is from this message you are posting.

It is a windows credentials not being passed through problem....

Good for you! That's one of the few battles that I will constantly fight.

No sa for developers

Have you run a dbcc checkdb to rule out physical errors on these two?

BTW, you want Auto Create Statistics and Auto Update Statistics on unless they are causing a problem. Now that I'm thinking of it, I'm not sure how to monitor that....

After Frank's diatribe, I'm not sure my input is needed, but here's a couple thoughts.

1.In SQL 2000, dynamic SQL can be cached as well, so there is slightly less of...

It should also rebuild at its original size when the server is restarted.

The other item is that your .ldf is used for transactions, but committed transactions are removed at a...