Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Servid

Status
Not open for further replies.
jfield817

jfield817

Programmer
Jun 2, 2000
153
US
I run a SELECT on a 6.5 SQL SERVER Sysservers table; the Servid of the local server is not 0 ....I assume it should be 0. There are several non 0 servids for other linked and remote servers connected to this server.

Any ideas on how to fix this ? (make it 0)

thanks
john field
 
Sort by date Sort by votes
Its not usually a good idea to mess with the system tables... BUT... I've been in this situation myself a few times, so if you must - you can update the system tables directly as long as you have the server option 'Allow ad hoc updates to system catalogs' (or something like that) turned on. This option can be updated by right clicking on the server in Enterprise Manager and selecting Properties, then click on Server Settings.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top