Jeff,

Thanx for the reply, The total physical ram is 4.5 gb. it was a typo error.

Murali.a

You can include the service manually by an exe instrsrv.exe, you can get it from the search. Since you say that you find the exe's available on the folder, and...

These are self-blockings and will release on its own quite after some time. I'm not sure if this still happen in sql2k5 but these are behaviour of SP4 on SQL 2000.

Murali.a

yes, try doing the SP again on the server got the same error and fixed out retrying the same

Try checking if there are any long running queries that are having any blocks or deadlocks  else you can try issuing a manual chekpoint to clear the committed transacitons from...

again, I'm too nervous in doing a shrink on a system db (msdb).

Yes, I'm aware abt it. Once i delete the rows i checked used

dbcc updateusage but no scope, Checked by running optimization but still no hopes....

Transferring DTS packages can be done from the source server from sysdtspackages table taking only the max of createdate column which will avoid the older version of the packages and transfering...

No I do not have any deletion on the plan. The feature of sub plan is that

when you create the maint. plan on the earlier version you need to execute...

You could also use ERWIN data modeller from CA.

You can chk out features from all those and choose it.

yes,  When given as 10 the pages are filled with 10% and more the pages get created for that db. Obviously the space gets increased when there is more pages.

Thats a valid note.

Wat's the edition of SQL server. If it is Standard Edition it cannot go beyond 2GB.  Where as on Enterprise edition can take more than 2 gb of ram if...

Just check out what's the distribution expiry period the default is 72 hrs as said before you can try out increasing the hrs.

 If you are not sure when the replication happens...

folks, Wish you all a happy and a memorable independance day. It's nice

to see the history about  US.

Murali.a