Is there any reason why it shouldn't be ?

If you can connect to a source, you can (bulk) insert from it.

indeed, but that should not be a general practise

and these cases' hint accuracy should be re-evaluated often.

maybe http://www.sql-server-performance.com/da_email_functionality.asp can help out.

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