XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Pim TaaiSubject: 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]


Unknown201102211208html_img1.JPEG
Picture

Postnext
Ivan PedruzziSubject: BUG: Read structure on SQL Server 2000 not always gives a result for no apparent reason.
Author: Ivan Pedruzzi
Date: 25 Feb 2011 01:22 AM
Hi Pim,

This is a known limitation, T="Read Structure" works only if the table contains data.

Hope this helps
Ivan

Posttop
Pim TaaiSubject: BUG: Read structure on SQL Server 2000 not always gives a result for no apparent reason.
Author: Pim Taai
Date: 25 Feb 2011 09:13 AM
Thanx for the help.

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.