Consolidating Data from 7 similar databases

I'm not quite sure if this is the correct forum to post this, if not please advise where should I post.

I have 7 databases with same structure, but different data in it, I need to have a query to consolidade some info from all of them in one report, is it possible just in onw script? how should I do it?

thanks,

Marcus

PS: I'm a beguinner in this so I apologize if the question seems stupid, or wrong.

If all the databases are on the same server, you can access tables in other databases using the long name [Database].[Owner (usually dbo)].[Table]. It would look something like SELECT * FROM AdventureWorks.Person.Address .

If the databases are on separate servers, you can use the "linked server" feature.

-Ryan / Kardax

Connectivity error on a table

I am using sgl2000 server ent. edition. I could not view the table on a
database.I am able to view the structure of the same. When I try to run a
query with the same table it says an error "[Microsoft][ODBC SQL Ser
ver
Driver]& #91;DBNETLIB]ConnectionOpen(WrapperRead(
))"
I don't know what is to be done? But last one year i am using the same table
without any issues. please any one could resolve this issue.Hi
Check the SQL Event log.
You might get a surprise and find that SQL has killed your SPID due to
corruption on that table.
Regards
Mike
"Shanthi" wrote:

> I am using sgl2000 server ent. edition. I could not view the table on a
> database.I am able to view the structure of the same. When I try to run a
> query with the same table it says an error "[Microsoft][ODBC SQL S
erver
> Driver]& #91;DBNETLIB]ConnectionOpen(WrapperRead(
))"
> I don't know what is to be done? But last one year i am using the same tab
le
> without any issues. please any one could resolve this issue.|||I have checked both sql log and event log and nothing found as you told.
Please let me know if any thing is to be done.
Shanthi
"Mike Epprecht (SQL MVP)" ?? ????:
[vbcol=seagreen]
> Hi
> Check the SQL Event log.
> You might get a surprise and find that SQL has killed your SPID due to
> corruption on that table.
> Regards
> Mike
> "Shanthi" wrote:
>

Connectivity error on a table

I am using sgl2000 server ent. edition. I could not view the table on a
database.I am able to view the structure of the same. When I try to run a
query with the same table it says an error "[Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen(WrapperRead())"
I don't know what is to be done? But last one year i am using the same table
without any issues. please any one could resolve this issue.
Hi
Check the SQL Event log.
You might get a surprise and find that SQL has killed your SPID due to
corruption on that table.
Regards
Mike
"Shanthi" wrote:

> I am using sgl2000 server ent. edition. I could not view the table on a
> database.I am able to view the structure of the same. When I try to run a
> query with the same table it says an error "[Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionOpen(WrapperRead())"
> I don't know what is to be done? But last one year i am using the same table
> without any issues. please any one could resolve this issue.
|||I have checked both sql log and event log and nothing found as you told.
Please let me know if any thing is to be done.
Shanthi
"Mike Epprecht (SQL MVP)" ?? ????:
[vbcol=seagreen]
> Hi
> Check the SQL Event log.
> You might get a surprise and find that SQL has killed your SPID due to
> corruption on that table.
> Regards
> Mike
> "Shanthi" wrote: