[font="Times New Roman"]

Hello Marry,

Pease understand if i wrote SP to avoid SQL Injection then obviously i would not any ad-hoc query within SP.

Regards,

Anil

[/font]

[font="Times New Roman"]

Thnx Gail:-)

[/font]

[font="Tahoma"]

Thanx a lot Gail.

[/font]

[font="Times New Roman"]

Thanx a bunch my friend.

[/font]

[font="Times New Roman"]

I checked that link. Nice to read from it.

Regards,

Anil

[/font]

[font="Times New Roman"]

Its means when we pass diffrent values to input parameter, execution plan for SP is reused.

I am a bit confused. Can you please explain it in detail?

Regards,

Anil

[/font]

[font="Times New Roman"]

Thank you my friend, let me chack it.

Regards,

Anil

[/font]

[font="Times New Roman"]

Hi,

Store procedures are not compiled every time. Usually execution plan for store procedure is reused.

When there are some changes in input parameters or underlying table from which SP...

[font="Times New Roman"]

If recovery model for database is Full you should first take tail log backup before restoring. It will ensure that the modications that are not included in...

[font="Times New Roman"]

Hi,

Full back up the baseline backup meaning full back up should be taken before diffrential backup and transaction log backup.

Once you have restored full backup in Norecovery mode...

[font="Times New Roman"]

Nice question!!

[/font]

[font="Times New Roman"]

As far as my knowledge is concerned, it happens in that way. Please come forward and add few valuable and concrete facts.

Regards,

Anil

[/font]

[font="Times New Roman"]

Followed by Muthukkumaran's reply

Restore a full backup with norecovery on 6/22/11 +

Restore a Differential backup with recovery on 6/25/11 if you don't have log back up

...

[font="Times New Roman"]

Hi,

After configuring transaction replication, Just reitinilize the publication on which merge replication is being implemented and check whether it works.

i hope it will.

Regards,

Anil Kumar

[/font]

[font="Times New Roman"]

Hi,

You might be aware that all modications made to data are recorded in the transaction log file for recovery purpose. Log back up copy these modifications from ...