Dear fellows,
I was wondering how it was for rename a database?
Thanks a lot for any input,
EnricOld way is sp_renamedb. As of SQL Server 2000, you can also (and preferred w
ay) ALTER DATABASE (see
Books Online for syntax).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:A10EAC4C-4AA0-4363-A17A-F62E8A66F0F3@.microsoft.com...
> Dear fellows,
> I was wondering how it was for rename a database?
>
> Thanks a lot for any input,
> Enric
Showing posts with label rename. Show all posts
Showing posts with label rename. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
I Changed My Servername Help Please
Hi,
I have Joined my SQL Server into another domain and had to rename the
machine as well I am running SQL Server 2000 on a Windows 2000 server on an
NT Domain
Since this I seem to have some problems with replication etc. is there a
registry setting or something I need to change where the old machine name
might be lurking?
Or is it a case of me removing then re-installing SQL Server ?
Thanks in advance for any help provided on this
Joe MellonIf you re-run the Setup from the SQL Server CD, it should show you an option
to repair registry only. Try with this first, it is quick and easy process.
You don't have to reinstall SQL Server. Maybe after the registry rebuild you
will have only to reestablish the replication.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Joe Mellon" <joe@.bluesteel.co.uk> wrote in message
news:O9vZofNsDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have Joined my SQL Server into another domain and had to rename the
> machine as well I am running SQL Server 2000 on a Windows 2000 server on
an
> NT Domain
> Since this I seem to have some problems with replication etc. is there a
> registry setting or something I need to change where the old machine name
> might be lurking?
> Or is it a case of me removing then re-installing SQL Server ?
> Thanks in advance for any help provided on this
>
> Joe Mellon
>
I have Joined my SQL Server into another domain and had to rename the
machine as well I am running SQL Server 2000 on a Windows 2000 server on an
NT Domain
Since this I seem to have some problems with replication etc. is there a
registry setting or something I need to change where the old machine name
might be lurking?
Or is it a case of me removing then re-installing SQL Server ?
Thanks in advance for any help provided on this
Joe MellonIf you re-run the Setup from the SQL Server CD, it should show you an option
to repair registry only. Try with this first, it is quick and easy process.
You don't have to reinstall SQL Server. Maybe after the registry rebuild you
will have only to reestablish the replication.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Joe Mellon" <joe@.bluesteel.co.uk> wrote in message
news:O9vZofNsDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have Joined my SQL Server into another domain and had to rename the
> machine as well I am running SQL Server 2000 on a Windows 2000 server on
an
> NT Domain
> Since this I seem to have some problems with replication etc. is there a
> registry setting or something I need to change where the old machine name
> might be lurking?
> Or is it a case of me removing then re-installing SQL Server ?
> Thanks in advance for any help provided on this
>
> Joe Mellon
>
Subscribe to:
Posts (Atom)