Do you know what servers the instances are installed on? If so you could write a powershell shell script to get this info. (example Powershell script[/url])

If you don't know...

another option would be to encapsulate each proc in a try-catch block

BEGIN TRY

EXEC storeproc1

END TRY

BEGIN CATCH

PRINT 'storeproc1 failed'

END CATCH

BEGIN TRY

EXEC storeproc2

END...

was there any install log after you canceled the install?

I would think that since you have an error, even if you could get the installation to complete, it would not be successful and you would not want to use...

check the log @ C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<datetime>\detail.txt.

any errors or what is the last successful command.

You probably have to create a new database instead of just changing the one that you currently have. If you have many reports configured in your current database, you can...

here you go, just in reverse.

http://technet.microsoft.com/en-us/library/bb326407(v=sql.105).aspx

Here is a powershell script that will query your CMS and check for the SSAS service on all servers in your CMS as well as whether the service is running...

It is a pretty slick tool. It does make for much easier searching than sys.sql_modules. 🙂

I tend to use this when looking for references in views, procs, functions.

SELECT *

FROM sys.sql_modules

WHERE definition like '%<search string>%'

try using dynamic sql for your alter query

declare @sql nvarchar(max)

set @sql = 'ALTER DATABASE '+@TableName+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE;'

exec sp_executesql @sql;

The powershell requirements are listed in the link provided. You would need SP2 for windows 2003 and CLR 2.0 which is include with .net framework 2.0, 3.0 and 3.5SP1

You would...

What windows version are both the servers on? Powershell comes installed by default on windows 2008 but you will need to install it on earlier version.

you can get the installer...

I am hardly and expert on XML path and HTML, novice is more like it, but I have used similar method to send HTML emails.

you will need to split up...

If you want to script out the linked server definitions, here is a powershell script that will accomplish this.

Add-PSSnapin SqlServerProviderSnapin100

Add-PSSnapin SqlServerCmdletSnapin100

$server="<servername>"

$scriptpath="<path of script file>"

cd SQLSERVER:\SQL\$server\DEFAULT\LinkedServers

$Scripter=new-object ("Microsoft.SqlServer.Management.Smo.Scripter") ($server)

$Scripter.Options.DriAll=$True

$Scripter.Options.IncludeHeaders=$True

$Scripter.Options.ToFileOnly=$True

$Scripter.Options.WithDependencies=$False

foreach ($Item in Get-ChildItem)...