Seems to be either your tempdb got full or your temp folder in your disk (c:\temp) is full. Please check it out.

Thanks,

Balaji L

Update statistics which is used to update the indexes. It will improve the perfomance of the query. If your application is like OLTP db then daily lot of rows can...

Schedule the update statistics job on non peak hours. So it wont cause any problems during multiple jobs / batch files running at a time.

Thanks,

Balaji L

SELECT bucket_id_ml = min(T.exception_category_id)

, msg_id = X.msg_id

INTO #ework2

FROM #Excp_Key REGN

JOIN #ework X

ON REGN.msg_id = X.msg_id

JOIN #Excp_Key CAMV

ON CAMV.msg_id = X.msg_id

LEFT JOIN #Excp_Key COMP

ON COMP.msg_id = X.msg_id

LEFT JOIN #Excp_Key MKT

ON...

Hi ,

Can someone please help me how to take 20% of backup from my OLTP db. Is there anyway to take only 20% backup in sql server 2000/2005?

Thanks,

Balaji L

To speed up the commands from publisher to subscriber,

1) You can drop the indexes if exists. This will give better performance.

2) You can increase log reader agents batch size and...

Can you send me the code? where are you getting the error?

Define ur new objects(table,sp,view..) using sp_addarticle then define ur subscriber using sp_addsubscription. Run it in publisher side.

Then start your snapshot agent. Now your new article will be availble in your...

To activate the replication, Drop and recreate the subscription (without dropping articles). If you are doing drop and recreate article, taking long time to populate the records if it is...