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

The simplest way is to open the table for Design in Enterprise Manager and just...

I copied this script from this forum awhile back. It may be what you're looking for.

Run the first part in Query Analyzer to create a procedure.  Then execute the procedure...

Yuri,

If you are not particular about the location of the column within the table, you can accomplish this with two lines of code:

ALTER TABLE tablename DROP COLUMN column_name

ALTER TABLE tablename ADD column_name INT...

Sam,

Bill has a nice design but I noticed in your earlier post you require the code value to be unique due to referential integrity requirements.

To meet this need, you will...

I came late to the posting but I would like to emphasize Jeff's point about poorly constructed queries bringing your database to its knees.

By their nature, inexperienced users with little...

I don't want to confuse the issue but I come from an accounting background and I very seldom saw the payments on invoices match to the penny unless they were...

Turuvekere,

You can use a triggger to update the table on which the fired trigger is attached to.

You need to be very careful in doing this.  It causes a recursive situation...

My first (hopefully not best) thought would be to use regular expressions, PATINDEX, and/or CHARINDEX to search the string for characters or combinations of characters unique to the language.  For...

It's Pat!!!

--Sorry, as a Saturday Night Live fan I couldn't resist.

Good luck with the project.  Personally I am amazed there are commercial tools available for this 'tilting at windmills'...

You have probably already considered this, but most of the times I have received the 3202 error in this context, the destination disk was full.  A couple of times it...

One more for the scare column.

Shortly after starting my current position I invited the entire web development team (including managers) to a meeting in the training lab.  I had a...

Paing I reread your last post, noticing the 'large table' comment.  If you have a large table and performance is an issue, you probably need a numeric (identity) column for...

Paing,

If I understand your question, the following discussion is just what you need.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=132028

Kenneth,

wangkhar is correct in the response to your post. Your question "doesn't Unrecovered mean failure" is common.  This is one of those areas where the selection of terms can be...