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...

Are the other databases located in the same directory?

Care to share a link to the article? Not really sure what you are asking about and that would help.

Glad to be of assistance.

Gift Peddie (12/1/2009)

---

Lynn Pettis (12/1/2009)

---

Gift, he is trying to look at the code behind the system views which is not possible by right clicking on the view in the Object...