delete a record

Before I get into my question let me give you a little background on me first. I am a ASP programmer and I know enough about SQL Server (user side) to manipulate records to check my screens.

As the title suggests, I am not able to delete a record from an sql table and I was able to about 2 months ago. About 6 months ago the DBA had to make some setting changes on my machine and it was all good. The last 2 months or so, I worked on another project. Then about 3 days ago I went to delete a record and it wouldn't let me. The only thing I can imagine is 2 months ago when I had to have someone reset my user profile on my machine, it overrode whatever it was that the DBA had done.

Well you might be saying "well get the DBA back down to fix it." He took a promotion to another agency 3 months ago and the new guy couldn't help me. In his defense, he is an interim until they can hire an experienced DBA. Sorry for being so long winded. But if anyone could point me in the right direct开发者_如何学Cion, I would appreciate it.

---

Run EXEC SP_HELPROTECT 'youtable'. Then look at the deny statements. Follow up from there.

---

What error are you getting? Is this through SQL Server Management Studio, linked table in Access, ASP, or what? In this case, it could be many different things: he may have saved the user name and password you were logging into the SQL Server with, and it got blasted with your new profile; it could be that he revoked your delete rights on the SQL Server, etc... it could be many things.