This week I was using a database that contains few different schemas. In the SPROC I was trying to execute some command on a new table I’ve just created but couldn’t find it on the SQL intelliSense. I thought it was intellisens cache issue so I refreshed it (using Ctrl+Shift+R), waited for few seconds and still couldn’t find it. After a minute or two I’ve noticed it is exist, but on the default dbo schema instead of the desired schema. bad. When you create a new DB object on a schema different than...
Recently I encountered an exception while trying to connect to SQL Server named instance. We have a main server with SQL Server 2005 installed on as the default instance and another SQL Server 2008 installed as a named instance. The connection string I used was: " Data Source=ServerName\InstanceName,1433;network library=dbmssocn;Initial Catalog=MyDataBaseName;Integrated security=SSPI " We are using TCP/IP as the underlying connection method in order to connect to SQL Server. This can be...