I already know that changing the DBID by detaching and re-attaching a
database messes up the full-text catalog, but does it have any other adverse
effects? Do jobs, logins, logins, or anything else depend on the DBID?
Thanks,
Boris Zakharin
Prime Associates, incHi,
As far as I know, There should not be any other issues. The job step stores
the database name
and logins also store the default database name for the login. So no issues
with database id changing.
Thanks
Hari
MCDBA
"Boris Zakharin" <bzakharin@.primeassociates.com> wrote in message
news:#FUWnEnbEHA.1292@.TK2MSFTNGP10.phx.gbl...
> I already know that changing the DBID by detaching and re-attaching a
> database messes up the full-text catalog, but does it have any other
adverse
> effects? Do jobs, logins, logins, or anything else depend on the DBID?
> Thanks,
> Boris Zakharin
> Prime Associates, inc
>
No comments:
Post a Comment