Both sps we are running manually thorough ssms on Same server and databases .

Thanks for update,

We are using Virtual Machine, with Windows Server 2012 R2 on it

Many Thanks

Hi All,

I observered that some ssis activity(queries) from application side is going on one of the reporting database due to which cpu is going high ,but this activity...

Thank you all for your valuable info,

a)From last two days i have observed that when i run the SP_who2 ,for one of the databases(reporting db that application facing performace issue)...

Thanks for reply,

How much time will it take to complete the upgrade..?

What are the precautions need to take before upgrade.?

Thanks for replying all

Hi samalex

,

Below is db2 and os deatils.

DB2 verion and OS is db2/6000 8.2.7 on AIX.

We will not be having access to DB2 server for security reasons ,...

Thanks for update.

I guess the DB2 syntax and data structure is total different.i think i need to modify the data structure according to SQL server.

Is there any free...

Thanks for reply,

" use a slip-streamed installation of SQL and SP2 ?"

Can you tell me how to combine SQL with sp2 ( slip-streamed).?so that it will reduce m time while...

Thanks for update.

Can i run DBCC updateusage only for that particular table which i got error.

please suggest for below steps which am following is correct.

dbcc updateusage(databsename,'TblRecolTemp')

use [databsename]

DBCC checktable ('TblRecolTemp'

Thanks for update,

Sql server is 2008 version,

on the Sql error log i coud see the below error to

DBCC CHECKDB (DbDtkMain) WITH all_errormsgs, no_infomsgs, data_purity executed by NT AUTHORITY\SYSTEM found 2...

Hi,

Yes TSM is 3rd party backup tool .

if we keep Truncate value Yes then i guess log backup chain will be broken..and we will not able to restore in...

Thanks Matt Crowley for reply,

What i understood from your reply that

sql is not listen on ip address of both nodes but listens on virtual Sql ip address and...

Hi All,

Any one please guide me about MSDTC configuration.

Many Thanks.

We have more than 50 tables on that database.

Is there any other way to do that or

TO change the collation all at a time.

THanks.

Thanks for reply...

We are migrating sql 2000sp4 to sql 2008 r2 and sql 2005sp4 to sql 2012 ,so i think it will be possible to do that,

but i wiant...