hi, is there a way to put on the code that if the query shows no results then not to send an email ?

basically this dts is just copying tables from another database at another server and copying them to my sql server database. It  usually takes about 3 minutes to run.. i...

thank you i did it and save it and changed the conection to say instead of "local" to the name of my sql server and now the dts works! thanks!

how do i save the package as a file on the server?

i ran:

 SELECT @@VERSION

GO

in my query analyzer in my worstation and got this

Microsoft SQL Server 2000-8.00.2039 and i got the same when i ran it in the server.

when i go to enterprise manager (via my desktop) , go to data tranformation services, local packages, go to my dts, right click , design package...

and this only happens...

but i don't have sql server 2005, i have sql server 2000. what do i do?

again saved my tail! thank you guys.

yes can you please tell me how to do that

what i mean is that when i login in to the actual box where sql server resides , if i use loging using the domain then everything is extremely slow....

Thank you guys!!! i am glad i was in the right track..

question i added the sa as a owner for a database,...

thank you all of you!!!!

thank you for your help!!! ok so i run your code and for some databases in the columns that saays (no column name) only for a couple i have null....

thank you for all your help! ok so i run your query and all my databases come out as

autoclose = false

is this the way it should be?

another thing, in...

hi one thing i remember was that i have sql mail before (not with exchange server) can maybe this be causing the slowness in EM?