Regarding stoerd procedures - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Regarding stoerd procedures

Author

Topic

shiva994u
Starting Member

2 Posts

Posted - 2008-01-03 : 10:41:41

Can i call one database procedure in some other database in SQL SERVER 2005?
If yes ,please tell me how?
Urgent

thanks in advance
shiva

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-01-03 : 10:51:25

Yes.

Exec database.owner.proc1 param1, param2....

provided both databases are on same server.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

shiva994u
Starting Member

2 Posts

Posted - 2008-01-03 : 11:03:55

Can i set foregin keys also from database table in some othe database?
Please give me any gud links for this?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources