Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Martyn123
Starting Member
29 Posts |
 Posted - 2010-09-24 : 07:28:45
|
| Hi,Is it good to delete the database using ssms wizard or using T-SQL commands. If I delete the database using SSMS wizard will it keep any traces or information so that it will give problem when I try to create the same DB next time ; like so and so file already exists something like that ?Please reply to this post as soon as possible.Thanks in advance.Martyn. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-24 : 07:53:22
|
| If you're talking about dropping a database, like so:DROP DATABASE myDBThen either method will achieve the same results. Dropping a database will delete all the database files from disk. The SSMS UI will execute a DROP DATABASE statement. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-24 : 09:15:36
|
| There used to be a checkbox to delete backup history too (in Enterprise Manager / SQL 2000). Dunno if that is still there in SSMS these days?That might be a reason for using SSMS rather than T-SQL - but I expect, if it is still an option, that SSMS would offer an option to Script the command, in which case you could generate the script and then use that as a basis for T-SQL commands in the future |
|
|
|
Martyn123
Starting Member
29 Posts |
Posted - 2010-09-27 : 05:59:28
|
| Thanks buddies for taking ur time out and replying to my post. |
|
|
|
|
|
|
Deleting DataBase using wizard or T-SQL cmds?