[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1163
  • Last Modified:

sys.sp_ms_marksystemobject for udf's?

hi i've used the procedure sys.sp_ms_marksystemobject successfully to mark sproc's as system objects but I have not been succesful attempting the same thing for functions. Is there a difference? Is a different syntax necessary?

(what actually happens is that it seems to register as a system function - it comes up in the right place under system functions - but i can't use it outside of the master database. I named fn_myfunction.)

please advise, thanks.
0
AlizaN
Asked:
AlizaN
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
I dont think that's possible..
0
 
chapmandewCommented:
Not sure you can do this...you can mark the function, but I believe you will still have to have it in every db...unless of course, you start the function with sp_
0
 
AlizaNAuthor Commented:
interesting. it so happens that this function doesn't really access any data - it's just a calculation. so i left it as a regular function in the master db and reference it as master.dbo.myfunction.
thanks for the confirmation.
0
 
chapmandewCommented:
sure
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now