Home > Archive > MS SQL Server > January 2006 > Ident_insert behaiviour change in SSDS 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Ident_insert behaiviour change in SSDS 2005
Koni Kogan

2006-01-24, 1:23 pm

It looks like to get a correct value returned from IDENT_Current(‘Table

name’ a user must have at least 'select' or 'insert' permission on the
underlying table as opposed to just having an 'execute' permission for a
stored procedure that uses the function in Sql2K. Is this simply a bug?
I hope it is!
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com