Glad to see that you were able to correct the problem.

Not only that, looking at the code Lowell is writing for you, there isn't enough info (tables or sample data) in your previous post to even work with as it...

Sorry, but I tried using the code you provided to setup a test environment and it is failing. You provided a foreign key reference that apparently doesn't apply, for...

I have aborted a transaction in the past that had been running for over an hour, and it took longer to rollback, so yes, it is possible that had you...

I have to agree with the others, if you don't want the user to insert data, don't give them execute rights to the procedures that insert data into the tables.

Here's the problem. You have given us the code but no data or table structures with which to work with. Since we can't see your data there isn't...

First, not really sure. Can you show us the entire command and the full error message you are receiving?

Second, have you looked at using BULK INSERT to accomplish the...

frustrated

atramard (12/2/2009)

---

So guys basicaly If your transaction log is as big as your disk allowed and the trasaction is not completed, there is not lot you can do as:

- you...

Okay, but looking at the error message it...

GSquared (12/1/2009)

---

Lynn Pettis (12/1/2009)

---

jdurandt (12/1/2009)

---

Oh the humanity....

@Lynne - I agree 100% : Set based processing is the answer in 99% of cases. What I was saying though is that,...

homebrew01 (12/1/2009)

---

I had, through the Services screen. I just tried again, through...

jdurandt (12/1/2009)

---

Oh the humanity....

@Lynne - I agree 100% : Set based processing is the answer in 99% of cases. What I was saying though is that, in the event...

Just out of curiosity, have you tried just shutting down and restarting SQL Server, no server reboot?

jdurandt (12/1/2009)

---

Ok, I see what you mean. that is definitely something that you cannot do with a cursor. Not that I have needed to change the cursor contents in 11...