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 » permissions   (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 : 2009-07-24

    I'm a day early; sorry.  But I have a lot of interesting items to share this week. ======================================== More control over TOP (n) in DML This week I realized that the workarounds for affecting which row(s) are impacted by UPDATE/DELETE TOP (n) were cumbersome, and so I asked for an extension of TOP that allows you to ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 24, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement