Create text file srvList.txt with all your instances names (each line is new instance). Then run this from command line:

FOR /F %a IN (srvList.txt) DO osql -S %a -E -d...

I would be interested as well to learn the difference of how SQL Server handles this because there are apparently many cases when whole procedure cache cleared (http://support.microsoft.com/kb/917828)...

You can use cliconfg.exe utility to create SQL Server alias MyServerInstanceOne.company.com on client computer.

You can use Profiler events "SP:Recompile Event Class" under "Stored Procedures Event Category" and "SQL:StmtRecompile Event Class" under "TSQL Event Category".

I would recommended to disable job for the time of...

I would add SET NOCOUNT ON as the first line in stored procedure (before "BEGIN"):

"setting SET NOCOUNT to ON can provide a significant performance boost, because network traffic is greatly...

Kimberly Tripp started great series Spring cleaning your indexes if you want to find out more about indexes cleanup.

Yes. Run EXEC sp_help_jobhistory @job_name = 'job_name' , @start_run_date = start_run_date . Start_run_date must be entered in the form YYYYMMDD (int).

No, it will not interrupt your production databases. The command is very safe. Check the output from this command. It should return list of SQL Server sysadmins. If you get...

Try to connect with command line (you have to log in as this new user):

osql -S SQLServerName -E -d master -Q "EXEC sp_helpsrvrolemember 'sysadmin'"

Yes, you can do it.

Create "Operating system" type job step: "sqlcmd -S SQLSRV -i C:\Tests\TestCMD.sql"

example of TestCMD.sql file :

:Setvar BackFldr "C:\TestCMD\"

!!if exist C:\TestCMD\*.bak (move K:\TestCMD\*.bak K:\TestCMD\ARCHIVE\) ELSE (ECHO No files...

Two questions:

1) Have you tried to register SQL Server under SQL Server Group in Enterprise Manager?

2) Can you verify that BULTIN\Administrators group has login on SQL Server?

I run these queries as the first step when I have complains about performance:

select top 10 * from sysprocesses order by physical_io DESC

select top 10 * from sysprocesses order by...

There is no advantage of having multiple log files in SQL 2005 and later. The files are not used at the same time. Second file will be used after the...

I know for sure that Database Mail depends on Service Broker activated for msdb.

I replied "No" because I would restore to the point of time when restored the last log backup.