Hi Kusen,

First, Thanks for the excellent script and keep updating with the feedback is enourmous.

I just tested the script by adding 'R' in two stmts (as you mentioned in...

The basic thing you need is to have 2 identical nodes for cluster and make them as cluster by installing cluster services in Windows Server 2003. And then you...

Gary,

I got this problem initially and then I tried creating the Linked Server from QA sp_addlinkedserver and then sp_addlinkedsrvlogin with required parameters worked well. But this problem was Creating...

Even I tried looking for the same info few months ago but I couldn't. Is that Microsoft deprecating this feature (or) would like to get more robust in future versions....

Thanks Scott and all who ever responded to my question.

It was successfull with the Replace function.  Somehow it is not working with Char strings char(13)+char(10).  It worked well with just...

Yes Joseph.  I use to work in either way from Workstation or connecting remotely to Database Server and open Management Studio on server itself.  My Questions is whether do we...

If you have running only default instance on the Server you can use the below query

USE Master

GO

sp_dropserver current_server_name

GO

sp_addserver new_server_name, local

GO

And makesure that this is not cluster environment.

After doing these,...

Jon,

It was obvious sometimes you wont see any Maintainance Plans. Have you checked the SQL Agent Jobs relates to any Optimizing, Integrity?  In some areas they create their own jobs for...

If it has Bad Sectors, DBREINDEX also fails. Index Defragmentation will success but will not fix the Bad data. This seems to be some records corrupted say for ex: like float data types, divide by...

John,

Use this from QA

SELECT COUNT(*) FROM <CORRUPTED_TABLE_NAME>

Note down the Total No. of Records from a table.

SELECT * FROM <CORRUPTED_TABLE_NAME>

check how many records it is selecting (if you have bad data in the...

This is in response to Jayakumar Krishnan's post,  you have given an excellent information which exactly I am looking for.  I never saw that info anywhere even in books online, and I strongly believe...

Yes, I do.  But I am certainly looking from command prompt or from Query Analyzer.  I don't think we have some, but I am really looking for fail over test.

Thanks Greg,  I didn't realized that the query is only for current transactions. Eventhough I have a question about Trace. How can we get Past Info? like who has logged previously?

If...

Shahab,

You can use any 3rd party tool to get the Audit Info or you can use the simple query like this.... from master database..

SELECT spid, login_time, loginame, status FROM...

Then you have to check SQLAgent Connection Properties. Is that using 'sa' or any Windows Service Account? and also, if you have already changed 'sa' password in SQLAgent, you need...