A network person I am not, however, this looks like a netwrok issue. Please remember, I consider everything from the network card in the desktop to the network card...

I think it would help to see the whole error message. There may be other messages that will help determine what occurred.

You have to decide which you want to do. Issue with direct to tape, one it is slower than direct to local disk. Two, if you have a...

This is a might broad topic to cover. A general answer is yes, there is a way to change the isolation level within a procedure. This, of course,...

Not saying that at all. I'm focusing on what everyone else is focusing on, which is not about the wording of the question.

Do you have a backup of the database prior to when the data was deleted?

Did this error just start happening or have you been getting a while? When it started had there been ANY changes in the database, app, OS, network, etc? ...

Is the data restricted to a 12 month period or is there more than one year?

Also, referdate would go in place of getdate().

Bru Medishetty (11/19/2009)

---

Bru Medishetty (11/18/2009)

---

forumdog (11/18/2009)

---

Alot of very rude and what appears to be blatant disrespect and rudeness so far. Okay you arrogant and unhelpful people. May life and God...

Forget the question for a bit. ...

Not only that, even when the next best thing since sliced bread does arrive, SQL isn't going to go away over night. Want proof, look at COBOL. I...

Mayhem? I didn't see any mayhem. Lots of disgruntled posts, yes. I learned quite a bit from the discussion that ensued, some of it not directly related...

Start with, I must, it depends.

I guess it would help if you provided us with an example. If it would mean writing a multi-statement TVF, unless you could guaranttee...

rparakalla (11/18/2009)

---

Lynn Pettis (11/18/2009)

---

rparakalla (11/18/2009)

---

Yes I would also agree. The names may be different but refer to the same person. So they are equivalent. But the output of getdate() and...

rparakalla (11/18/2009)

---

Yes I would also agree. The names may be different but refer to the same person. So they are equivalent. But the output of getdate() and getutcdate() is different....