GilaMonster (9/1/2011)

---

SQLRNNR (9/1/2011)

---

Reminds me of a story about my mother-in-law. A duck was in her garden. She went to chase it away and the duck bit back. ...

Looks like just the tools upgraded and not the database engine.

More of an issue to make sure ducks are in a row. Want to make sure a migration is planned out properly and that takes time.

Jeff Moden (9/1/2011)

---

SQLRNNR (9/1/2011)

---

GSquared (9/1/2011)

---

I've hated horses ever since I had to ride them every day to get to the school bus. It was only up hill one way,...

GSquared (9/1/2011)

---

SQLRNNR (9/1/2011)

---

GSquared (9/1/2011)

---

I've hated horses ever since I had to ride them every day to get to the school bus. It was only up hill one way, but...

GSquared (9/1/2011)

---

I've hated horses ever since I had to ride them every day to get to the school bus. It was only up hill one way, but it was...

varsity

Nice question. Better than the question is the explanation given.

Thanks Paul.

webtekkie alludes to another important thing.

This really is an effort that requires communication and teamwork. Net Admins and DBAs together should be working to physically inventory the SQL Instances...

Those databases if not maintained can pose a risk and threat to your entire environment.

I agree with Roy. Based on the info, I'd start by removing the cursor.

It also appears that you are using temp tables for staging the data. Are these...

toejam

Read the first article in my sig. Gail walks you through how to post that info.

On second thought - there is the procedure cache.

Try this:

http://sqlserverpedia.com/wiki/Queries_in_Procedure_Cache

Keep in mind, that this is not a fool proof method to retrieve past queries.

Without some form of logging that you setup (like triggers or traces) - no.