That is confusing - how did you 'copy' the view from QA to production?  And how would that create a table instead of a view?

You stated you used the code...

I am just going to comment on the last post here - not sure what else has been stated.  The problem with the view is the fact that you are...

You just add the additional columns to the statement, the following adds the columns as empty strings:

$LastLoginQry = "SELECT `
Distinct SUBSTRING([ModuleAndEventText], charindex('\', [ModuleAndEventText])+1, charindex(' has logged in',...

I don't - I stated there is a time zone *offset* requirement.  If you don't have the offset...

I'm saying that there's a number of ways to get timezone without using a datetimeoffset and for that matter without even storing timezone itself because that information can often...

It is interesting - the DATETIMEOFFSET data type is natively stored as UTC and provides the offset that was active at that time.  To the point where you need to...

To my point - if you are using datetime or datetime2 and need to be accurate across time zones, then you must have some method of determining the offset...

We can agree to disagree - but let me ask you this: How can you determine which entry in your table was entered in New York - and...

My rub on the subject is concerning portable devices.  It's not like people religiously change the timezone on their machine and what does datetimeoffset in EF use as a...

My point is that deciding to use a DATETIME2 and only storing UTC dates/times only without also storing the time zone offset or time zone information is inherently...

We can agree to disagree - but let me ask you this: How can you determine which entry in your table was entered in New York - and...

We can agree to disagree - but let me ask you this: How can you determine which entry in your table was entered in New York - and how do...

I selected what was provided as the 'correct' answer - but I disagree that is the correct answer.  For a system dealing with multiple time zones - you actually want...

You asked how to use WinSCP in SSIS - the assumption would be that you are currently using WinSCP manually to synchronize the folders.  Is that correct?

My next...

This means removing the database from the AG, and shrinking the log by whatever means necessary,...