I believe you were using one way transaction replication...

Without snapshot you can handle this situation by add the -SkipErrors swith in your distribution job...and later you run the snapshot if...

I was thinking it can be used in conjuction with UPDATETEXT or WRITETEXT functions... but it all depends on requirement...

Can you post a sample code...

Check what are the procedure/statements executed by the error page.

Run the sql trace to see the procs are executed or not..

Include error and warning in sql trace to find sql...

What about using table variable with text column....

As mentioned it can be done both ways...

When you use import export wizard you have specify the destination server name not file name...

I think you have given the file name...

I believe you need to type the path...

ex: \\servername\c$\foldername\

Here is what I am using...

select    

 @@servername   

, SUBSTRING(vchMessage,34,8000)   

, SUBSTRING(vchMessage,1,22)   

from #Errors   

where isdate(substring(vchMessage,1,10)) = 1   

and   

(vchMessage  like "%backupmedium%"    or   

vchMessage  like "%failed%"    or   

vchMessage  like "%failure%"    or    ...

I don't think there is way to read event log data from sql but you can use DumpEvt free utility to convert event log into sql import format...

SomarSoft's...

Create a procedure on each server to get the backup info and execute them daily once and copy the output to a central location table and read the results from...

Write a small activex script to create a file on sql server c drive...then schedule it as a job to run as activex command in sql job steps... see what...

http://www.sqldts.com/default.aspx?234

http://www.sqldts.com/default.aspx?205

Take a look..

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=328008

What is the error you are getting you it crashes?

Is there any computed column in the table?

What is the size of the table?

What is the value before reindex, after reindex and after one hour...?

Try to check the fragmentation wiht DBCC SHOWCONTIG command...to see is there any difference...

It is working on windows2000, xp also...

Check your batch terminator...