What version is MSDE? Can you connect to it with QA? If so, do this: select @@VERSION and report the results.

Here is a starting point: BOL (Books On-Line).

Lookup the following:

sys.databases

sys.tables

sys.columns

sys.types

Missing the data types for org.known_as and ca.attribute3.

You can do this by one of two ways, backup/restore or detach/attach.

If you check the code I posted, you'll see that I created a table, inserted some records, then added a column, and inserted additional records. I used the exact...

Elisabeth Rédei (11/3/2008)

If you want a default value; use a Default getdate(), it you want to enforce a NOT NULL constraint; add a CHECK constraint. Or both.

You can add the...

I think we need more information regarding the process involved and what the job is supposed to do, and how it does it. As you have a trigger starting...

To answer this question, you should compare the execution plans of the two two queries. You might be surprised to see that both are doing a clustered index or...

How true....

I can't answer your question, but I did a test (code follows), and when I added the DateAdded column with a default, it was populated.

create table #Test(

...

I've been lurking on this topic, and I'd be interested in what the final outcome is also.

Not really. I need to know what are the data types of the columns referenced from each of the tables used in the query.

Please take a few minutes to...

Do a search on this site for Tally table. I think this will help you solve your problem.

Have to agree with steveb, use a default of getdate() fro the column.

Well, having the entire query is good, but we still need to know the data types of the columns since the problem you are having is a conversion problem.