Ninja's_RGR'us (11/17/2011)

---

If it's still real urgent and you still can't see it you can use this query (it is what activity monitor runs).

--Borrowed from the activity monitor

SELECT

[Session...

LOOKUP_BI-756009 (11/17/2011)

---

Removed the Go and It worked just fine 🙂

Thank You Gail & SQLRNNR.

I am aware as this should not be the right way to get things done, but this...

LOOKUP_BI-756009 (11/17/2011)

---

SQLRNNR : It works fine if I copy out the results of the execution and execute but if I uncomment 'EXEC sp_executesql @sql' and execute I get the following...

Ninja's_RGR'us (11/17/2011)

---

SQLRNNR (11/17/2011)

---

Lowell (11/17/2011)

---

SQLRNNR (11/17/2011)

---

There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

It really depends on the organization as to where...

Lowell (11/17/2011)

---

SQLRNNR (11/17/2011)

---

There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

It really depends on the organization as to where the DBA...

There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

It really depends on the organization as to where the DBA falls in...

Thanks for the article - good stuff.

Thanks for the question.

good question hugo - looks like Steve has fixed it up.

The reason is most likely available in your error logs if you are talking about a database suddenly showing up in the "recovering" state.

Try not executing the sql and ensure the tsql prints correctly. If it does then copy that into a new query window (the message results from the print) and...

Ninja's_RGR'us (11/16/2011)

---

Why, what would you guys do in his shoes?

Dev (11/16/2011)

---

I had one of those. I sat down with the architect and explained to him what NoLock actually...

Brandie Tarvin (11/16/2011)

---

L' Eomot Inversé (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

I got to remember that one!

http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx

GilaMonster (11/16/2011)

---

ashuthinks (11/16/2011)

---

i.m just using this stored procedure for reporting purpose..

please let me know my usage is at right...

Ninja's_RGR'us (11/16/2011)

---

I got to remember that one!

http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx

GilaMonster (11/16/2011)

---

Since when does reporting...

And I have...