Ah, this looks very useful. Thanks very much for your help.

lmu92 (10/13/2009)

cjohn5552 (10/13/2009)

Thanks for your reply. The query is of the form:

select personID from people

where height = 'X'

and weight...

Hey,

Thanks for your reply. The query is of the form:

select personID from people

where height = 'X'

and weight = 'Y'

The...

Hahaha, that's funny. No wonder I was having trouble finding documentation for those "keywords". Sorry for the misunderstanding.

Thanks for the link. I'll take a look at it, and see if I can make sense of what happened.

No. Do you know how to do this from SQL 2008? I'm not familiar with the interface for the RM in that version, and that's what's on the servers.

Hehe--excellent question, Jeff. That leads me to my next question.

When table names have similar beginnings, the query generates duplicate file names. If the table names were long enough, I suppose...

Ah! With a little bit of Googling, I discovered the SQL equivalent of the Mid function is Substring. Thus, the following code gave me what I wanted:

+ ' -o c:\resync\tdOutput'...

Thanks very much for your reply. I actually don't want to create any tables in the databases based on the TableDiff results. I'm mainly looking for a good way to...

Ah, turns out I just wasn't being patient enough. The query file did eventually generate. My apologies for this unnecessary post.

[feel free to delete it]

Yeah, well the bit about restoring with move is after that:

SELECT @stmt = 'restore database PracticeRepository' + @ClientAbbreviation + SUBSTRING(@RestoreDate, 5, 4) + 'from Disk = ''' + @ArchiveDir +...

Hey, thanks for your reply.

I actually talked to a colleague about this, and he was able to tell me a good way to do it. I'm including the query below...