Excellent!  Thanks!  now i can set up my DDL to document whats in the database automagically!

how do i get the column description filled in when i create the tables?

transferspreadsheet wants the target xls file to already exist.  haven't used the output to.

why not just script the database you created and then run the script on the new database.  there won't be any history to worry about.

I read an article yesterday that said the 2005 throttle was set to 5 concurrent queries, after that they get queued

Or since you have already gone to the trouble of building the list of items that you can search for in @stritems

where charindex(Convert(varchar(20), item_key) + ',', @stritems) > 0

convert the...

its on the Resources menu at the top of the form

or go straight there http://www.sqlservercentral.com/scripts/

sounds like what you really want is a function to trim off the leading and trailing blanks.  Sql doesn't come with one but you can make your own

create function dbo.MyTrim

   ...

Domain groups are by far the best way to manage your memberships.  The nice thing about it is that when you get a new person, just add them to the...

OOPS! sorry, should have initialized CounterValue to zero!

how bout a nice little function to turn your code into:

INSERT Table1 (Field1, Description, SeqNo, InsMonth) SELECT @Field1, @Description, NextSeqNo = NextSeqNum,

@InsMonth

---------------------------------

create table Counters(

    YearMonth int        -- YYYYMM

    ,CounterValue int

   ...

Thats because I'm an Evil Devloper!  and our beloved database team insists on this structure.  What do you use that allows you to sleep peacefully at night?

I've seen this kind of thing a lot, usually working to convert free form text input fields into the "standard" values.  just make two lists, one for the user input...

You definitely want a scheduled job of some kind to do this.  A trigger would fire every time someone did an insert or update or delete depending on how you...

As a developer and designer I almost never use the CHAR(X) data type except as Char(1), Varchar(X) is much better.  Char(X) will always give you X characters even if you use...