We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
It will not only find the object but also all the references to it.
TBSupport
ASKER
Hello:
SQL is not pulling up any records, for this object, even though it exists according to a separate stored procedure.
Could it be an alias or something that I need to look for?
Thanks!
TBSupport
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
TBSupport
ASKER
Hello:
I just found out that it's a user defined function. How do I find it and the programming behind it?
TBSupport
Éric Moreau
In SSMS, expand your database, than expand programmability, than Functions and you will find your UDF under one of the folder (depending on the type of UDF). You will then be able to right-click on it and select Modify to see the code behind
Vitor Montalvão
I just found out that it's a user defined function
UDFs should be returned by my query. How did you found out?
You can use this query
select * from sys.objects where name = 'Your Value'
and the column type_desc will let you know it is a table or proc etc.