can you please post your script that sends emails?

hello, thank you for your script, question how can i run with my other servers?

in the article it says to create an ssis package, would you happen to you the steps? can i use the export/import wizard? do i put the code in a...

thank you again

😀

hi Ignacio, i am trying to do what the article says to be able to get the information from the other servers but the problem is that my other servers...

humm... ok let me see if i can follow the article without doing it then. thank you for all your help!!! i really apreciate it.

thank you!, i just needed for to this http://www.sqlservercentral.com/articles/Integration+Services/61774/

I am not sure what you mean with disconnecting from sql objects eventhough i am doing it first in my development server...

thanks so like this:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'Ole Automation Procedures', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

EXEC sp_configure 'xp_cmdshell', 1

GO

RECONFIGURE WITH OVERRIDE

GO

after i ran it i get this :...

ok thanks!

is this correct?

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures', 1;

GO

RECONFIGURE;

GO

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'xp_cmdshell', 1

GO

RECONFIGURE

GO

Thank you guys!! 🙂

hi quick question when you use the import\export data wizard does that lock the source tables?

thank you, for now eventhough the back up and restore seems to be the easiest way to update the data of the tables, we can't do it since in the...

the execution plan shows a couple of parallelism cost 1% and a couple of hash match cost 2%. No index scans.

thank you i will.. for now can you just tell me if putting the with (NOLOCK) for each select statemment is good? this is only a select query, no updates.