Renaming a host computer for SQL Server causes stored procedure debug to fail (317241)

The information in this article applies to:

Microsoft Visual Studio 2005 Standard Edition
Microsoft Visual Studio 2005 Professional Edition
Microsoft Visual Studio .NET (2003), Professional Edition
Microsoft Visual Studio .NET (2003), Enterprise Architect Edition
Microsoft Visual Studio .NET (2003), Enterprise Developer Edition
Microsoft Visual Studio .NET (2002), Professional Edition
Microsoft Visual Studio .NET (2002), Enterprise Architect Edition
Microsoft Visual Studio .NET (2002), Enterprise Developer Edition
Microsoft SQL Server 2000 (all editions)

This article was previously published under Q317241

SYMPTOMS

If you rename the host computer for a Microsoft SQL Server 2000 server, you cannot step into a SQL Stored Procedure with the Visual Studio 2005 or Visual Studio .NET environment, and you may receive the following error message:

The thread 'OldServerName(nn)' (0x8nnnnnnn) has exited with code 0 (0x0). The program 'SQL Debugger: T-SQL' has exited with code 0 (0x0).

Note You can still run the stored procedure.

CAUSE

The Debugger cannot find the name of the host computer in the system table entry because the host computer has been renamed. During installation, SQL Server stores the name of the host computer in a system table entry that is used by the debugger. If the host computer is renamed, this table is not updated automatically.

RESOLUTION

Update the name of the SQL Server internal computer:

In Query Analyzer, run the following commands:

sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName','local'
go

Stop and restart SQL Server to update the global variable @@servername with the correct server name.
Use Query Analyzer and run the following command to verify the correct server name:
```
SELECT @@servername
					
```

REFERENCES

For more information about how to set up SQL debugging, see the following topic in the Visual Studio .NET online Help documentation:

SettingUpSQLDebugging
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxlrfSettingUpSQLDebugging.asp

For more information about renaming a SQL Server, see "Renaming a Server" in SQL Server Books online. In addition, click the following article number to view the article in the Microsoft Knowledge Base:

303774 BUG: Renaming a Server Topic in Books Online is Incomplete

Modification Type:	Major	Last Reviewed:	3/4/2006
Keywords:	kbvs2005applies kbvs2005swept kbvs2002sp1sweep kbBug kbDebug kbprb KB317241