September 12, 2006 at 9:01 am
Where are UDF's stored?! Not in sysobjects, but where? To be clear, where are they in SQL2005 and SQL2000?
Greetz,
Hans Brouwer
September 12, 2006 at 9:05 am
SELECT TYPE,NAME FROM SYSOBJECTS WHERE TYPE = 'FN'
IN YOUR QUERY ANALYZER EXECUTE THIS QUERY.
I AM NOT FOLLOWING WHAT YOU MEAN BY NOT IN SYSOBJECTS.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
September 12, 2006 at 9:10 am
In 2005 the definitions are stored in sys.sql_modules which you will need to join with sys.objects.
In 2000 its sys.comments
hth
David
September 13, 2006 at 12:22 am
Tnx, I had found them already. Have to use my eyes better...
Greetz,
Hans Brouwer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply