In the below graphic you will see that the TS_KY_TOT is a Datetime2(7), where
the ‘(7)’ is the variant for precision. However the Object explorer
should be displaying this level of detail.]
This should be considered a lower level bug or new feature request, for most
programmers know what they are doing here, HOPEFULLY. It just would be nice to
have Object Explorer show the correct details.
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype
This is a Toad SQL Server 5.5 release issue.
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype
This is a Toad SQL Server 5.5 release issue.
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype
This is a Toad SQL Server 5.5 release issue.
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype
Hi Hank,
I’ve created CR88635 for this. Thanks for the info.
regards,
Alexander Maximov
Hi Hank,
I’ve created CR88635 for this. Thanks for the info.
regards,
Alexander Maximov
Hi Hank,
I’ve created CR88635 for this. Thanks for the info.
regards,
Alexander Maximov
Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.
CREATE TABLE [dbo].[PREM_COND] (
[KY_PREM_NO] int NULL ,
[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TS_KY] datetime2( 7 ) NULL ,
[CD_STAT] numeric( 2 , 0 ) NULL ,
[DT_STAT] datetime2( 7 ) NULL ,
[QY_BTU] numeric( 9 , 0 ) NULL ,
[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )
ON [PRIMARY]
WITH (DATA_COMPRESSION = PAGE) ;
GO
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype
Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.
CREATE TABLE [dbo].[PREM_COND] (
[KY_PREM_NO] int NULL ,
[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TS_KY] datetime2( 7 ) NULL ,
[CD_STAT] numeric( 2 , 0 ) NULL ,
[DT_STAT] datetime2( 7 ) NULL ,
[QY_BTU] numeric( 9 , 0 ) NULL ,
[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )
ON [PRIMARY]
WITH (DATA_COMPRESSION = PAGE) ;
GO
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype
Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.
CREATE TABLE [dbo].[PREM_COND] (
[KY_PREM_NO] int NULL ,
[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TS_KY] datetime2( 7 ) NULL ,
[CD_STAT] numeric( 2 , 0 ) NULL ,
[DT_STAT] datetime2( 7 ) NULL ,
[QY_BTU] numeric( 9 , 0 ) NULL ,
[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )
ON [PRIMARY]
WITH (DATA_COMPRESSION = PAGE) ;
GO
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype
Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.
CREATE TABLE [dbo].[PREM_COND] (
[KY_PREM_NO] int NULL ,
[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TS_KY] datetime2( 7 ) NULL ,
[CD_STAT] numeric( 2 , 0 ) NULL ,
[DT_STAT] datetime2( 7 ) NULL ,
[QY_BTU] numeric( 9 , 0 ) NULL ,
[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )
ON [PRIMARY]
WITH (DATA_COMPRESSION = PAGE) ;
GO
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
hfreeman@msn.com
678-414-0090 my cell Primary
hank.freeman50 via Skype