When using SQL Server Management Studio for SQL Server 2008 R2 connecting to a local SQL Server 2008 R2 instance (version 10.50.2500), I know that if I am using the instance name
(local)\sql2008 it will fail to attach the debugger to any queries I attempt to debug with the error message
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.
However, If I change that connection to
src\sql2008 the debugger runs happily.
Are there any other differences in having your connection use the
(local) alias other than the debugger issue I pointed out above?