delete a record

Question

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 direction, I would appreciate it.

Answer 1

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.

Answer 2

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