Here is a link to the article and how to change it.

http://msdn.microsoft.com/en-us/library/ms186321.aspx

Since you state DTS I assume you are doing this on SQL 2000?

Every element in a server instance can have a different collation. We have one table olne that has 7 different collations.

I would think you just need to break you date down into date parts and use that in you grouping.

So lets say you have a record set with the type...

We have had the same issue here. From the searching I did this seems like a major flaw in backwards compatibility. I will be very interested to see...

There ae files although this process was not written with a great deal of common sense.

I would love to be able to read the file and in fact my...

Thanks to everyone for the replies. It helps alot to know what others are doing.

The sad part is that is the best explanation I could find ont he subject.

HEre is a blog post that atleast might get you part of the answer

http://sqlblog.com/blogs/kalen_delaney/archive/2006/09/06/186.aspx

It might look something like this.

Assuming you have some sort of key field. we will call it pkey

I would select this into a temp table

select

involved,

case

...

sorry posted on wrong thread

It looks like you forgot the "_" in the field name in your trigger.

Here is a link to another forum where they apear to have atleast a similiar issue. Hope this is helpful.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/6543310d-1b44-4b28-8bb6-caf959c1249b

I would look at the linked server object in management studio. that will allow you to look at all the information in one window and might give you an...

Is this a pre 2005 instance?