Issue with SQL Server 2000 table value function

For some reason, I am unable to view functions that return tables when using SQL Web Admin.

I am able to view functions that return scalar variables.

Similarly when I use enterprise manager, it gives me an error that mentions access rights when I try and edit these functions.

So at the moment, I can create table value functions but cannot subsequently edit them.

I have not changed any security settings. I was thinking that perhaps the default security was not set up correctly.


Can anyone give me a hint how I can get around this problem, it is a bit frustrating.


Thanks.

 

Attached image of error.

Talked with support guys, they can repeat the problem. It seems to be a microsoft bug with enterprise manager 2005 trying to edit SQL server 2000 databases. So I should use the earlier version of enterprise manager.

Strangely enough, you can't see table functions in the web based SQL manager either.

Rather than have two versions of enterprise manager, I am written a webpage that displays the function text so I can just bring it up and copy and paste it back into enterprise manager when I want to edit it.