Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
1) Enable Server for CLR Support.
SQL SERVER – Explanation SQL Command GO
GO is not a Transact-SQL statement; it is often used in T-SQL code. Go causes all statements from the beginning of the script or the last GO statement (whichever is closer) to be compiled into one execution plan and sent to the server independent of any other batches. SQL Server…
Read MoreSQL SERVER – Download Microsoft SQL Server 2005 System Views Map
The Microsoft SQL Server 2005 System Views Map shows the key system views included in SQL Server 2005, and the relationships between them. It is available to download from Microsoft Site. It can be printed and mounted at Office Depot or Kinko’s. Download SQL SERVER 2005 System Views Reference :…
Read MoreSQL SERVER – 2008 Katmai – Download Datasheet Final from Microsoft
Few interesting thing about Katmai. SQL Server “Katmai” will provide a more secure, reliable and manageable enterprise data platform. SQL Server “Katmai” will enable developers and administrators to save time by allowing them to store and consume any type of data from XML to documents. SQL Server “Katmai” provides a…
Read More
SQL SERVER – Fix: Error: HResult 0x2, Named Pipes Provider: Could not open a connection
In this blog post we are going to fix the error which is related to Named Pipes Provider.
SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time
I was following up on the news of first Microsoft Business Intelligence (BI) Conference held at Seattle. Good news is – SQL Server 2008 code name ‘Katmai’ is announced. I went to the official website I like the catchy line “Your Data, Any Place, Any Time“. As per my opinion…
Read MoreSQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
Error 2501 : Cannot find a table or object with the name . Check the system catalog. This is very generic error beginner DBAs or Developers faces. The solution is very simple and easy. Follow the direction below in order. Fix/Workaround/Solution: Make sure that correct Database is selected. If not…
Read More