question

Mohamed4053 avatar image
Mohamed4053 asked

Facing some issue while deleting the SQL SERVER DB using Sa account.

Facing some issue while deleting the SQL SERVER DB using SA. I have tried to delete a database from SQL server through the script, I am getting error as Msg 3701, Level 11, State 5, Line 1 Cannot drop the table 'Backupcheck', because it does not exist or you do not have permission. But same database i have tried to delete through GUI Mode. I am able to delete the database. I don't know why i am unable to delete the database. Please can you share you idea's if you have any idea's.
sql serversql 2008
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
You say database in several spots, but if you read the error message, it says table. So, I'm guessing, you have a syntax error in your T-SQL statement for dropping the database.
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mohamed4053 avatar image Mohamed4053 commented ·
Thanks for correcting my mistake....
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Not a problem. Don't forget to vote good answers up and select an ultimate answer.
0 Likes 0 ·
Mohamed4053 avatar image Mohamed4053 commented ·
Sure Sir..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.