fragmentation may also be the case.

try rebuilding the table's clustering index.

In the sp2 fixlist ( http://support.microsoft.com/kb/921896 )

there is a fix included regarding agent and alerts. Maybe that's the issue.

Check it out and if you can upgrade to sp2. Don't forget...

http://blogs.msdn.com/sql_protocols/archive/2005/11/10/491563.aspx

states

By default using SQL Native Client your login packet will be encrypted over the wire so as to not disclose your password. This encryption is supported by...

I also found this overview :

http://www.sql-server-performance.com/faq/sql_server_management_studio_load_time_p1.aspx

the way we did it, it's just a windows thing.

each user has a SID-history in windows, apparently the current sid as well as the sid-history sids are being used to...

indeed, it may even be your server instance's selfcreated certificate to encrypt e.g. connections, ...

only if a rollback is issued all transactions are undone if the transaction count <> 0.

you can use the @@trancount to check if a transaction still exists.

- check raiserror in...

I think you may be better of using xp_fileexists.

http://www.sqlservercentral.com/Forums/Topic360785-9-1.aspx

any hint is a means which you can use to actualy influence a queries behaviour !

It should be an exception to use a hint, and its purpose should be tested...

- builtin\administrators is a windows thing. Removing it has nothing to do with being able using the sqllogin 'sa'

- sa is a sql user, maybe some 1 did also change...

we just created the same userid in the new domain and imported the old domain's user SId in the SID-history list of that user in the new domain.

-Thanks for the tip. It doesn't change much overhere. (it was unchecked, I checked it and didn't notice big a change)

- I'm using the /nosplash startup parameter, this...

- as you have read, you must take very good care when designing and creating partitions and indexes.

- be sure indexes are alligned !

- indeed, reorg. 1T rows isn't going...

- I'd suspect page splits (clustering index) and file autogrowth.

- work with transactions

- avoid the cursors, do a direct insert in stead !

- insert rows sorted according to the clustering...

did you check Kimberly's very good white paper on partitioning ?

http://msdn2.microsoft.com/en-us/library/ms345146.aspx

it contains very good sample scripts !:smooooth: