July 25, 2007 at 8:26 am
How can I get access to 6 different database's where in all of them run single set(112 procs)of store procs.
What I want is, from the report app I have to run a final report from all the 6 db's where each db has its own reports and as an admin I need to have access to all of the reports as a single final report with one click so that I can work on the report related to each db. How can i do this?
If it not clear..Let me know if any one has questions regarding
July 25, 2007 at 8:35 am
If the databases reside in single same server you can use the three part naming convention to call the other database from a databaselike
dbname.ownername.objectname
else if they reside in diff servers then create linked servers and use 4 part naming convention like
servername.dbname.ownername.objectname
hope this helps
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply