Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Scalar function

Author  Topic 

sven2
Yak Posting Veteran

57 Posts

Posted - 2009-10-06 : 06:19:02
Hello,

on the internet I found a function that I want to use. When I create this scalar function it appears correctly under functions and it works just fine. Now the problem is that the function is created as a dbo.function. So it just works for databaseowners.

How can I change this that evereybody can use this function?

Thanks in advance,
Sven.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-10-06 : 07:54:39
DBO is the standard "schema" in sql server.
It is always needed to call your functions in that form dbo.funtion_name.
That's nothing new and should be not a problem.
Try it out.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -