WOW! Great replies; the perfect reason why I love these Boards!

First off thanks to all for replying. Seen several great tips in various posts, some of which I...

Jeff Moden (10/20/2009)

---

I know that the use of cursors and loops for flow control is an acceptable use but... I just can't bring myself to write one if there is...

Garadin (10/20/2009)

---

Depending on how many different entities / how long each takes / what kind of downtime you have in the evenings / etc, it might be worth looking into...

Garadin (10/20/2009)

---

Assuming that the real code will use DATEADD instead of +1 to modify the dates, it seems like it would work better. What determines the values that you...

ALZDBA (10/12/2009)

---

In that case, check your databases ! One of them (if not all) may contain a wam_bam schema name !

And the user may have that schema name as default...

The actual T-SQL doing the update is in a STORED PROCEDURE. What I'm looking for is a way in a SQL JOB (so it can be scheduled to start...

UPDATE:

Well yesterday I managed to have TaskMgr open and running when SSMS locked up and while there was no query or other task (like Activity Monitor) running, the process that...

No, the wam_bam (thank you mam) account is a service account on...

Jeff Moden (10/5/2009)

---

I don't know what it's called in Vista but turn on the equivalent of TaskMgr and see what the cpu and kernal are doing. If the cpu...

Thanks for the feedback guys.

Nevrmind, I figured it out after going back thru SQL Magazine issues from 2001. It was called Tips, Tricks & More and was edited by Brian Moran. I...

Heavy sigh 🙁

I can't believe there's not even some kind of import/export for this. Oh well.

"The grass is always greener on the other side of the monitor"

This is clearly a case of human/person to person communication then technological needs and responsabilities. Those who have...

Good point since I left out the fact that they aren't all using Integrated Authentication.

At...

I assume then that it happened to you as well when trying to do this Template edit/save in some way other then you described as the solution?