THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Connect » books online   (RSS)
  • What permissions are required for SET IDENTITY_INSERT ON?

    SQL Server 2000's SET IDENTITY_INSERT ON topic says: Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner. While the SET IDENTITY_INSERT topic for SQL Server 2005 (and up) says: User must own the object, or be a member ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 14, 2010
  • Connect Digest : 2010-01-11

    Control over procedure cache We are still waiting for more control over procedure cache.  Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007.  It is currently closed as ''won't fix'' but it's been shown time and time again that in some cases we need this extra knob. #293188 : Amount of RAM for ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 11, 2010
  • Connect digest : 2009-08-09

    Sorry, I've been trying to keep this to a regular Saturday installment, but it was a beautiful weekend here and I just couldn't pass up on non-computer-related activities.  I have a short list of Connect items to draw your attention to this week. =============================================== Setup messes with authentication mode I was ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 9, 2009
  • Connect Digest : 2009-05-16 : please vote!

    Here are the items from this week that I feel deserve some attention. ==================== Hotfixes / service packs should leave authentication mode alone I may have talked about this issue here before, I'm not sure, but I thought I was the only one who saw this happen.  This week someone else came across the issue, where they had a SQL ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 16, 2009
  • Come on, it's Saturday, get out and vote!

    I was encouraged by some fellow MVPs (well, mostly Alexander Kuznetsov) to periodically post a set of Connect items to encourage voting for items that I found relevant but that are maybe being largely ignored.  Saturday is probably my best opportunity to do this, especially ones like today where the weather is crappy.  While I can't ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 18, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement