hmmm - ann - I see the name only in the "backupmediafamily" - still looking to see how it links up with the restore tables....

EBS....so CR is safe because it has nothing to offer but coffee ?! You left out rum...a liquid staple of many - seriously...

Welcome to the east coast....not to rain on your parade but they (the very reliable weathermen) DO say that there'll be scattered t-storms throughout the week...we'll try to keep them...

I will (exercise the utmost restraint) & strive to maintain the tone of non political sentiments...for after all, this IS about the senseless killing of innocent victims who were caught...

are you looking for something like this:

select logical_name, physical_name, filegroup_name, user_name, destination_database_name, restore_date

from restorehistory rh

inner join

backupfile bf

on

rh.backup_set_id = bf.backup_set_id

order by restore_date desc

what kind of trigger is it ?! what is the ddl of the table that the trigger is set on ? what is the syntax of the trigger ? what...

ok - then this:

select * from information_schema.columns

where table_name not like 'sys%'

order by table_name, ordinal_position

Or this...

select * from information_schema.columns

where table_name like 'sys%'

order by table_name, ordinal_position

Harshen - not sure if you're responding to Dilip or me - however, does my query not work with your table ?! I am selecting all fields and getting the...

Glad it works!

Aah Remi - you speak like someone who's always been given a free hand....just consider yourself lucky!

Danny - why don't you post the DDL of the "table in question" &...

Glad it works - thanks for getting back!

ps: Don't let Remi hear you say you've been using a, b, c....as aliases...he can get pretty intimidating when he wants to...

I'm not sure if this is what you want and I can't seem to find the link to the post right now that discussed (what seems to be) the exact...

tsk!tsk! you could have lived to see "veteran" days...

if you can hear me down there (as you transit Styx...) - edward - you will be missed!

ps: you met a gruesome...

That would be a fitting end to a rogue like GPF (Edward W. Stanley ??)....

the moving finger writes (types) & having writ moves on....adieu again..