|
|
 next
|
  Subject: BUG: Read structure on SQL Server 2000 not always gives a result for no apparent reason.
Author: Pim Taai
Date: 22 Feb 2011 03:31 AM
|
Dear,
Read structure on SQL Server 2000 not always gives a result for no apparent reason.
I'v connected to my SQL 2000 database server, selected the appropriate database, found my table. Right click, "read structure" -> I get an empty set.
If I choose a different table, I gives a result.
Always the same table give the same result!
Attached is a screen picture to show 2 tables. Also the create table SQL statements are enclosed below.
create table ReplenishmentRequest
(
ReplenishmentRequestId int identity(1,1),
Sender varchar(100) not null,
Identifier varchar(100) not null,
Type varchar(100),
CreationDate datetime,
verwerkt udt_logical,
DBUserName varchar(32),
Dlc datetime,
constraint PKReplenishmentRequestId primary key(ReplenishmentRequestId)
);
CREATE TABLE [SystemLevel] (
[SystemLevelId] [int] NOT NULL ,
[ModuleName] [varchar] (64) COLLATE Latin1_General_CI_AS NOT NULL ,
[VersionNr] [int] NOT NULL ,
[Description] [varchar] (128) COLLATE Latin1_General_CI_AS NOT NULL ,
[Statements] [ntext] COLLATE Latin1_General_CI_AS NULL ,
[UserName] [varchar] (128) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_SystemLevel_UserName] DEFAULT (user_name()),
[CreationDate] [datetime] NOT NULL CONSTRAINT [DF_SystemLevel_CreationDate] DEFAULT (getdate()),
CONSTRAINT [PK_SystemLevel] PRIMARY KEY CLUSTERED
(
[SystemLevelId]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 201102211208html_img1.JPEG
Picture
|
|
|
|
top