Thanks Scott for getting me started. The problem is we've inherited this system and unfortunately there were no backups. Can I still get away with using DBCC?

I was able to produce an XML file using FOR XML EXPLICIT. Now my problem is producing the output without:

a) header - XML_F52E2B61-18A1-11d1-B105-00805F49916B

b) rows affected - (658 row(s) affected)

c) carriage...

Thanks that works perfectly. Although, I need to create an xml output from this. So all I did was append the FOR XML EXPLICIT. Now, when I run this I...

Let's just say, I need to return (2) columns in XML format. Like this query. How can I put this in a stored proc to return xml format. Also, if I...

So far this is what I have with some of your guy's help:

select a.userID

from sandbox.dbo.ymeUserID2 a with (nolock)

where a.versionDescription = '1.0'

and not exists ( select * from

                 sandbox.dbo.ymeUserID2 b with...

sorry,

userID=int

version# is actually versionDescription=varchar(200)

Thanks..We have a lot in common then (oracle dba learning sql server). Ping me at melsterdba@yahoo.com, maybe we can share some notes!

Thanks. Here are some of the books I've ordered. One includes a book by Henderson:

Guru's Guide to Transact-SQL - Ken Henderson

Inside Microsoft SQL Server 2000 - Kalen Delaney