This typically occurs when you have a string that overflows the storage size.

Can you post some code?

Ha, we got two new horses this weekend. We have plenty to shovel. I'm sure Alice will be happy to command delegate some chores to you.

Why do you care?

NULL is null, whether the user passes it or not.

Nice advice. That and check the cable/power cord first will help.

Great to hear, and glad it worked.

Partitioned views can work. There is work done in the optimizer so that only the partitions needed are accessed. The keys to making this work, as always, are good I/O...

Did you click the "Manage Connections" in the maint plan editor? There's a "remove" button. (see attached)

Are you perhaps doing a restore of the database?

wenrui_yang (9/9/2010)

---

I still remember an article I read in a class: One man's meat is another man's poison. It also applies to job. In many cases, the same...

Jack has to behave. He's bringing his wife to the dkRanch in a few weeks and...

Kevin's book: SQL in a Nutshell (recommended).

It does sound like a varchar and a complex constraint from a DDL perspective. A nightmare from a DML perspective.

Click the forum title at the top (Administering), then click "New Topic"

Just got this from a friend: http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html

He says SET is generally considered a bad idea. It only allow SET datatypes to be stored. Not sure what this would be in...

Please start a new thread with your message and include the results of FILELISTONLY.

From what I see in the MYSQL reference.

ALTER TABLE X CHANGE col1 col2

Does a name change of the column. So col1 is renamed col2.

http://php.about.com/od/learnmysql/p/alter_table.htm

The SET is something I don't see...