calling my fx in sql

  • Thread starter Thread starter rodchar
  • Start date Start date
R

rodchar

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
 
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.
 
thanks for the help and direction,
rod.

KH said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

decent size datatable 2
empty resultset help 5
Call stored procedure with paremeter output in c# 7
Deploy CLR UDF to a different SQL Schema 4
One class not seeing another until I restart VS 3
getting return on select 7
sql error message retrieval 2
Where to place app.config file 4

Back
Top