All the tasks you mentioned belong to the DBA.

If you don't want to grant sysadmin permissions to a DBA, you're doing it wrong.

I see what you mean...

It is started by a process named DCEXEC.EXE which controls the Data Collector collection sets.

DCEXEC is invoked by a SQL Agent job generated automatically by the...

Thanks for the input.

I need the execute process task, unless there's another way to execute a process. How would a batch file help me here?

All the built-in collector types use SSIS packages to collect and upload data, but you don't have to install SSIS to make them work.

Looking in the installation folder of...

I have no idea why you need to restore msdb to work with DTA.

However, somebody is logged into that database and it probably is the SQL Server Agent login.

Stop the...

You need to grant ALTER ANY LOGIN to do that, which is the axact same permission granted to securityadmin.

In other words, you can't do that directly.

You should grant ALTER LOGIN...

A Google search with your exact words produces lots of results.

http://www.google.it/search?q=how+to+shrink+the+logfile+of+the+database+who+is+configured+in+replication

Are you sure none of those can help you?

The error message says it all:Operand data type varchar is invalid for subtract operator

Variance = '$ ' + REVERSE(SUBSTRING(REVERSE(CONVERT(VARCHAR,cast(round(isnull(sum(Current_Tear),0),0)as money),1)),4,255)) - <<<<<< This is your subtract operator

'$ ' + REVERSE(SUBSTRING(REVERSE(CONVERT(VARCHAR,cast(round(isnull(sum(Previous_Year),0),0)as...

A 10 seconds google search came up with this: http://stackoverflow.com/questions/2061113/sql-server-bcp-how-to-put-quotes-around-all-fields

Thanks for the hint.

Actually, everything in %programfiles%\Microsoft SQL Server\110\DTS\Tasks is missing in a system without SSIS components.

Searching the registry I found that each task has many entries and I...

Your question is a bit confusing and I'm not sure this is what you really want, however I think that LIKE is what you're looking for:

SELECT SomeColumns

FROM TableA

LEFT JOIN TableB

...

(Almost) everything you need to know about linked servers is listed here[/url]

See if it helps.

Anything useful in the remote server's ERRORLOG?

Are you able to log on interactively (SSMS, SQLCMD...)?

You're welcome.

Don't overlook Grant's advice. It will probably be easier to extract from the cache, even though you won't have all the information stored in the actual plan.

Have you tried using SQL Sentry Plan Explorer?

It shows plans in a more compact way and can display individual plans in a batch.

EDIT: Oh, last but not least, it's free.