What permissions are required for SET IDENTITY_INSERT ON?

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Tue, 14 Dec 2010 17:48:00 GMT Indexed on 2010/12/16 4:15 UTC
Read the original article Hit count: 322

Filed under:

books online

|

connect

|

documentation

|

permissions

|

SET IDENTITY_INSERT

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 of the sysadmin fixed server role, or the db_owner and db_ddladmin fixed database roles. This was clearly adapted from the 2000 books online and re-written by someone who misinterpreted "db_owner...(read more)

© SQL Blog or respective owner

Related posts about books online

Google Books Downloader Downloads Google Books to PDF and JPG

as seen on How to geek - Search for 'How to geek'
If you’re looking for a way to download and format shift books and magazines found in Google Books, Google Books Downloader can help. Google Books Downloader takes what you can see in Google Books and downloads it either as a PDF file or as a series of JPGs. The key to using Google Books Downloader… >>> More
SQLAuthority News – 2 New Books – FREE Books and Book Signing at #SQLPASS 2012

as seen on SQL Authority - Search for 'SQL Authority'
As an author the most interesting task is to participate in Book Signing Events. If you are at SQLPASS – we are going to have a lot of book signing events. Here is the good news! MY NEW BOOKS ARE OUT! SQL 2012 Functions Limited Edition Click to Expand This book is a very special edition book… >>> More
Programming books at work or e-books?

as seen on Stack Overflow - Search for 'Stack Overflow'
How do you manage your programming books between home and work? Do you carry all your books between the two or do you exclusively make use of e-books at one of the locations? >>> More
Logo Design Online: Process Of Hiring And Working With An Online Logo Design Company

as seen on Article City - Search for 'Article City'
Hiring an online logo design company is not easy these days; you will find hundreds of logo design companies on just click of a mouse. But it';s up to your decision making skills how you select a best... [Author: Gisselle Gloria - Web Design and Development - October 05, 2009] >>> More
Online Marketing and SEO - Art of Business Promotion Online

as seen on Ezine Articles - Search for 'Ezine Articles'
Every business or product needs exposure to get expected profit, and for exposure we need marketing for the particular business or product. Traditional marketing techniques have been outdated, Online marketing has taken the place of traditional marketing techniques. >>> More

Related posts about connect

'sudo apt-get update' error

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I've been having an issue with 'sudo apt-get update' for several days now. I've tried every proposed solution I could find but to no avail. Here is the output to 'apt-get update'. Ign http://us.archive.ubuntu.com precise InRelease Ign http://us.archive.ubuntu.com precise-updates… >>> More
Azure Mobile Services: what files does it consist of?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Azure Mobile Services is a platform that provides a small set of functionality consisting of authentication, custom data tables, custom API’s, scheduling scripts and push notifications to be used as the back-end of a mobile application or if you want, any application or web site. As described in my… >>> More
What's the mobileish connect url of Facebook connect?

as seen on Stack Overflow - Search for 'Stack Overflow'
I use the following URL setting to authorize Facebook login. But the page for Application Authorization is webish, and not mobileish. webview .loadUrl("http://www.connect.facebook.com/login.php?return_session=1&nochrome=1&fbconnect=1&extern=2&connect_display=popup&api_key=" … >>> More
facebook connect: thumbnail images broken up in FB.Connect.streamPublish pop-up prompt, and on wall

as seen on Stack Overflow - Search for 'Stack Overflow'
hi there! I'm using facebook connect so that users can publish comments they are leaving on my site on their facebook wall as well. It works as intended, except that in the confirmation pop up, the thumbnail image i provide is broken. Looking at the source, I can see that facebook prepended my image… >>> More
apt-get install and update fail

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I've got a problem with apt-get update and apt-get install ... commands . every time update or installing fails and errors are : Get:1 http://dl.google.com stable Release.gpg [198B] Ign http://dl.google.com/linux/chrome/deb/ stable/main Translation-en_US Get:2 http://dl… >>> More