will try to register it and hope it will work.. keep you guys updated .

The link in the solution provided in not working ....not the msn link.. the the link in the other forum that takes you to the solution page... they are taking...

Any help ?

Any help ?

No I am not using the same package.. I created a new package and offcourse used the same script.

this is the script by the way.

DECLARE @dbName varchar(200);

DECLARE @mirroringStatus int;

DECLARE myCursor...

any one has any idea?

Thanks

Hi,

my boss just on the fly changed the requirements a little bit ;-). so here I am again.

the SSIS package doesn't need a input from a file.

step 1: the ssis...

Thanks for the Reply....

I will give it a try ... keep u with the updates too.

thanks for the help.

I figure out the way how to load data from the excel file ( in my case that will be the name of the databases) in to ssis package.

Now how...

Thanks for your reply.

Dont want to sound too much of a rookie but how would I proceed after that ...

lets say based on your code the value is not...

well we have a database mirroring disabale job that we run on demand..and since we have 25 databases we have 25 different jobs for each database.

i want to have a...

Also , if i can just run these commands dynamically , what I mean by is .... since we have 20 database on the server and to run a job...

Thanks for the reply... yes it does help so if the all the rows are null in the table except database_id that means mirror is disable so the job would...

Just want to let every one know.. with all of ur inputs I was finally able to convince her to go for witness server..... on express edition.

Thanks for all ur...

Thanks for the help guys,

how to go about adding witness server ...

first install the free express addition on the server ??... can it be installed on the same...