Paul many thanks, great work. I ran against a test system. To confirm the output (see attached).

The first 2 rows returned the column name that changed (EngineeringOnly) Row 1 Value...

Thanks Paul.

Phil.

Hi Paul. I would want one row per record (ProductHistory).

This is how it works....

User changes Product record. Prior to the Product record being updated the current product values are saved...

Hi, apologies for the day in posting back I blame those end users!

Yes Products will only contain a single instance for each product.

The example code I posted was fairly simple...

Please find attached sample code script.

The script will create the 2 required tables + sample data.

Products contains a single product (the current product)

ProductsHistory contains that ProductId prior to each...

OK, will post ASAP.

Phil.

Thanks. I do not believe I have DAC enabled for any instance of SQL at this time.

Phil.

Thanks Jeffrey, I will take a look into that.

Kind Regards,

Phil.

It appears you can log events on the database (DROP_TABLE) but not log if the database itself is dropped.

Thanks,

Phil.

Thanks for the link.

Phil.

Have you tried simply restarting the instance?

Check list here:

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/

Phil.

Thanks Jason, stumped then in this instance. I will look into your suggestions.

Is there a stored proc I can run to obtain login information against a database login account (created...

Thanks Gift.

Linked server?

Thanks for all your input.

Phil.

PS: Great links.

Gift many thanks.

I have rolled out the install on the current version.........I will look to backup then upgrade.

Found this regards automating backups in SQL Express for those who might be...

Hi Gift. No I did not know that. Are you saying I update using the standard SQL service packs that I would apply to the full version of SQL? I...