Thanks SQL Noob and Gail Shaw....

Thanks Gail Shaw and SQL Noob,

I was under impression that we need to have FULL recovery model for Replication. My case SIMPLE Recovery Model will work.....

I got logical explanation for...

Let me clarify......

SQL Noob,

It's the production database so FULL Recovery Model required and also we replicate tables too...

Now the application is Heavy heavy Insert and concern is that Log...

Thanks. I got it. My other interest is to know how will effect performance....

How will it effect performance depending on log size small (LOG BACKUP SO LOG FILE SIZE WILL...

Window Authentication will not work. SQL Server instance should be Mixed Authentication.

Provision a login id and grant proper database access to the login id.

Now you can connect using this login...

Thanks all.

I got my answerd from valued members in this forum.

NOT TO USE (IF EXISTS)

Thanks Andras for your response.

YEs I do have Clustered index on the day column and It is in single transaction.

I have many more columns in this table but I used...