The MSSQLSERVICE is NOT running on my local machine; and I can't figure out how to run it. In fact, I don't even see it in the list of local...

Thank you for your response.

Bob

Thanks for your response, Pam. It turns out that I just added an "Sql Task" to my DTS to handle those Null columns; the Sql code inside that sql task...

I would love to implement it using the OOP method as follows, but I still don't get a message !

oDatabase = osqlserver.Databases("orderfx1202")

pMsg = ""

oQryResults = oDatabase.ExecuteWithResultsAndMessages("restore verifyonly from

...

I was wondering if you ever got this resolved. I am writing a small app in Visual foxpro 8.0 to use SqlVerify, but there is no response whatsoever.

Actually, this line...

I forgot to set the default values on those new columns.

Thanks anyway folks !

Thank you for your suggestion. The distinct keyword was the key input there.

Here's what finally worked for me (I forgot I needed to first match against the extrn_name column) ;

select...