Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 master db edits

Author  Topic 

GeoffM
Starting Member

2 Posts

Posted - 2008-09-17 : 12:15:38
is it possible to edit data inside a table in the master db?

I need to remove 1 charactor (actually a single hyphen in a name) in the sys.server table

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-17 : 12:44:12
Direct update to system tables are not supported in SQL 2005. Name stores your servername .You can't edit like that.
Go to Top of Page

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2008-09-17 : 13:10:31
This may help:

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
http://technet.microsoft.com/en-us/library/ms143799.aspx
Go to Top of Page

GeoffM
Starting Member

2 Posts

Posted - 2008-09-18 : 14:57:57
That worked TY!
Go to Top of Page
   

- Advertisement -