What account is used for the linked server setup, if it does not have the rights to execute DBCC SHOW_STATISTICS then that might be why the index is not...

You can also use ole automation, see below, picked the script snippet up somewhere, can't remember where though

--SQL

declare @DomainName varchar(128)

declare @hr int

declare @sysInfo int

--create a package object...

exec @hr = sp_OACreate...

Can this be wrapped in proc and use execute as?

Andrew

For the SQL Error logs I use an SSIS package that uses a forloop each container to connect to all my production boxes and use xp_readerrorlog to gather the logs.

I...

Is this 64 bit or 32 bit SQL instance, I know we patched a 64 bit instance by mistake with 32 bit SP3 and it installed fine and all the...

I believe the SQL 2005 install installs a cut down version of VS, unistall the full blown version of VS and install SQL 2005 and then install the full blown...

You can get the backup details from the below SQL punt into a table and then use the date fields and file paths to create a dos copy via xp_cmdshell,...

Daft question, but this is itanium chips you are installing on?

When you did the install for the clustering, the SQL portion that is, did you install the client tools on both nodes, the client tools will install on the active...

integration services is not cluster aware or instance aware, the connection is derived from MsDtsSrvr.ini.xml file which is stored locally on each node, I have a feeling the issue you...

I poll our clusters, connecting using the clustername, if the physical node changes that the cluster is running on I get an email. Run the script and punt to a...

Is this another instance other than the instance that is clustered?

when you refer to an alias, is this an alias on a client connecting to the 64 bit instance or an alias setup on the 64 bit box that hosts...

What are you trying to achieve, are you trying to catch\alert on a failover?

This is how management studio gets the startup params, I use this to poll our server in ssis and save the data in case of DR

CREATE TABLE #TEMPTOAD ( Argument...