Thanks for the reply.

I've tried that, but with no good results.

Now I would want to connect using the system dsn.

EXEC

master.dbo.

well ... as already mentioned, you have to provide an order by clause if you want data guaranteed in a certain order.

BTW Don't use the order by in a view...

If the server can reach a shared location there is no problem.

put your backup file(s) at the shared location and restore it from the shared location.

e.g. put an xcopy-cmd at...

- keep in mind the responce to the alert is assync ! You may not find the situation anymore.

- Start traces 1204 and 3605 so you get the deadlock info...

- Are the service accounts the same  for sqlagent and sqlserver ?

- we use smtp-mail so we don't depend on all the hassle with the outlook client. you can check it...

That's a big 10-4

During pre-aggregate phase, the fk-indexes will speed up the queries wherever possible. The relationships themselves indeed can be dropped.

Keep in...

another nice ref regarding impact of shrink operations :

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

there are serveral ways to shutdown sqlserver:

- service manager

- TSQL : Shutdown

- net stop sqlserver

- EM rightclick servername / stop

They all shutdown sqlserver.

If there are open transactions going on (They...

... Is it necessary to maintain the production relationships in the first place ...

- maybe not the actual FK's , but certainly keep the FK-indexes because They will speed up queries...