You know, of course, as soon as they let you change to a bit field, that would be when they would want to add the value "2" to the system....

Last company I worked for kept saying the same thing about the propriatary system that supported the business from the time I started to the time I left in 2005....

Just me, but the only "small" data type I wouldn't use is smalldatetime. Why introduce a "Y2K" type issue by limiting your dates to January 1, 1900, through June...

Although I'd like to go to SQL Server 2008 when it comes out, and I may push for it in our DW project, but for our LOB apps, we've upgraded...

Would you please post the DDL for the both the source and destination tables?

😎

It may be the way your update is written. Could you post the code you are running for us to look at?

😎

Couldn't help there, hopefully some one else is more knowledgeable there. We still have have SQL Server 2000 database servers here and the developers still use EM to build...

DTS or SSIS? If i remember, in DTS you can set your batch size, but not sure if you can edit an imported (upgraded) DTS package in SSIS.

In the...

How are you importing the data, BCP, BULK INSERT?

What value are you trying to set to NULL?

SSC is one of the best SQL Server resources on the web. I have been a member for several years, and it has helped me on several occasions. ...

Personally, store a date as a date (datetime). If you store '8/29/1959' in a datetime field , it looks like 1959-08-29 00:00:00.000, and you can query the date in...

Verify that the date in @startDate is actually the date you passed. If you do this: select datediff(month, 0, getdate()) you get a return value of 1292, the number...

My first suggestion, take some time to read BOL (Books On-Line), specifically schemas. This will give you a good place to ask additional questions.

😎

Actually, this is stated in BOL.