Cannot say I have but if Clipper supports ODBC, a quick search on google says it has drivers, then you should not have any problems getting data out.

You problems will...

As with any undocumented feature, MS has changed it.

XP_reg... cannot be used to read outside of SQL Server's registry. You can read values that fall under SQL root but not...

Your key lies in the:

2007-06-19 10:49:43.83 spid5s Input Buf: RPC Event: Proc [Database Id = 10 Object Id = 1373247947]

and vitim:

2007-06-19 10:49:43.83 spid5s Input Buf: RPC Event: Proc [Database Id...

Once you have moved the DTS packages, you need to create a SSIS package and use the Execute DTS package task to run them either from the SQL store or...

To add some clarity to covered indexes.

SQL 2005 has the nice feature called "include" which should be used.

An index should have, in the index itself, columns used in the join...

What was said in the article is correct. However, there are also other reasons why you would get a miss / hit.

The old time fav is when people name their...

Only FOR XML EXPLICIT supports CDATA. You'll have to look in BOL for FOR XML EXPLICIT for some examples.

For the query you have, it is nothing major to convert. Let...

Hold yer horses.....

Yes, SSIS does indeed deal with each row one at a time. Each row in a buffer that is... it is designed to do this and is fast...

You have to use XML EXPLICIT and specify CDATA for each column you want.

SELECT

1AS TAG,

NULLAS parent,

'Some <XML'AS [X!1!SourceID!CDATA]

FROM

DataSource AS X

FOR XML EXPLICIT

You _can_ use the OLE DB Command component but if dealing with many rows, it will be slow as SQL handles the rows one at a time.

If you do have...

Please never say "some sort of error" Tell us what the error is. it's the only way to help you.

Two possible solutions:

SELECT

Documents.Name,

purpose,

Files.name,

Files.FileSize,

Files.Version,

Files.DatePublished

FROM

Documents

INNER JOIN(

Select

Max(Version) as Maxversion,

DocumentID

From

Files

Group By DocumentID) AS...

Hold on a sec...

You say this is enormous. How big?

The process SQL takes when doing a restore is first create the files and then seems to stamp them with something....

Not as far as I know.

You can ensure that it is indeed running my checking it's SPID. Should say "Database Restore" but I don't know if there is a way...

I don't think you can retrieve the information from a different spid on the state of a restore but it you run the restore as script, you can give the...

Another thought I had: Try and create a text file using a script task and the value obtained from the variable. if that does not work, it might at least...