I am getting the following error message. I just implemented the code that was posted exactly as it was posted. It was ran locally. I should be...

I am setting stuck on step 6 and 7. Can someone help me. Basically, I did what it said, I double clicked on the data flow tab for data...

Thank you! Worked perfectly.:-)

The customer has changed his mind. He wants all existing rows in the table populated with the default value once the column gets added. So I was doing...

this should actually be an add column datetime with a defaulte setting of getdate().

Also, how do I specify no check constraint?