Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query Designer error
Message
De
14/12/1999 19:23:59
 
 
À
14/12/1999 17:48:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00303712
Message ID:
00303770
Vues:
13
Here's the script I got for one of the tables having a problem, when I generated scripts:

CREATE TABLE [dbo].[VMCustomer] (
[UserPin] [varchar] (20) NOT NULL ,
[Agent] [varchar] (20) NOT NULL ,
[PagePin] [varchar] (20) NULL ,
[RecordPWD] [varchar] (20) NULL ,
[RetrievePWD] [varchar] (20) NULL ,
[ServiceID] [int] NULL ,
[FlexRValue] [varchar] (5) NULL ,
[CapCode] [varchar] (14) NULL ,
[PagePrefix] [varchar] (8) NULL ,
[PagePostfix] [varchar] (8) NULL ,
[VMailPrefix] [varchar] (8) NULL ,
[NotifyNo] [varchar] (16) NULL ,
[NotifyPin] [varchar] (16) NULL ,
[NotifyType] [smallint] NULL ,
[RemoteID] [varchar] (16) NULL ,
[GreetingNo] [smallint] NULL ,
[Status] [smallint] NULL ,
[CreateTime] [datetime] NULL ,
[DisableTime] [datetime] NULL ,
[ModifyTime] [datetime] NULL ,
[SuspendTime] [datetime] NULL ,
[OverlimitTime] [datetime] NULL ,
[CallCount] [int] NULL ,
[PageCount] [int] NULL ,
[DialCount] [int] NULL ,
[FaxCount] [int] NULL ,
[EmailCount] [int] NULL ,
[VoicemailCount] [int] NULL ,
[ReservedCount1] [int] NULL ,
[ReservedCount2] [int] NULL ,
[ReservedCount3] [int] NULL
) ON [PRIMARY]
GO


ALTER TABLE [dbo].[VMCustomer] WITH NOCHECK ADD
CONSTRAINT [PK_VMCustomer] PRIMARY KEY NONCLUSTERED
(
[UserPin]
) ON [PRIMARY]
GO

Thanks,

PF

>Do the tables have declared PKs
>
>-Mike

(On an infant's shirt): Already smarter than Bush
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform