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,
DianaThe only problem I can think of is to do with the table
sysdatabases in the master database.
If you refer to the database by its dbid anywhere then
there is a good chance it might change when you re-create
it.
Peter
"The best minds are not in government. If any were,
business would steal them away."
Ronald Reagan
>--Original Message--
>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
>.
>|||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...
> 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...
>> 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
>
>.
>