I had previously dropped a database thinking I wasn't going to use the database name. Now, I decided to create a database using the same previous name. In Object Explorer, I right clicked on the folder Database and selected the New Database function and then, typed the name of the Database. The message says the file already exists. What else do I need to do to ensure dropping a database encompassses every other relative file is deleted with it (example the log files).? Doesn't "Drop Database" cover deletion of all relative files? Did my administrator only allow certain privileges? Please advise.
Thank you for your assistance.