I recently Upgraded to 2008 Enterprise and took the opportunity to change the biggest table in my db with the maintenance window.
ran the following to change my ntext field
ALTER TABLE acomEstabLocale_tbl ALTER COLUMN [description] nvarchar(MAX) GO update acomEstabLocale_tbl set [description] = [description]
when I ran the second statement i got the following
length of LOB data (77404) to be replicated exceeds the exceeds configured maximum
ok, so after a poke around I found the sp_configure and ran :-
EXEC sp_configure ‘max text repl size’, 100000
but now I receiving the following
nvarchar max Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I'm looking to temporarily extend this query timeout period, can the just be done using the remote query timeout setting on the server properties ? or is there a T-SQL statement for just this query