How are you attempting to set the database owner, and what is the exact error message that you get?  What happens if you run this?
ALTER AUTHORIZATION ON...

Are you sure you actually tried LAG?

SELECT
    emp
,    date AS effdt
,    seq
,    hourly
,    LAG(date) OVER (PARTITION BY emp ORDER BY date, seq) AS last_change_date
,    LAG(hourly) OVER...

Chas

So from one database, you want to create a view in another database?  That's not possible, as far as I know.  Even if it were, imagine all the...

Do you have the INSERT statement that caused the error?  That should make it fairly plain which column caused it, when you see the number from the error message.  Are...

So you asked the vendor to add a data file but they added a data file and a log file?  I see this sort of thing quite a lot -...

If you're having to create views dynamically at run time, that suggests to me that the database design may be wrong.  Please will you share a bit more information on...

Why do you need to do this with just one connection manager for each source and destination?  If you have one for each client, you can do your loads in...

What have you tried?

You could use PATINDEX to search for '&#%;' and do the replace from there.  You may need a string splitter - I'm not sure.

I assume that the SaleCustomerContact table is one of the base tables in the v_SaleCustomerContact view?  You said that the views were a union of several base tables.  Therefore please clarify...

Yes, bad database design, almost certainly.  Are the tales being UNIONed Sales2017, Sales2016, Sales2015 and so on, by any chance?  When you said you updated the statistics, did you update...

I take it from the names of the three objects in question that they're all views?  This adds a further layer of abstraction that makes it even harder for us...

I suspect that you have values of FULLNAME that don't contain a ",".  In such cases, your CHARINDEX expressions will evaluate to -1, which is an invalid length parameter to...