Hi Deep,

Have you checked whether Node1 or Node2...

Hi,

...

Hi GilaMaster,

Sorry, i have updated allocation error for my privies comment and consistency purpose below command can use..

use master

go

alter database DBname set single_user

GO

dbcc...

Hi Mitesh,

Use the below command for consistency errors..

DBcc updateusage(BDname, "Tablename")

Regards

Satish

Hi Stuart,

When i have put a comment on same he respond me, before you drop the database what all are the things you...

Hi Anthony,

Thanks for responding, even i doesn't no the meaning of decommission, some one asked me the same so i...

Hi,

Because tomorrow any one came try to connect SQL DB get error, so i have checking whether need to uninstall SQL 2005.

Satish

Hi Rama,

As per customer request i have upgraded SQL 2005 to 2008 Developer edition then i done Edition Up-gradation successfully. I have small query need to uninstall...

Hi Rama,

I am able to connect SQL SERVER 2008R2 through SA but SQL SERVER 2005 is not connecting.

All services and...

Hi Pradeep,

My advice is, first you check the table structure and then check the query execution plan. It will help to which column is...

Hi,

1st you execute

ALTER DATABASE Dbname SET PARTNER OFF

Then you execute below query

RESTORE DATABASE Dbname WITH RECOVERY

It will work..

Satish

Hi Gila,

Can it is possible with replication (primary server)?

Satish

Hi Ramy,

can you clear my query...

Automated script for all DB mean dependency one to another database? mean in primary server when one database will fail...

Hi,

Please refer Parry comment. In work group environment required certificate to trust each server.

Satish

Thanks Pretty,

Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.

Thanks

Satish