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...

I would invite you to ask your backup person to restore your database to a point in time on another server using the latest "log" backup. That will let you...

I have corrected the question to say that it is for SQL Server 2008 R2 (using the latest reference), noted that it can be moved in 2005, and then awarded...