I got the 43 - 57 stuff, and expected some white space, but what's with 11 & 12??? Do they go with the monetary data types because some people...

OK, here's the fix for ÿ:

OR @vParameter COLLATE Latin1_General_BIN LIKE '%[{-ÿ]%'

Oops, ÿ doesn't work

Dennis,

I like your pattern matching approach. However, I was concerned about the 128 extended characters, so I suggest the last condition be modified to changed the ~ to a...

Two points:

One: The initial question was to keep ISV customers from mucking up the database and then blaming the ISV for the problems. In this case we are not...

This batch will tell you where backups will go by default. It works on SQL 2000 and SQL 2008 for me:

[font="Courier New"]declare @data nvarchar(512);

exec master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer',

...

I wanted to come up with a solution of my own with reading just the statement of the challenge. So, here it is. I took me about 10-15...