thanks ps.

i have gone through that link.

please provide some other links.................

thanks a lot.

thanks its completed.

CREATE TABLE DataBaseMirroringStateChanges

(

EventTime datetime,

EventDescription varchar(400),

NewState int ,

DBname varchar(400),

)

The record should...

CREATE TABLE DataBaseMirroringStateChanges

(

EventTime datetime,

EventDescription varchar(400),

NewState int ,

DBname varchar(400),

)

The record should...

i want to store the database mirror state changes in table ,

can u pls give the query?...............i want to do this through T-sql statements not through GUI.

yes.

if a principal server suddenly fails, if the mirror server has confirmation from the witness, it can automatically take on the role of principal and make its database available within...

Thanks steve,

I want to prepare the StoredProcedure for minitor mirrored databases.

It means i should get the alert mails when the mirror database takes the charge.

(If principle database gows down then mirror database takes the charge.

Then that time i want to get the alert message with both databases status.)

I need the sp for...

.....

u r asking database status?

thanks ............

thanks.......

That table have a identity column.should i delete identity property?