Don't worry I forgot about ISO_WEEK

http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx

I am 43, I did my MCSE when SQL Server 7 was the mainstream, I have done my best to move with technologies as they have been developed and released...

I totally agree, we have many customers on SQL Express simply because the databases are small and the number users accessing the databases is equally small, and of course it...

Never mind I have sorted it.

Thanks

🙂

Are you trying to automate this as a daily task or a one off?

Personally I would create a script, either vbs or batch that renamed the files and schedule the...

OD_Primary is the PK but what we want to log is the new value, the value that will change is od_linedisc

The deleted table will have the old value in it...