Interesting, so it's a load issue with the distributor? Did you change to a pull subscription or update the jobs to use cmdexec?

I just re-read your last post and understand now, the maintenance plan is still looking for the reportserver db even though its gone.

From what I've read elsewhere, and...

You havent specified a database in your BCP connection. Add -dTestData

What's the exact error message is in the SQL error log?

Caffeine is good 😀

But I do agree, use the SQL92 (OUTER JOIN) standard for joins, it's supported in SQL2000 and higher, so can't see any reason to use the old...

You need to change the default database for the login which is running the maintenance plan, it must be set to the reportserver database.

That is incorrect, if you remove the WHERE clause, you're getting a cartisian product or cross join (every record from left joined with every combination from the right). A...

The SQL89 standard for outer joins is *= or =* depending of you want a left or right outer join.

eg.

select t1.c1, t1.c2, T2.COL3 from t1, T2

...

Procedures and their definitions modified in the last 7 days

SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition

FROM sys.sql_modules AS sm

JOIN sys.objects AS o ON sm.object_id = o.object_id

WHERE o.modify_date >=...

Sometimes this will tell you the group (sometimes not if theyre in multiple groups with access)

xp_logininfo 'loginName'

You can't rename an instance, so that method will not work.

Plus you'd be repointing your applications twice when once would be fine.

It depends what you plan to use the secondary instances for.

Selecting a High Availability Solution: http://msdn.microsoft.com/en-us/library/bb510414%28v=sql.105%29.aspx

Replication will work, performance depends on the number of transactions, but there are performance...

You can change data access mode for the oleDB destination object to "table name or view name variable" then assign a value to the variable via an expression or other...

You can enter a dynamic destination using an expression https://www.simple-talk.com/sql/ssis/working-with-property-expressions-in-sql-server-integration-services/

Leave your existing settings as they are, the destination will be changed by the expression on execution.

You'll need a variable which...

I think he is saying his instance is not listening on 1433 (which is the default, instances are a non default port). If it's hard coded, it's bypassing SQL...