Hi Irfan

YES you can do this on Logshipping

Hi All

I am just replying my self to find out any luck with this Doubt, its still happening and i cant figure it out...

Try profiler to run a trace and see how long does this SP runs every time, this might give you a clear idea

If using SQL 2005 or 2008 mirroring is something to look into, its easy to set up and maintain and with almost zero down time

Thanks Steve, thanks a lot for your help, I will check the execution plans

Thanks Lynn, That explains a lot to me :-), got one more doubt, If we create a view with that filter, does this time will be reduced, since the view...

Thanks Grant 🙂

This is the wait for CPU to complete its transcations, see set Parallelism optin on SP_Config for more detail 🙂

Thanks Giall 🙂

Thanks Gial, Is it a good practice to leave AutoCreateStats on on database, or turn it off

Thanks mate, it worked 🙂

Hi Thanks for the reply, thats my mistake

If( Select Count(*) from NameTable Where Name=@DupName)>1

The above is wrong

If( Select Count(*) from NameTable Where Name=@Name)>1

I got clear from this point, if...

Hi

You can use BCP or just insert into table command, remember that you have to do it table by table basics, or you can use SSIS to...

ops problem with posting, i have mailed to webmaster,

Hi Gail

i have disabled all the triggers that i have made,...