ok, I had left out the job part of it but if this is too much, I'll let it go.

Close to what you need?

IF OBJECT_ID('tempdb..#dbs') > 0

DROP TABLE #dbs

IF OBJECT_ID('tempdb..#Drives') > 0

DROP TABLE #Drives

IF OBJECT_ID('tempdb..#Results') > 0

...

It's close to what you need. Doing the logs from this would be a bit harder because the logs are always going up and down (unless you forgot to...

I'd thank gail first... and then google. 🙂

No, but maybe I can check both execution plans to see if I see something.

Ya I know of those limitations. That's why I was hoping someone had something already tested.

The only option I have in mind right now is sp_WhoIsActive. You should...

The set option is not the correct solution for this problem. But it may in the future and I thought you needed to be aware of it.

ISNULL was definitely...

f.limani (5/11/2011)

---

Mike01 (5/11/2011)

---

I tried it and I get the error "Value of 125 is not valid for value. V alue should be between Minimum and Maximum Parameter name" When...

Have you used the rollback immediate option?

I've used dbcc input buffer in the past to do that (sql 2000).

Maybe there's a dmv now for it but I don't know it on top of my head.

Never used sharepoint. Something I should avoid even with all...

Steve Jones - SSC Editor (5/11/2011)

---

WolforthJ (5/11/2011)

---

It is amazing how ingrained in the culture of IT the idea of always being ready to quit is. Steve's expression of it as...

steve.hale (5/11/2011)

---

I have this same problem and even the '[userOfView].[viewName]' syntax does not work for me when run as "sa". Apparently sp_refreshview was modified to call sp_refreshsqlmodule, which also...

MS should really learn to read their own whitepapers... they'd learn a lot :w00t:.

Actually I would put the name in brakets as well. In my system half the columns use spaces and other funny characters. This is most likely why I...