Tuesday, October 4, 2011

Problem debugging stored procedures / T-SQL on (local) databases

If you run into the following error while trying to debug T-SQL in SQL Server Management Studio, the problem is that the DNS name (local) cannot be resolved:

Unable to start T-SQL Debugging. Could not connect to computer '(local)'. The requested name is valid, but no data of the requested type was found.

The solution is to connect to localhost rather than (local).

No comments:

Post a Comment