SSMS Bug - Extended Props for UDF Deleted

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SSMS Bug - Extended Props for UDF Deleted

Author

Topic

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-02-01 : 23:35:08

Hi all,

I am using SQL Server 2005 on Windows XP machine.
I added some custom extended properties to the table valued UDF I created and I was able to see it properly. But after I did some changes and fired ALTER FUNCTION statement, suddenly all the extended properties were dropped. I am not sure if this is BUG in SSMS or is it by design.

Anyone experienced this before?

Harsh Athalye
http://www.letsgeek.net/

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-02-02 : 12:49:41

What type of connection are you using?

I've not seen this and I'm not sure why it would do that. But, if I had to guess, I'd say that it is dropping then creating the function. Again, I'm not sure, but ODBC might do that. If you are using the native SQL connection, then I'm at a loss.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-02-02 : 13:13:25

It is native SQL connection indeed with Windows authentication. The weird thing is that this thing doesn't happen with stored proc. So, I don't understand what is so special about UDF.

Harsh Athalye
http://www.letsgeek.net/

Kanwulf
Starting Member

11 Posts

Posted - 2010-02-03 : 10:05:24

That is weird. I just did a small test, and the extended property is still there:
create function mmm (@p1 int)
returns int
as
begin

set @p1 = 1
return @p1
end

sp_addextendedproperty @name='xxx',@value = 'Postal code is a required column.'
,@level0type = N'SCHEMA', @level0name = [dbo]
,@level1type = 'FUNCTION', @level1name = mmm

alter function mmm (@p1 int)
returns int
as
begin

set @p1 = 2
return @p1
end

I am using Microsoft SQL Server 2005 - 9.00.4220.00 (X64)

Ionut Hrubaru

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-02-03 : 11:31:41

This happened in my case to Table-Valued functions, not scalar functions.

Harsh Athalye
http://www.letsgeek.net/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources