M
Malcolm Cook
H'lo,
When developing an ADP, renaming a user defined function using ACC2002 front
end against SQL Server 2000, you get prompted with:
Renaming this user-defined function removes any existing permissions
and extended properties.
I find that it does NOT in fact alter the existing permissions; rather, any
grants made in SQL Server survive the rename. At least in my minimal
testing.
However, as warned, extended properties are wiped.
Dooh!
Why is this? I wonder, because, when I simply use sp_rename directly in SQL
Server, there is no loss of expended properties (nor permissions).
I also wonder what effect I might expect this to have on Access. There are
a bunch of expended properties that Access uses for something, but this is
not documented anywhere. They all begin with MS_. It makes me leery.
The lesson, I think, is just use sp_rename on the server. However, maybe MS
WANTS the extended properties wiped. Maybe allowing them to survive a
rename such as happens using sp_rename will bollix up Access somehow else,
and that is why renaming them through the Access UI trashes these
properties... on pupose.
Who knows? Is this right?
I care because I sometimes need to rename UDFs and I use my own extended
properties on them.... so I need to make sure I 'm doing this "right".
Any knowledge on this out there?
Thanks!
When developing an ADP, renaming a user defined function using ACC2002 front
end against SQL Server 2000, you get prompted with:
Renaming this user-defined function removes any existing permissions
and extended properties.
I find that it does NOT in fact alter the existing permissions; rather, any
grants made in SQL Server survive the rename. At least in my minimal
testing.
However, as warned, extended properties are wiped.
Dooh!
Why is this? I wonder, because, when I simply use sp_rename directly in SQL
Server, there is no loss of expended properties (nor permissions).
I also wonder what effect I might expect this to have on Access. There are
a bunch of expended properties that Access uses for something, but this is
not documented anywhere. They all begin with MS_. It makes me leery.
The lesson, I think, is just use sp_rename on the server. However, maybe MS
WANTS the extended properties wiped. Maybe allowing them to survive a
rename such as happens using sp_rename will bollix up Access somehow else,
and that is why renaming them through the Access UI trashes these
properties... on pupose.
Who knows? Is this right?
I care because I sometimes need to rename UDFs and I use my own extended
properties on them.... so I need to make sure I 'm doing this "right".
Any knowledge on this out there?
Thanks!