Hi Ashish,

I got this problem because I did the following task on my new subscription machine:

1) Install fresh windows with machine name on subscription i.e. A

2) install SQL Server on...

Thanks dear,

Unfortunately I'm running out of memory on server that's why the server is pulling the tables in its cache but this command is certainly helpful in other case was...

Thanks my problem is solve by:

EXEC sp_dropserver 'LHDC2K02'

EXEC sp_addserver 'LMDC2K02','local'

Regards,

Govind

Great tips, I will check the DBCC command for confirmation, have never used this command for memory related issues. Will update you soon

Thanks you very much for replying

Govind

Many thanks for quick reply, but I want to resolve this case as my clients are complaining about this.

Regards,

Govind

Many thanks for replies,

The 2nd time response for all raw queries + SPs are very fast for about 10-15 minutes. For stored procedures I can understand that SQL caches the...

Additionally is Sql 2005 CLR integration can be a good solution for this problem w.r.t performance ?

Thanks loner.

Its a FIFO based costing routine. Source of cost have multiple paths, i.e. Exact item received / purchased, Std cost, Conversion of items (cost carrying & Issuing item differ...

Thanks PW, exactly that was problem in my case for this same problem. A job was scheduled

Please don't be confused by different values I have used in my examples

Hi All,

sorry for late reply, I will try to reproduce the same error again and I will post the agent's output text. Jeff, I am not using XML in queries...

HI,

I am facing the same problem too, any help please

Oh sorry, big mistake it is SQL 2000 Personal edition., what the fool I am. So now I have to reinstall. Thank you very much. One more thing, can I solve the...

Hi Steve,

I have SQL 2000 standard edition with SP3, basically its a publisher + distributor covering 3 subscribers and approx 60 clients. There is no hardware problem (its 3 Ghz...

TRUNCATE works on empty table: this is also helpful. Thanks for this trick too.

Regards, GB