Another very useful resource to track down blocking.

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/23/leader-of-the-block-a-month-of-activity-monitoring-part-23-of-30.aspx

Is that message coming from the SQL Agent Job, or the code that the job is running?

Are there any other errors or warnings...

What is the actual error message...

If you use the Reporting Services Configuration Manager to create the new...

Sorry you lost me on a few fronts.

1) you reference another article stating, "The method SSIS Data Pump represents the most effective way to load large amount of data into...

Also, take a look at Enterprise Policy Management Framework[/url] on codeplex.

Allows great policy management and reporting across all accessible SQL Servers, including SQL 2000 & SQL 2005.

Check out RSScripter, does all that and more ...

http://www.sqldbatips.com/showarticle.asp?ID=62

Firstly, I'd ask what is behind the requirement to run the subscription using T-SQL? That really defeats the purpose of setting up the subscription in the first place. When you...

I'd suggest never run the Profiler GUI on a production server without very limited events/columns and strict filters. Even then, on a very busy server, there will be an adverse...

Steve Jones - SSC Editor (3/24/2011)

---

Yes, the folks at Red Gate booked it, not realizing we had a DST change recently.

We recorded it and I'll get a link posted as...

Been lurking 😉

:-D:-D Love that idea Jeff

But seriously, I reckon they need a more stringent posting process so the numerous superfluous cases don't get lodged. If people had to think more about...

Caruncles (3/3/2011)

---

SSCrazy, I like the head-banging avatar. I need one of those and an automatic butt-kicking machine.

I saw this post and have been banging my head trying to set...

Good article.

Would really like to know how to incorporate SQL 2000 and SQL 2005 into the Management Data Warehouse. Think MS slipped up not allowing that.

Sure you can't capture...

TheSQLGuru (10/4/2010)

---

2) I have a client with pushing 40TB on virtualized SQL Servers. And yes, I did mean TERA there and not GIGA. It can be done, but...