The size of the tables is not that huge, the snapshot takes only a minute to run, this may change in the future, I don't know. As for backup/restore,...

My initial idea was to dynamically build a snapshot publication including only the articles required, build and re-initialise the subscription, drop the publication and then disable the publishing database for...

Yep, this worked. Thanks.

Ok, here it comes:

This is exactly the article I read before setting the whole thing up. The only problem I have is not being able to retrieve the XML data in a...

Hi,

this is the XML I am trying to render:

BLOCKED_PROCESS_REPORT2009-06-25T22:20:52.7135

No, tried that already. Would not work.

I've been trying to simulate some blocking, the query above does not return any results, while if I run this:

select spid, blocked from master..sysprocesses (nolock)

where blocked = 0...

What I am actually after is the most effective (performance wise) way to log any blocks on a server. Something I could run every minutes without killing a production...

That detailed query to find blocking is just another version...

Ok, what I was missing is:

SET XACT_ABORT ON

After I put it into my SP all worked as expected.

Brandie Tarvin (4/29/2009)

---

Cursor is your best option here, then. Use the below code to get your list of database names. Use the FETCH statement against this list. Plus, add a...

What I want to do is to run lets say 5 scripts against 10 databases (not all of the database, but selected ones) at the same time, so "USE DBName"...

Up! 🙂

Because I don't want to drop the views/indexes and re-create them. Just switching the option on, if it gives the same result, is much more convenient. And...