How to use a user defined function in SQL that is from another db

Question

I have a user defined function in a different database than the one i am querying from. Is there a way to access the function such as a fully qualified name or something similar in SQL? I am trying to do this

[dbo].[EscalationManagementSystem].fncCVUnix2DateTZ(...

But i get an error saying that it cannot find the column "dbo" or the user defined function "dbo.EscalationManagemntSystem.fncCVUnix2DateTZ". Is my syntax wrong?

UnhandledExcepSean · Accepted Answer · 2012-03-14 20:00:01Z

16

The proper format is Database.Schema.Object, so you would have:

[EscalationManagementSystem].[dbo].[fncCVUnix2DateTZ](...

answered Mar 14, 2012 at 20:00

UnhandledExcepSean

12.9k4 gold badges38 silver badges54 bronze badges

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

Comments

specificityy · Accepted Answer · 2012-03-15 17:52:40Z

3

Every time you need to access objects from another db you should use something called the "four part name convention" which is:

SERVER.DATABASE.SCHEMA.OBJECT

answered Mar 15, 2012 at 17:52

specificityy

5801 gold badge5 silver badges24 bronze badges

1 Comment

UnhandledExcepSean Over a year ago

You only need the server name if going to a different server than what the current database is located on; that is the only time you should specify the server name.

Collectives™ on Stack Overflow

How to use a user defined function in SQL that is from another db

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related