Stored Procedure in another DB

[CodeJunkee]

I am not a big SP expert. I need to do either:

1) Access a table from another db from inside a sp, that is not in the current db
2) Access an sp from another db from the current db

I couldn't find a way to do either???

 

[SonOfEmidec1100]

If the database is on the same sql server just use the full object name

databasename.ownername.tablename

you can omit the owner if dbo, but leave the stops.

Mydb..MyTable or MyDb..MySp

 

[CodeJunkee]

Thanks. That did it. I knew it was something simple. I guess I don't go cross db very much. I tried with one dot and didn't work. Forgot I needed two (..).