User Instance login flag is not allowed when connecting to a SQL Server instance: Solved

While working with an ASP.NET MVC application I encountered following exceptions: Exception clearly says that user instance login flag is not allowed when connecting to a SQL Server instance. For sure this error is related to SQL Server instance I am working on in this particular application. I examined the connection string in the web.config … Continue reading User Instance login flag is not allowed when connecting to a SQL Server instance: Solved

Some Important Points from “SQL Misconceptions” Session from Pinal Dave and Vinod Kumar

I attended session of Pinal Dave and Vinod Kumar on SQL Misconceptions. Few of points from that session is as following SET ROWCOUNT and TOP and OrderBy is not same. Set RowCount , Top and OrdetBy gives different execution plan Misconception is Cluster Index gives the result out in Order. It sort and gives result … Continue reading Some Important Points from “SQL Misconceptions” Session from Pinal Dave and Vinod Kumar