May 20, 2005 at 2:11 pm
We are running SQL Server 2000, Standard Edition, SP3. I use a lot of UDF's and I have never seen this one before. I have a very large multistatement table-valued function. When I edit and save (just adding one blank line, for example), the Select permission of this object for a user role disappears!
I have added a comment at the top of the function to remind me to reset permissions after editing, but I have never had to do anything like that before.
Any clues as to what is going on?
Thanks,
JFW
May 21, 2005 at 12:53 am
You must be dropping the UDF and recreating it.
Amit Lohia
May 21, 2005 at 6:59 am
Amit,
I think you are right, but I am not dropping it, Enterprise Manager is dropping it. I wonder why it decided to drop and recreate this particlar function and not the multitude of other functions I work with every day? The main difference is the size. Perhaps I have reached a threshold that forces this action.
JFW
May 21, 2005 at 10:13 am
Can you post the UDF ?
Amit Lohia
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply