Feeds:
Posts
Comments

Archive for January, 2010

SQLAuthority News – Community Tech Days – Jan 30, 2010 – Event Announcement

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology, tagged on January 21, 2010 | Leave a Comment »

Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills needed to maximize your impact [...]

Read Full Post »

SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on January 20, 2010 | 2 Comments »

Microsoft has organized an Open Day for all MVP the South Asia MVP.  The MVP Open Day is a three day invitation-only event that is hosted at MSIDC. The event will feature a roster of keynotes and deep dive technical sessions delivered by experts from the product group. Microsoft India Development Center (MSIDC) is one of [...]

Read Full Post »

SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on January 19, 2010 | 17 Comments »

Yesterday night, I received a phone call from one of my friends with whom I used to work in USA. I was very pleased to receive this call from my old friend after 2 years, but the situation was not good on his side. He said that whatever query he runs, he just receives a [...]

Read Full Post »

SQL SERVER – DMV Error: FIX: Error: Msg 297, Level 16 The user does not have permission to perform this action

Posted in DMV, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 18, 2010 | 8 Comments »

I just received an email from one of the readers asking for help with error he encountered while attempting to run DMV. Msg 297, Level 16, State 1, Line 1 The user does not have permission to perform this action. Fix/Solution/Workaround: The above error is usually generated when the user who is trying to run [...]

Read Full Post »

SQL SERVER – Get Server Version and Additional Info

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on January 17, 2010 | 1 Comment »

It is quite common to get the SQL Server version details from following query. SELECT @@VERSION VersionInfo GO Recently I have been using following SP to get version details as it also provides me few more information about the server where the SQL Server is installed. EXEC xp_msver GO I like to use the second [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers