ann - could you pl. check out this query and see if it works...I can't test this right now...

select restore_type, physical_device_name, destination_database_name, restore_date

from restorehistory rh

inner join

backupset bs

on

rh.backup_set_id = bs.backup_set_id

inner join

backupmediafamily...

Unicentro - THAT's it!

ps:"La musica, la comida, las campas y los gentes...me gusto mucho la paiz"...Omar Khayyam said something quite similar - except in his case I think it was...

thx. for explaining...NOW the concatenation makes perfect sense!

ps: should this be:

Select col1, col2 from dbo.BookDetails where ';' + BIC + ';' like ';%' + @VarName + '%;'

I'm not sure I understand the returning JK% part...

eg: If I did something like -

IF(SELECT CHARINDEX('JK2', 'TRC, JK, JK3, YS, HA')) > 1

print 'alright'

ELSE

print 'oh no'

Remi - why not:

IF(SELECT CHARINDEX(@VarName, columnName)) > 1

do....

ELSE

do.....

Isn't this what they call an "insupportable claim" ???

Hasta "now"....was in Bogota for the most part - did visit Cartagena for a week - must tell you that there were little kids peddling dope - & quite openly...

Polling hasn't begun yet Remi - hold your horses!

maertean - thanks - I beilieve though (ann can set me straight) - that she needs a list of all the files that have been restored - so do you...

There's a war between the sexes ?! How come no one told me ?!

ps:For the most part - women live by:

ours not to reason...

KSumner - I didn't read the entire article but it did take me back to my days in India where I would watch the villagers pick up cow dung, pat...

Because Steve asked everyone to suck up and we always do as we're told!!!

You haven't said what syntax you are using and what error msg. you see...

here's another post that discussed the exact same issue - maybe it'll help:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=200830

"skewed" - what a masterly understatement!

Pax!

btw - "...the worst thing to happen is one spills the rum or coffee while sitting by a quiet...

My my - this is getting rather profound, isn't it?! But since it's an "almost weekend" I guess I'll take it in my stride...

Philosophically - most (if not all) of...