We had a discussion yesterday about Management Studio, and we focused on the “Delete” command. In SQL Server 2005, you can right-click a database and select “Delete”. You get a panel where you can set some options, or you can just click OK and the database is gone. Unless, that is, there are people connected to the database – in that case, you’ll get a warning, which has saved me multiple times!
But the bigger question came around the idea that it shouldn’t be too easy to delete a database. The argument was that we are already bringing up a panel and asking you to click OK, so that is a confirmation panel. And I know a lot of people really hate it when we ask “are you sure you’re sure?” all the time. Of course, we also get lots of angry mails when we don’t warn people.
But I wonder if on something as big as deleting a database if we should. What do you think? Should we pop another warning that you’re about to do something kind of dangerous like delete a database, or should you be allowed just to blast through there?