While I was working with SQL Server 2008 IntelliSense, I realized that it was not functioning as I expected. Even after I had enabled IntelliSense it was still not opening any suggestions at all. After a while, I figured out some vital information regarding how to make sure IntelliSense smoothly works all the time without you giving any trouble. Let us learn how we can Enable IntelliSense.
SQLAuthority News – Top 10 Strategic Technologies for 2009
Gartner, Inc. analysts highlighted the top 10 technologies and trends that will be strategic for most organizations. Factors that denote significant impact include a high potential for disruption to IT or the business, the need for a major dollar investment, or the risk of being late to adopt. The top…
Read MoreSQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database
Recently, one of my regular blog readers emailed me with a question concerning the following error: Msg 2714, Level 16, State 6, Line 4 There is already an object named ‘#temp’ in the database. This reader has been encountering the above-mentioned error, and he is curious to know the reason…
Read MoreSQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download
SQL Server 2008 new brochure is available for download. Microsoft® SQL Server® 2008 provides a trusted, productive, and intelligent data platform that enables you to: Run your most demanding mission-critical applications. Reduce time and cost of development and management of applications. Deliver actionable insight to your entire organization. Your Data,…
Read MoreSQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today
I have published a poll on website few days ago for favorite database of SQLAuthority.com readers. The best comment will win USB drive. The poll will close on April 1, 2009. Looking at the poll result, it seems that Oracle has gained a lot over SQL Server from last time…
Read MoreSQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009
Microsoft MVP Award Blog and Microsoft South Asian MVP Blog has published my video interview online. My interview was conducted by Abhishek Kant – Microsoft MVP Lead and Technology Blogger. I am thankful to Abhishek Kant for conducting my interview, Abhishek Baxi for publishing on South Asian Blog and Jas…
Read MoreSQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.
I received another email describing error received due to my executing script from my previous article . Error : Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option ‘optimize for ad hoc workloads’ does not exist, or it may be an advanced option. Let us quickly…
Read MoreSQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master
I have received comment from Radha Goswami on my previous blog article SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users. Radha is facing following error when she is tring to grant permission to login. Error: Msg 4621, Level 16, State 10, Line…
Read MoreSQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009
It is my pleasure to announce new SQL Server User Group – Gandhinagar SQL Server User Group. We will be meeting every 2nd and 4th Friday of the month. Here is the detail for this months meeting. We will be having one gift for best participant in the meeting. I…
Read MoreSQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009
We had fun session with Ahmedabad SQL Server Usre Group last week on March 21, 2009. It was short session but one interesting one. We discussed about how query profiler works and how to find most popular query from SQL Server instance. We had also prepared Trace Template as well…
Read More