Thanks for your efforts. I appreciate how generous you have been with your time; and for free, no less.

Allow me to clarify what I am looking for.

Setting or resetting the ANSI_PADDING value of the connection is simple enough, as you have pointed out.

For replication, it is necessary for...

Thanks for the reply.

I assumed that the sys.tables.uses_ansi_nulls represented the SET ANSI_NULLS setting. BOL seems to indicate that it is. I just can't find any place where the...

Useful information; thank-you.

What I am trying to determine, after running into various ANSI_PADDING errors in replication, is which tables currently have the ANSI_PADDING set on. I'd like to be...

"Plagiarism" "Rip-off"

I couldn't disagree more. The point of having a support network, such as this site, is to be able to leverage the existing knowledge and scripts and, in...

Thank-you, Gail. you were exactly right that this was a restore of another server's database. I ran the publish/remove publish and all is well again. Not bad...

Some meaningful variable names would go a long way toward making this readable.

Does the script account for the possibility that the column name might cross a syscomments boundary (e.g., Part of the column name is at the end of syscomments.Row1 while the...