Have you tried specifying a parameter size for Parameter 1?  Also, what system variable are you passing to that parameter?

John

Run sp_spaceused on A, then run it on B.  Use SSIS, linked servers or similar if you want to have it run centrally from a single point.

John

sp_spaceused should get you what you're looking for.

John

Exactly the same way you would on any other server.  What "size" are you looking for - physical size of the log or data file(s), amount of data in those...

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.