This will give you the current status of jobs running, saw it on a forum site I use it to monitor long running jobs, they are still running so no...

Just a quick question, related somewhat, if the mssqlsystemresource.mdf and mssqlsystemresource.ldf cannot be backed up by SQL and I am assuming as SQL has them open, while the service is...

If you don't add a windows login\group at install of SQL 2008 you will get locked out of you didn't set up the SA PW, the local windows admin group...

Creating a computed column with the substring on the underlying table and indexing that and using it in the where clause instead of the original column should also work.

Andrew

The log reader should be running while you run the snapshot so no transactions are missed between the snapshot finishing and you restarting the log reader. Be aware that the...

You could also list the services through SQL as well, this will tell you if the reporting services portion was installed, won't tell you if it is configured\used

create table #test...

What rights does the login have that has been used to set up the linked server, if it has limited rights it might not be able to read statistics and...

This series of articles details how to remotely collect server info:

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/61621/

Also, is SSIS installed on both nodes?

Andrew

Maybe you need to rework the MsDtsSrvr.ini.xml file so SQL knows where to look for the packages

http://dougbert.com/blogs/dougbert/archive/2009/04/09/ssis-and-clustering-what-you-should-do-instead.aspx

Just a thought

Andrew

This is what I use, beleieve I got it either here or another forum site:

USE [master]

GO

/****** Object: StoredProcedure [dbo].[AutoStart_SQLAgent] Script Date: 12/17/2009 15:37:11 ******/

SET ANSI_NULLS ON

GO

SET...

With Veritas clustering this can be done, but not with Microsoft. I think it would it would be good if it was available in MS, the servers that are usually...

Can you confirm the error logs are on a drive that is accessible by the cluster?

Andrew

Did you have a failover, are the SQL error logs still available?

Andrew

I don't know how sophisticated the product is now, but when I first started working in one shop they had a couple of critical servers set up using this, I...