Reassigning or Assigning DBID

I have someone who wants to assign a specific DBID to a database. For
example, he wants a database named 'duplicate' to be dbid '20'. Is this
possible? If so, how can it be done?
NathanI don't believe it's possible but what possible reason could he have for
wanting that? You don't want to build a dependence on a DBID into your
application. Tell him to forget it is my advice!
--
David Portas
SQL Server MVP
--|||I totally agree with David on this one, what possible reason is there for
this ? For the sake of it though, you just need 19 databases and the next
one is 20. If you have more than 19 already then detach the one that has
dbid =20 and create/attach the database and voila it has dbid=20. Again,
this seems fairly pointless...
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<none@.nnn.com> wrote in message
news:OVRkG2sNEHA.2704@.TK2MSFTNGP10.phx.gbl...
> I have someone who wants to assign a specific DBID to a database. For
> example, he wants a database named 'duplicate' to be dbid '20'. Is this
> possible? If so, how can it be done?
> Nathan
>