SQL server - execute scalar function without specifing db name

Question

I have a user defined SQL function that I am able to call from management studio using syntax dbo.Function(arg)

Now, when I have to call this function from C# if I don't specify **dbname**.dbo.Function(arg) I get an error that SQL server does not find this user defined function. How can I solve this without specifing dbname ? I already connect to the server using a connection string that specifies the "initial catalog = dbname"

It seems that I cannot reproduce mentioned behavior at this point :-) (either using SQL server 2005 or 2008) I have to put this question on hold

You may need to grant EXEC permissions on the function to the login used by your application. — Martin Smith
– Martin Smith, Commented Nov 18, 2011 at 14:57
@MartinSmith I use Windows Authetication in both management studio (where it works) and C# code. As I've said if I add in code also dbname ( e.g. SELECT DATEPART(YEAR, Activitylogs.Datastamp) AS YEAR_VALUE, dbname.dbo.ISOweek(Activitylogs.Datastamp) ... it works — Ghita
– Ghita, Commented Nov 18, 2011 at 15:07
Using a SqlCommand with command text select dbo.Function() works for me. — Jeff Ogata
– Jeff Ogata, Commented Nov 18, 2011 at 15:20
It is possible that I saw this only intermittent. I will have to put the question on hold because it seems to work now. Thank you all ! — Ghita
– Ghita, Commented Nov 18, 2011 at 15:34

Yuck · Accepted Answer · 2011-11-18 16:17:32Z

2

Your connection string needs to specify the database to use initially. It might look something like this:

var cn = new SqlConnection(
    "SERVER=SomeServer;DATABASE=SomeDb;Integrated Security=SSPI;"
);

Without that, you're probably being dumped into the master database, which is why you need to fully qualify the function name.

answered Nov 18, 2011 at 16:17

Yuck

51.1k13 gold badges108 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL server - execute scalar function without specifing db name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related