Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-06 : 09:11:57
|
| Larry writes "Hi!I am in the process of converting my existing Database to SQL Server 2000. After seeing the nice new functions such as SCOPE_IDENTITY, I decided to use IDENTITY fields in my tables, instead of my application creating values for me. One of my stored procedures needs to insert a specific value into an IDENTITY field, so I added the line "SET IDENTITY INSERT <TABLE ON"followed by my INSERT statement. I was shocked and horrified to find out that only the dbo or administrator has permission to run this statement, and not a normal user with EXECUTE permission on my stored proc. Is there any way of inserting a specific value into an IDENTITY field inside a Stored Proc that normal users have permission to execute?Thanks,Larry.Cape TownSouth Africa" |
|
|
|
|
|
IDENTITY INSERT