Thanks for taking time to reply Gale!!

Sorry to trouble you and disturb you.

one last question i am giving an example:

In my server i have two databases  Test1 and Test2

Test1 contains...

Thanks for taking time to reply Gale!!

Actually i don't have knowledge in SQL related stuff,I am very much thankful if you can provide small examples in the above concept you...

Thanks for the reply Williams!!

one more question i have

Question:- I have two databases in same server assume Realtime database and Backup database these two databases contains 25+ tables.

i have done...

Thanks for the reply Williams!!

Is it possible to provide any sample/example of transactional replication?

As I am totally new to  this sql related stuff.

If you have time kindly help me

Thanks,

Sampath

Thanks for making your time for reply Chris!!

Is this just a one way transfer of information, from Database1 to Database2, or is there a need to also send updates from...

Thanks for the reply Williams!!

This was you question

I cannot help you without understanding the goal of your request.  If you can answer why you need to do this and what...

Thanks for the reply Williams!!

I am a beginner in sql related stuff ,i am not not able to achieve my requirement of delete/update/insert when tables in database1 is  changed automatically...

Thanks for the reply Williams!!

Actually i am not sure it is that much complex to write a trigger to delete/update/insert when tables in database1 is changed need to automatically delete/update/insert...

Hello Jeff,

Thanks for making your time for reply!!

Can you help me out with better solutions you have that would be great.

Thanks,

Sampath

Hi Williams,

Thanks for making your time for reply!!

why do you need a copy of the data in the secondary database?

My reply:-Actually my task was to update  the data across different...

Hi Chris,

currently the database1 and database2 are in same server.just for info i am giving one example

database1 and database2   contains same  tables employee,college.

employee table contains fields employeeid ,employeename and...