Try a variation on Dan's response:

select x, y, z

from server1.db1.owner1.tableA

UNION

select x, y, z

from server2.db2.owner2.tableA

UNION

select x, y, z

from server3.db3.owner3.tableA

If you have linked the SQL Servers to each other, then connecting to...

Yes.  As a matter of fact, the publisher and distributor can also both be set for SIMPLE recovery or Truncate Log on Checkpoint.

Thanks!  Yes, the developers changed the system date to October to test the change of daylight savings time, then changed the date back again all while replication was running.

Quick and cheesy answer is remove SET XACT_ABORT ON.

This is what is trying to begin the distributed transaction with Oracle using the MSDORA provider.

I believe you want what Francis was talking about, specifically:

SELECT eno,ename,dname

INTO #temp

FROM TABLE5 emp,TABLE6 dept

WHERE EMP.DEPTNO=DEPT.DEPTNO

This will put the results in the temporary table #temp.

To see the contents, simply...

ditto

How about an article on how to detect potential problems like an audit trigger that concatenates stuff together and stuffs it in a text field, potentially causing an error if...

Check again, aren't the 12 "rows" actually a list of your columns?

Thanks for all the fish!

The trick was dropping the server before trying to add it as "local".  I had been trying to add it as local without first dropping it,...

This can be due to many things.  Infrequent (non-existant?) log backups, large transactions (DTS?), etc.  Essentially the cure is usually to backup the log file, which will then allow the log...

From my observations the sp:recompile trace shows automatic recompiles only.  Thus if you were to add or remove indexes that would be used by a query, you will see the...

Not sure if it is SP4 or not, but after installing it in our lab, we noticed that our Win2K cluster now "hangs" on SQL Server start when using Move...

I have made extensive use of XML and XSLT in an international data exchange network.  All the data was and is stored in relational databases, as it should be.  But...

The following query will return all the table names and column names with the seed and increment values.

SELECT left (so.name, 30),

left (sc.name,...

Try the "syscolumns" table. The column "autoval" will show the identity seed and increment values as the 2nd and 3rd 8 digit groups from the right.