I am using SSIS to do something similar.

You can use FOR XML Path('Record'), ROOT('RecordList') at the end of your query to generate an xml result set. Then you can...

I see an iPad and SQL Monitoring improving response to issues after business hours. We are a 24 x 7 shop, and have to provide support after hours. ...

Hi

I know you have solved this already, but wanted to share something I had also used. I used this because I had problems with adding the Select before the...

Good Work! Sorry to not be of more help.

Thanks for posting your solution

I have had similar problems when database mail profile was not set to public. Is the public checkbox checked for your profile?

who owns the job?

Have you gone through the steps of setting up an operator under SQL Agent?

After setting up database mail, you have to go under operators in SQL agent and...

Thanks guys. I have a server that had over 10 of the 13 gib paged out from under it today. I am still in the process of troubleshooting,...

Thanks. I guess no issues?

What kind of replication is being used? Are the distributor and publisher on the same server? Are there any cross domain issues here?

Thanks for posting that...I don't feel quite so bad for not knowing it was a registry key that had been updated

Sorry for the delay, out for Thanksgiving.

Yes we are on the latest version of Litespeed. For some reason we are still running without failure since changing to...

I have watched it during backups and while it does drop, it never goes below 1.4 gb available.

I was just wondering if I had missed something. Thanks again for...

I do have a follow up question on why you say 12 gb is normally the upper limit of what is safe. Can you tell me what that is...

Thanks guys! I appreciate the help.

I posted here because we didn't really get a quality answer from Quest Support, and I was hoping someone else might have experienced the...