CirquedeSQLeil (3/10/2010)

---

YSLGuru (3/10/2010)

---

Jason - In our particular case, for just this one server it actually would take less time to switch over to the standby server and while it is...

Steve Jones - Editor (3/10/2010)

---

I'm late, but I always have done daily master, msdb, model. Things rarely change, but they always seem to have changed right before something breaks. They're...

homebrew01 (3/10/2010)

---

YSLGuru (3/9/2010)

---

First off thanks to everyone who has taken the time to contribute, it is appreciated as always.

What has been said so far in each reply is in...

ALZDBA (3/10/2010)

---

Well ... in your typical scenario .... there shouldn't be any user databases !

From the moment you add a user database, you should have a DRP in place !

That...

CirquedeSQLeil (3/9/2010)

---

YSLGuru (3/9/2010)

---

If you have a brand new out of the box install of SQL Server 2005 and the only thing you do to it is set it to use...

Lynn Pettis (3/9/2010)

---

Two reasons, first of the chances of that system remaining in that state for any significant time is small. Things change and you should plan for it...

First off thanks to everyone who has taken the time to contribute, it is appreciated as always.

What has been said so far in each reply is in agreement with...

Lynn Pettis (3/9/2010)

---

Simple answer, yes. The only system database you can't backup is tempdb, which makes sense as it is recreated every time you restart SQL Server.

As to frequency,...

I know what I'm looking for but I'm not that familiar with Profiler itself and I was hoping to save myself an hour or two's worth of work by getting...

Thanks for the offer Toby; I was wondering what I said wrong for this is the first post ever to not get a couple of responses when the post wasn't...

Wow. This a first for me. I've never had a post go with this many view and not one reply at all.

Did I ask a dumb question?

mstjean (2/10/2010)

---

Glad you like it.

By the way, my identity is not "SSC-Enthusiastic", just as yours is not "Forum Newbie".

Generally you should try to avoid using cursors in tsql-- with...

Lynn Pettis (1/28/2010)

---

Have you looked at exporting the SSIS package to the file system? I haven't done this, as our SSIS packages are also stored in VSS and if...

Thanks guys, I knew it would be something simple.

Jack,

I just tested out the CTE and it does work when MY_TABLE_HISTORY has just one value for sNane or 1 table name. The problem is getting the first &...