Hi,

How to reinstalling only Ssms on a exisitng sql cluster instance ?

any idea or info plz...?

avance thanks

In 2000 server we have list of all packages deployed in the MSDB database and we dont any Filesystem packages.

Can we do in below way for migrating the those msdb...

We will do migration side by side.

Is it possible to restore sql 2000 sp4 backup file on sql server 2008 r2?

Thanks for reply,

Here have configured MSDTCs in Spearate group.

So i need to map them to specified instance.

Is it possible to move the Msdtc to slg group from Msdtc group?

and...

Thank you for help and info

Thanks for reply,

Can you help me in command to map the sql instane with MSDTC instance names .

msdtc -tmMappingSet -name <MappingName> -service <SQLServerServiceName> -clusterResource <MSDTCResourceName>

Here What is Mappingname ...

Thank you for sharing the Info...

Thanks for the information,

so what i unsderstand from the above info is ,

" After Sp2 only the latest cumative update is enough..."

Sp2+Latest clumative update

Isit right?

Thank you in advance..

Thanks for reply,

In ipadress tab, i could see Tcp port column on IP1,IP2,IPALL .

Please clarify do i need to change only TCP Port column on IPAll or i need to...

Thanks for reply,

Blocked queries that are hitting the table ,contains non cluster indexes which is have fragmentation(avg freg colum >50%)....plz clarify whether rebuild is best option for troubleshooting the...

I am SA permission on that and we have not implemented ddl trigers on it

thank u

Thanks for reply,

Can you please tell me know ..

How to find the DDL trigger implemented that fires for create database statements

Thanks murali for reply,

i have tried with below commands and got the same error.

SET QUOTED_IDENTIFIER ON

Go

Create database <DBName>

i am using

create database [databasename]

We are able to view the error log through application log(event viwer) and able to access error log path manually,but not able to view through SSMS and through Query window..Xp_readerrorlog...