CODEWITHSUNDEEP
sql-server-2008t-sqlfunctionssmsuser-defined-functions
Shrout1
Shrout1

Reputation: 2607

Cannot locate user defined functions in SQL Server 2008

First time using SQL Server 2008 this morning.

I am trying to find a user defined function that I created. I cannot locate it in the "Programmability>Functions" branch of the object explorer. Here is what that branch looks like:

Functions Branch

There do not seem to be any "user defined functions" and I don't know if any of the particular branches should house that. I have been granted database owner rights to the database, so I don't believe it is a permissions issue...

I was able to retrieve the full text of the function using the 'EXEC sp_HelpText 'someUserDefinedFunction'' that was listed in this thread about finding user defined functions. That thread did not provide enough information for me to locate my function in object explorer or edit my function again using SMSS. Please see the full screenshot of my SQL Server 2008 Management Studio instance with the return from the sp_HelpText query for additional context.

The function works just fine when it is called. I retrieved this function from this thread about splitting delimited text.

I am hoping to find a location in the interface that displays all the user defined functions!

Upvotes: 0

Views: 864

Answers (1)

a1ex07
a1ex07

Reputation: 37354

There is no "user defined functions" menu in SSMS. All functions except system are user defined. Based on return type you will find your function in "Table-valued", "Scalar-valued", or "Aggregate" (the latest is not really different from "Scalar-valued" in terms of return type though, but it can be used for aggregation). In your case check "Table-valued"

Upvotes: 2

Related Questions