First off, I think the article was well intended. However, being a seasoned vet with SQL and SQL performance, I think that your article was more of an intermediate...

Latin1_General_Binary isn't commonly used. However, Cisco ICM uses it...so it's what we use with our databases. Essentially, it forces Capitalization. So...

DECLARE @Variable

would not equal

DECLARE @variable.

It's really...

Below is the Latin1_Gen_Binary comatible SQL.

CREATE PROCEDURE [dbo].[sp_ObjectExplore]

@FullObjectName varchar(200)

,@distribution varchar(3) = 'No'

,@Columns varchar(max) = NULL

AS

-- ______________________________________________________ Object Explore _________________________________________________________

--

-- August 19th 2010, by Robin van Schaik

-- Version...

Disappointed that the example is not Binary compatible. Ended up having to clean up the example just to run it and then find that all of the Dynamic SQL...

I would have one suggestion in your article, you shoudl close and deallocate the cursor. People who use these types of articles to learn new things can learn really...

Actually, I appologize. It was only 3 places with SYSNAME vs sysname.

Really Cool...

Love the article. However it's going to talk a lot of work to make it Binary compatible. Unfortunately due to the nature of the beast we run all...