how are you determining it doesn't display right on some servers but not other servers?

the data will have the control characters no matter what in them, but...

I believe he means a single query, getting all the max lens in one query:

SELECt

Max(len(col1)) As m1,

Max(len(col2)) As m2,

Max(len(col3)) As m3

FROM yourTable

i missed the truncating the table part.

there's a lot of script contributions, it looks like, that do exactly that.

some of them are scripts that ASSUME your foreign key is on...

i would consider disabling and re-enabling them instead; either way it's effectively the same thing:

select

'ALTER TABLE '

+ QUOTENAME(schema_name(schema_id))

+ '.'

+ quotename(name)

+ ' NOCHECK CONSTRAINT ALL' as...

from the way it sounds, a trigger sounds like the solution, especially if you need to know WHAT was changed by the stray process/program.

Since the Application Name and the Whostname...

I played with this compression CLR for SQL 2005 more than five years ago.

It worked at the time, but as Gail said, I think doing it in TSQL is...

As Sean has identified, all we can offer is vague advice unless ou have some details we can look at to try and help.

here's a quick list of some things...

nope, a database doesn't keep track of what references Itself, only what objects it's own objects references.

for same server references, you could query each database and stick the results into...

that's one of the advantages/disadvantages of Encrypt by PassPhrase:

you can prevent the DBA from getting to the data if he doesn't have the passphrase. By The Same Token, if you...

you could run into problems with inserting/updating rows with unecessarily oversized rows of data;

SQL still has a max row size of 8060, so if you had an update statement that...

as far as i know, it's not possible; without the pass phrase you'd have to try a dictionary attack on decrypting the values, and see if any if the encrypted...

The Service Broker or Extended Events both...

way too many assumptions and alternate technologies to even begin to offer much more than the basics.

1. you would need a web server, that also has access to where ever...

I believe when you call the procedure, you need to mark the parameter as output also:

exec Testout 'Y', @p2 OUTPUT

my first guess at what you are asking;

you mentioned hundreds of thousands, but your pattern only allows 99999 values.

note i'm still using an identity and a default value in order...