THE SQL Server Blog Spot on the Web

Welcome to - 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
Privacy Statement