I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.
SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported
While attending conference SQLAuthority Author Visit – Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are…
Read MoreSQL SERVER – 2008 – Interview Questions and Answers – Part 7
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download How can we rewrite sub-queries into simple select statements or with joins? Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an…
Read MoreSQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name
If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together on same physical server, changing the name of the server (computer) using operating system may create non-functional SharePoint website. When you change the physical server name the SharePoint is already connected to the SQL instance…
Read MoreSQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0x60
This is a very common error faced by so many people and I get lots of questions regarding this error. This error occurs due to many reasons and I have already posted few solutions on this error, see if you can find your solution here SQL SERVER – Fix :…
Read MoreSQL SERVER – Fix : Error : 40 – could not open a connection to SQL server – Fix Connection Problems of SQL Server
Everyday I get lots of question regarding error : An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider,…
Read MoreSQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
Loyal reader of this blog and “Great SQL Expert” Imran Mohammed always have good attitude towards any problem. Many times his answers very interesting to read and details are very accurate. I came across his two interesting comment on this blog and I would like to share this all of…
Read More