calling my fx in sql

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rodchar - 27 Mar 2008 19:50 GMT

hey all,
when i call my function in sql in my datalayer i have to use the prefix dbo.
why do i have to do that? is this ok? do i need to change something on the
database side to follow best practices?

thanks,
rodchar

Reply to this Message

KH - 27 Mar 2008 21:23 GMT

SQL Server user-defined functions require 2-part naming -- the owner (usually
dbo) and the object name. Nothing to fix, that's just the way it is. I'm not
sure exactly why, you could ask in sqlserver.programming I'm sure someone
there knows.

> hey all,
> when i call my function in sql in my datalayer i have to use the prefix dbo.
[quoted text clipped - 3 lines]
> thanks,
> rodchar

Reply to this Message

rodchar - 28 Mar 2008 20:20 GMT

thanks for the help and direction,
rod.

> SQL Server user-defined functions require 2-part naming -- the owner (usually
> dbo) and the object name. Nothing to fix, that's just the way it is. I'm not
[quoted text clipped - 8 lines]
> > thanks,
> > rodchar

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...