thanks for the reply

I just want to make sure if you got this as a windows scheduling task. Can you provide me the code for step i.e code in batch...

THanks for the reply,

I would want to do it for both DML and DDL but I need to find a way where I can get notifications whenever there is a...

Thanks a tonn for that reply,

It did help me out in redirecting application to the mirror server. I have one more question for you, do you know a way using...

Hello Guys,

I waas waiting for some help...?? anyone who can help me out??

Thanks,

Nikhil

Thans a tonn guys forr all the responses. THey really helped me. From your discussion I can understand that I cant have mirroring and replication or log shipping and replication...

Thanks for the reply, let me tell you scenario.

We need to replicate and also have a standby server at the same time. We were planning on doing it this way....

Thanks a tonn guys... for all the help....

INSERT INTO [dbo].[Table1](

[DATE_OF_COLLECTION]

,[DATE_OF_POSTING]

...

CREATE TABLE [dbo].[Table1](

[ID] [dbo].[ID] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[DATE_OF_COLLECTION] [datetime] NULL,

[DATE_OF_POSTING] [datetime] NULL,

[PAYMENT_AMOUNT] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS...

Thanks a lot manoj,

I tried to do what you just said. It says file not found. My case is I have to copy all the backup files in the job...

Thanks a tonn guys for all the help and the replies. I tried using it this way

This was the step which I created and gave type as cmdexec.

Copy C:\Program...

Thanks for the reply,

Thats a little too complicated for me, any1 has anything easier if I have to execute it in sql server mangement studio.

Nikhil

I could use it your way, but can you give me the code and also tell me exactly how to do it???

Thanks,

Nikhil

Thanks for the reply,

But if that is the case, why do they even have it in SSMS? I thought it is there for a reason. I mean I could login...

thanks a lott brian... I dint know all dat..