drop / create new database with old name

Hi,
Is it possible to drop and then create a new, fresh
database with the same name as the database just dropped
or would this cause problems? I don't want to recreate
this database from backups as there are concerns.
Thanks,
DianaThat should cause no problems... is there some reason you would expect it
to?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"DianaR" <anonymous@.discussions.microsoft.com> wrote in message
news:0b7f01c51837$db2c5230$a401280a@.phx.gbl...
> Hi,
> Is it possible to drop and then create a new, fresh
> database with the same name as the database just dropped
> or would this cause problems? I don't want to recreate
> this database from backups as there are concerns.
> Thanks,
> Diana|||Hi Adam,
No, no reason... just wanted to make sure.
Thanks for your reply.
Diana

>--Original Message--
>That should cause no problems... is there some reason
you would expect it
>to?
>
>--
>Adam Machanic
>SQL Server MVP
>http://www.sqljunkies.com/weblog/amachanic
>--
>
>"DianaR" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0b7f01c51837$db2c5230$a401280a@.phx.gbl...
dropped[vbcol=seagreen]
>
>.
>