Drop Databases

Question

Post reply

Drop Databases

free_mascot

One Orange Chip

Points: 27164
More actions
April 23, 2015 at 9:47 pm

#307333

Comments posted to this topic are about the item Drop Databases
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 1

PRAMANA.DBA

SSCertifiable

Points: 5507

April 24, 2015 at 1:54 am

#1793191

Easy one

alex.d.garland Right there with Babe Points: 749 More actions · Answer 2

Wondered whether this might be a trick question, but the correct answer seemed pretty obvious.

Glad to know I can't accidentally drop tempdb ...

Xavon SSCrazy Points: 2280 More actions · Answer 3

Figured there had to be a trick to this, but no, it was as straight forward as it seemed.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

I figured there would be a trick to it too. Like Alex pointed out, it's good to know I can't do it by mistake.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 5

I knew that the tempdb database cannot be dropped but I have hesitated about the reason. After having thought 2 minutes , I eliminated because it was in use ( tempdb is only for temporary objects ) . So I could find the good choice.

Thanks for this question which had a great advantage : it forced me to think and I am hoping not to forget that it is a system database ( don't try to drop them ... )