Brad Mcgehee has written a couple of articles, one on clustering the OS and the other on clustering SQL 2005, I have followed these and had no worries:

http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx

If its a service running on a box with a SQL instance you can run the following SQL master.dbo.xp_servicecontrol 'QueryState', 'SQLServerAgent'

You can insert this into a table and set up...

You can add these switches and restart SQL in minimal mode, then rerun the modify file cmd.

-c -m -T3608

Better still give this KB article a look on how to...

As Brandie points out it may be a firewall issue, are you able to telnet to port 1434 on the box you are trying to connect to the SQL instance,...

If this is a SQL 2005 maintenance plan and the plan is ever updated, the job is recreated and the original plan creator is then assigned as the job owner,...

I don't know much about legato but is this a tape backup taking flat files or an app that backs up SQL DB's directly to tape, if it is the...

You should just be able to issue sp_cycle_errorlog until you reach you max set of saved logs, after that you can delete.

Andrew

Check out dbcc checkprimaryfile this is used by SQL before the attachment occurs, don't know what checks it does other than reading the .mdf but it's what SQL uses initial...

Jeffrey,

Thanks for the reply, I have looked at this, but I know this was not the link, this requires a DB be created on each monitored instance, I have 90...

Check this series of articles, does exactly what you want and logs any error to a table:

http://www.sqlservercentral.com/articles/Integration+Services/61621/

Andrew

This is fired whenever anyone looks at the server properties, it does not mean that a servers properties have changed, to find that out you need to get the properties...

You can change this using xp_regwrite, search this site for its use, essentially it writes to the registry, just find the key and you can change it. But wouldn't the...

Got this from this site way back, need to enable ole automation through surface area config tool so it will work on 2005:

set nocount on

/*****************************************

* Create temp tables for disk...

To get around this you can use SSIS configuration files, search this forum and you should be set, or alternativly store the package in SQL and when doing the import...

I would say so, it is wise enough to check and see if anything needs updating.

Andrew