April 7, 2009 at 5:54 pm
Hi Guys,
I'm recieving this error message on all my sql2000 machines
Cannot create a row of size 8207 which is greater than the allowable maximum of 8060. (Source: MSSQLServer, Error number: 511)
Which is fair enough but how can i find out with column its having issues with ?? I've looked into MSrepl_errors but that just repeats the error message.
Cheers
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
April 7, 2009 at 7:29 pm
did you try sp_browsereplcmds ..............it should give you an idea where the error is..??
April 14, 2009 at 11:56 am
Replication Monitor will indicate xact_number ... use it with sp_browsereplcmds.
* Noel
April 15, 2009 at 7:51 pm
Cheers Noel, i've managed to find out what was the problem but this would had make it a whole lots quicker 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
April 17, 2009 at 8:06 am
HTH
* Noel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply