Where are all the XMLGURUS? Are there any out there?

Thanks for the replys but none are getting me anywhere!

I'm using the SQLXMLBulkLoad process to insert data to a couple of...

I still have to use a Mode in the FOR XML Clause. I can't just put in XMLDATA. Is there a way of doing this?

I don't have an SQL 7.0 Server to perform an absolute test here. However, be aware that a timestamp column will generate it's own value when you do the BCP...

T-SQL does not have a function for this!

You mentioned ADO.NET, if you are trying to access a linked server through an application, then I would just place a TRY, CATCH...

How did you ascertain that the Timestamp column is the troublesome one?

An the error is?

Jim Underwood,

The author of this short spiel about Performance on large tables using JOINS needs to state just what exactly constitutes a large...

That Stored Procedure 'sp_MSins_authors' should be on the Subscription Database! This and other Stored Procedures used by Replication get created during Replication Setup!

Try removing Replication and start again!

1 way to do this is to use Transactions with the SET XACT_ABORT setting to ON. What this does is "if any part of the transaction fails the entire transaction...

Exactly the same!

sp_attach_db and sp_detach_db exist in SQL 7.0 as well.

It all depeneds on what you want to do in DTS. In BOL there are some examples for DTS Packages.

I believe they are talking about compression folders from the operating system level.

just a thought off the cuffs, could you not just do a BETWEEN from the input that a user chooses? I'm assuming that fromdate & thrudate are input variables to...

I believe you have to install the Oracle client on the SQL Server first.

Greg,

The sysjobhistory Table is the one however I see now what you are trying to do! Thats right this table is history only and until a step has completed you...