x

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.

more ▼

asked Jan 21, 2014 at 09:19 AM in Default

avatar image

Mohamed4053
221 12 18 22

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jan 21, 2014 at 10:29 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

Thanks for correcting my mistake....

Jan 21, 2014 at 11:01 AM Mohamed4053

Not a problem. Don't forget to vote good answers up and select an ultimate answer.

Jan 21, 2014 at 12:40 PM Grant Fritchey ♦♦

Sure Sir..

Jan 22, 2014 at 04:27 AM Mohamed4053
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x225
x13

asked: Jan 21, 2014 at 09:19 AM

Seen: 538 times

Last Updated: Jan 22, 2014 at 04:27 AM

Copyright 2017 Redgate Software. Privacy Policy