btw if i run this command :

DBCC CHECKIDENT ('#table', RESEED, -2147483648)

the values count upward toward zero .

My question is if it already reach Zero will it continue counting until...

Thanks for the quick reply !

I deleted the table first before performing reseed .

I heard if we do TRUNCATE , we don't need to delete and RESEED anymore ?

As...

Any feedback about this?

Hi Gail ,

Thanks for the reply !

I mean pause the mirroring process and insert data to mirror database . So if I want to insert data to Mirror database ,...

Thanks for the reply , I mean I stop the MIRRORING process first before I insert/change data

Ahh great !! Thanks so much for the reply

Cheers

Regarding this issue I just enable traceflag ? dbcc traceon(4135)

And surprisingly I got different error “Parent tag ID 4 is not among the open tags. FOR XML EXPLICIT requires...

Hi Guys ,

I just applied SP3 yesterday nite and also restart SQL server instance in order to re-create temp files

But unfortunately I still have this issue .

Msg 605, Level...

I have sorted it out guys , It is due to the maintenance of disk so there were 6 hours downtime

Thanks for the answer 🙂

OK. Will do ,thanks !

Thanks for the reply guys . Much appreciated !

Actually at that time I also used Performance monitor ( the value for TOTAL SERVER MEMORY was 1.6 GB – the same...

Thanks for the reply Gail . Really appreciate it .

Regarding Service Pack , after the server migration I don’t apply any SP to that server ( Previously yes it...

The problem is I am not sure that those servers use reporting services . if both use then it means I need to point to 2 different report servers then...

Thanks for the reply !

I just checked the destination server and it has reporting services running there also when I go to Reporting Services Configuration Manager > Database, It...