you have to group by the case statment in this situation..it's wordy, but that's how it works...only in the ORDER BY clause can you reference by alias, so it's like...

glad I could help.

I was wondering if your stored procedure will save your notes correctly  if no notes exist yet...it wasn't obvious to me whether the notes get saved based...

I'm assuming that on this document, it looks something like this based on your original post.

You would want to add something similar in blue; note how i removed the...

I don't think the issue is with Conn.Execute where it is calling that stored proc.

 I think you have a statement after Conn.execute that is referencing a recordset (notes maybe?) that...

here's one of many ideas you'll get:

since you have the SQL, put it in query analyzer and get the estimated execution plan.(control K in QA)

look at the plan and see...

usually select @@SERVERNAME wil return what you are looking for. if it were a n instance, like MYSERVER\SQL2005, it would be the part before the slash.

the status column is used a s a bitfield mask to query whether an index is clustered,unique, etc.

the status of zero is going to mean false for all indexproperties; it...

ok i see the difference.... I was concentrating on max field size, , so my version would simply find the largest used column size a for the MaxActualLength.each max size...

of course someone already had done this, so I didn't follow the rabbit down the hole to reinvent the wheel;

here's a link:

http://sqljunkies.com/WebLog/amachanic/archive/2005/01/25/6897.aspx

the script does...just look for anything with an DefinedSize greater than 8060:

create table BadExample(

varint int,

var1 varchar(8000),

var2 varchar(8000),

var3 varchar(8000),

var4 varchar(8000))

insert into BadExample(varint,var1,var2,var3,var4) values (1,'sometext','more text than before','etc,etc',null)

you get this on creation and insert:

Warning: The...

I'm going to start a [Bankers Rounding] is the [Best Practice] thread now.

Nice Jeff; your version does a much better job of analysis and presenting a basisi for improvements to someone's schema, i like it.

Thanks Jeff; I'm sure you are right...I should initialize the MaxActualLength with the values from syscolumns, and then update...makes the comparison much better.

You contribute a lot to SSC; thanks!

I also...

ok how about this:

it gives results that look something like this:

there is also an underlying table ##tmp, where you can see which columsn are defined but never used

Sugesh getting a program to call them all is pretty easy...the problem is usually dependancy issues....you know, script 42 has to be run after some other specific scripts, something in...