I hate SQL Server

[Ennis Ray Lynch Jr]

Decided I had the wrong foreign key in a table. Changed the name, changed they type clicked save presumed it would drop the FK; nope. Changed every table in the database and every foreign key to the new type and dropped all indexes on views (because of course removing schema binding removes indexes). (Yes I did get a warning, however I was changing the type from bigint to int so I expected the warning and just clicked through. It wasn't until I read the fine print that I saw Microsoft's solution to the problem)

Need custom software developed? I do C# development and consulting all over the United States. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane

[Henry Minute]

They do have novel approaches to some aspects of the design process, don't they? This is of course because their own stuff is perfect right off, so they never have to do this sort of thing. :)

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Ennis Ray Lynch Jr]

I did manage to hit cancel but it seems schema changes don't rollback :p

Need custom software developed? I do C# development and consulting all over the United States. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane

[Marc Clifton]

Henry Minute wrote:

They do have novel approaches to some aspects of the design process, don't they? This is of course because their own stuff is perfect right off, so they never have to do this sort of thing.

Nah, it's because they don't use their own stuff to develop their stuff. :) Marc

Will work for food. Interacx

[ToddHileHoffer]

Ennis Ray Lynch, Jr. wrote: Changed the name, changed they type clicked save presumed it would drop the FK; nope. You meant to say you "assumed" it would drop the FK. Well, you do you know what assume means?

I didn't get any requirements for the signature

[Ennis Ray Lynch Jr]

With MS documentation as it stands one must assume or quit because you most certainly can't look it up.

Need custom software developed? I do C# development and consulting all over the United States. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane

[codemunch]

Everything is still fine though kuz you did this on the Dev database and you still have the SQL Scripts to generate the DB so you can just revert...right? ;) I'm curious - Was it SQL Server itself that did this or part of SQL Enterprise Mangler's script generation?

[ToddHileHoffer]

Tell me about it. I keep telling my boss that sharepoint programming is almost impossible   X| Mainly because there is no good documentation anywhere.

I didn't get any requirements for the signature