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...

good comments and a great article. One other thing that I think should be mentioned first is that the user account should not be SA, but rather a limited rights account....

SQL Server 6.5 is no longer supported by MS.http://support.microsoft.com/default.aspx?scid=fh;%5Bln%5D;LifeSrvr

Are statistics being updated? This could cause things to run slower. Has the data changed much?

Does a recompile of a sproc make it run faster?

Also keep in mind that defragmenting on the hard drive doesn't necessarily defragment your tables. You can have fragmented tables insdie the .mdf files. dbcc showcontig can help you here.