June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL TempDB
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 More

SQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL 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 More

SQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009

Pinal Dave
Personal, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, MVP, 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 More

SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Advanced Option, SQL Error Messages, SQL Scripts
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 More

SQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
DigiCorp, MVP, SQL Joins, SQL User Group, SQLAuthority Author Visit
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 More