I have DTS which includes a step to create table:
CREATE TABLE [contracts] (
[ContractId] [varchar] (10) NOT NULL ,
[ClientId] [varchar] (10) NOT NULL ,
[contract_nm] [varchar] (50) NULL ,
[CreditLimit] [money] NOT NULL ,
[prod_cd] [varchar] (2) NOT NULL ,
[DateOpened] [datetime] NOT NULL ,
[interestfree_period] [int] NOT NULL ,
[DateFirstPayment] [datetime] NULL ,
However, if I examine the table using sp_help after it is created the ContractId field has collation specified against it.
[ContractId] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
Why is collation specified against the ContractId field when I have not specified it in the create statement in the DTS?
Thanks in advanceA SQL Server DBA Wannabe
View Complete Post