Gila,

I am looking for a query to convert data in VARBINARY(MAX) to be displayed in XML

can you help

yes I understood that :)) thanks ...I have changed it to 90 and as I see the fragmentation rate has lower down,it is not that frequent as it used...

it was always the same ...can u suggest the number what should be in there ?

CREATE TABLE [dbo].[TEST](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[NIV] [varchar](17) NULL,

[SLT] [smallint] NULL,

[ORD] [nvarchar](12) NOT NULL,

[FULLSLT] [int] NULL,

[Status] [nvarchar](10) NULL,

CONSTRAINT [PK_dbo.TEST] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

Yes its a regular activity to change DMK and password for Cert

Can you help me with the steps to change the DMK and password for Cert??

What precautions do I need...

name KeyEncBySrvr

------ --------------

masterEncrypted by SMK

namepvt_key_encryption_type_descissuer_namesubject

---- ---------------------------- ----------- -------...

Actually It was done by an old DBA....I just have its password and Keys ....

Also how would I know whats the Subject of my certificate ??

Is there a Way we...

So you are trying to say that the password would be for DMK???

Then how would I change the password for the existing DMK??

thx for responding but I just wanted to know the Following :

Date 1:A and B are working fine with Logshipping Between them

A is Primary and B is Secondary

Date 2:A...

Other than Suspect pages is there any other thing that I should notice to run CHECKDB???

Appreciate your Support Here...Thanks for the Help.

Gail-- Thanks for Repsonding

your reply Actually Suggests that we Need to Do a Complete restore and there is no Other way to Sort out things .

Another Way of fixing...

Thx Gila Hopefully this may help me in understanding the transactional Logs and PLan for it

U sure that would not HAMPER My MIRRORING and LOGSHIPPING???

Hi All,

I was looking for the same Answer and I Found something really Helpful

Kindly go through the Following once and I m Sure woudl be a Good Learning for Starters...