Call function in different database

[SteveDingle]

Hello All,

I thought I posted this yesterday but can't find a record for it. (Hope I didn't put in wrong forum)

SS2K - I would like to call the fn_listextendedproperty from an SP in a different database (same server) and can't figure out the syntax I would use

Thanks very much
Steve

 

[ca8msm]

You can reference it by using the format [database].[owner].

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[SteveDingle]

Hello ca8msm,
Thanks for quick response, sorry for being dense but I am not sure "where" I put that format. For instance the function parameters for a field column property would be:

fn_listextendedproperty(
'MyProperty',
'user',
'dbo',
'table',
'MyTable',
'column',
'MyColumn'
)

Can't figure out where the database name would go.

Thanks again

 

[ca8msm]

It would be wherever you are calling the function from e.g.

select field1, database2.dbo.myfunction('A')
from mytable

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]