Is your operator mail list in SMTP format?

I am using database snapshots. It is one of the first features we made use of. I automate a job process to allow (certain trusted) users (processes) to request a snapshot....

If this was stated above anywhere sorry for the repeat...some Virus scanners block port 25 so you might need to add the follow exe to the Virus scanner port 25...

Good article. I agree that there are times when one has to use dynamic sql. Further, in the many cases that I have used it, the run time even with...

You can of course use the Values clause but if you want to call functions to generate some new data then use the select statement...insert into >tablecolumnlistfunctionetc. until column list...

Good thoughts Mark. Thanks for your input.

I think master.dbo.xp_sqlagent_enum_jobs reads from memory (pretty sure) and appears to give you what Enterprise Manager (EM) returns whereas msdb.dbo.sp_get_composite_job_info and msdb.dbo.sp_help_job get their information from the systemtables. The difference...

Yes, you clearly stated that but what's your beef with "undocumented"? This extended proc is documented somewhere (inside Microsoft)...it's just not available to us, though I'm sure some one could...

Leo, I used a similar approach some years back but then found a better way...it makes use of xp_sqlagent_enum_jobs which gives the actual running status of a job (among other...

Interesting, Sean, 'God bless you' is offensive but cursing is sometimes okay?! This is more like "How to Mess up an Article about How to Mess up an Interview".

All,

I just yesterday used the techique at a contract client with similar results although not quite as dramatic as the one I wrote about. To be fair though, there is...

You are correct for the code I listed in the article. I did change it in the final results here at work to remove the last comma.

This doesn't pivot the results. I wanted the the data from several matching rows in the Many table to come back as a single value of data separated by commas...

Stephen,

In my actual code the data needed to be order in the pivoted result set. If one doesn't care about the order then your correct, the order by is not...

The next generation nuclear plant will be something of the design called a pebble bed reactor. Here is a link...

http://en.wikipedia.org/wiki/Pebble_bed_reactor

The coerciveness of salt and the difficulty of dealing...