Have the DBs perhaps been changed to simple recovery?

So do you have an...

Likewise, same with log shipping,...

Then why did you post info about it in your first post on this thread?

Then this should do it.

WHERE Status = @status OR @status IS NULL

There is, but it tends to have interesting...

Arun (2/4/2009)

---

I was thinking that log shipping is just an automation of the normal transaction log backups and restores which we normally perform. but it didnt fail even after i...

Having just started a consulting job, I would recommend that you have at least 4 months income (if not more) saved up before making the move. Work doesn't come instantly...

NotManyPoints (2/3/2009)

---

Do they just come to this site and their job with their DBA (specifically categorised role) blinkers fully welded into place. Until the shift whistle blows and they...

Where?

charlesz (2/3/2009)

---

The contents of Varchar(MAX), NVarchar(MAX), VarBinary(MAX), and XML fields are encoded using "Partially Length-Prefixed" (PLP in short). A PLP stream starts with total length (8 bytes), followed by current...

Try it and find out. My SQL 2000 instance is 400km away.

There's a 16 column limit to index keys. As Kimberly Tripp is fond of saying, that's a limit, not a goal.

I think you left a not out of that statement

idrees.butt (2/3/2009)

---

Actually I have been working in writing SPs...so I dont think I should get a book that just tells syntax etc... I need to get insight of pros and...