MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog.
SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB
Today we will see quick script which will check integrity of all the databases of SQL Server. We will learn about DBCC CHECKDB in this blog post.
SQL SERVER 2008 – Connect Visual Studio 2005 Patch Download
It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008.
SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
Recently I have got two desktop computers at home and both of them are very powerful machine. Machine 1 : Windows Vista SP1 with SQL Server 2008 Machine 2 : Windows 2003 with SQL Server 2005 with SP2 When I was trying to connect from SQL Server 2008 to SQL…
Read More
SQLAuthority News – TOP Downloads – Bookmark
Recently I have gotten many, many requests for SQL Server Interview Questions and Answers as well as related articles. It seems many people are looking for Job or appearing for an interview at this time of the year. I have included lists of the my top downloads in the sidebar of the blog, still I receive many curious questions as side bar does not show up in the RSS feed.
SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.
SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
This article is inspired from two sources. Let us learn today about how to swap variables by updating everything at once concepts.
1) My year old article – SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
2) Discussion with SQL Server MVP – Jacob Sebastian – SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems
I usually summarize my article at the end, but this time let me summarize first and we will understand the article next.