Hi Elisabeth,

Could you give me your suggestion about replication?

1. we try to publication all tables, some tables has been published, some tables are not published becuase PK key not mention.

2....

Hi Elisabeth,

What a quick response to me, it was really excellent. Now we got clear idea about transactional replica type.

Thank you so much

Thanks & Regards

ananda

hi,

I got clear idea about replication model, we are go for DR planning with transactional replication. (it is powerfull replication type with sql 2000)

thanks Elisabeth,

Hi Elisabeth,

Thanks a lot for your valuable reply.

In trasactional repliaction as follows

1. Publisher and the subscriber are always in synchronization

2.Transaction boundaries are preserved, i.e, if there modification to 5 rows...

Hi elisabeth,

Thank you very much for your valuable reply.

hi Gail,

thanks for reply,

Both server n/w was getting reply,

agin i try to register second sever from server one. alternative i register first server to from second server.

same error display

error is...

hi gail,

thanks for reply,

i have checked all the activity

1. windows firewall stoped.

2. select the second server name from the list, not typed.

3. N/W is getting reply.

But second sql server 2000...

hi,

Thanks for reply.

I try to through register sql server wizard, and select the available server name, it was not successfully registered,

I got error msg like sql server server does...

1. First server name jgsrvr28

2.Second server name WJMN0130136

Both windows 2003 server running same domain. pls tell me how to registration from server WJMN0130136 to jgsrvr28.

hi jones,

please tell me how to execute script in sqlcmd, thaks

hi thushar,

Actualy what i want, this table script procdure retun value like

Table name,how much rows and total size of table, so i could get 3 result set.

The above script i...

hi Lester Policarpio ,

Thanks for reply me.

Script was working fine,

Hi, thanks for reply

This is not working, pls tell me if any changes required. actuly file name like Northwind Backup Plan4_200810111149.txt it has been created after completion of backup every...

Hi kishore, one more clarification, pls tell me

alter proc dateformatproc as

Declare @FileName varchar(255)

select @FileName = 'c:\Northwind Backup Plan4_' +

replace (replace (left (replace (replace (convert (varchar, getdate(), 120), '', ''),...

kishore, thank u very much for valuable reply