Author: SSWUG Research

Community

You cannot connect to a local instance of SQL Server on a Windows XP-based computer or on a Windows 2000-based computer when you use ‘localhost’ in the pipe name

On a Microsoft Windows XP-based computer or on a Microsoft Windows 2000-based computer, you use the Named Pipes protocol to connect to a local instance of Microsoft SQL Server 2005 or Microsoft SQL Server 2000. When you use “localhost” in the pipe name, you cannot connect to the instance of SQL Serv

Community

SchemaBinding option in views

(Abey George Peter) Views can be thought of as a virtual table or stored query. The results of view are not stored in database (except for indexed views). The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables