| t2581@hotmail.com 2006-02-10, 11:23 am |
| Hi ,
Few questions about SP4
1.
I have table
CREATE TABLE [REQUEST_QUERY] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Query] [varchar] (8000) COLLATE SQL_Latin1_General_C
P1_CI_AI NULL ,
[Type] [varchar] (19) COLLATE SQL_Latin1_General_C
P1_CI_AI NULL ,
CONSTRAINT & #91;PK_REQUEST_QUERY
] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
table contain 8 rows
data in row 4 column Query 3914 characters -- len(Query) = 3914
viewing data in table REQUEST_QUERY in QA , I can see all the text in
row 4 column Query
viewing data in table REQUEST_QUERY in EM ,(open table) shows blank
in row 4 column Query
This test done on 5 workstations (SQL 2000 dev edition SP4)
trying to open same table in EM from 4 workstations (SQL 2000 dev
edition SP3)
I can see all the text in row 4 column Query !!!
Is it a bug of SP4 or some setting could be changes in EM in order to
see long data in column ?
2.
found on Microsoft web site
Hotfixes are not included in Service Pack 4
Hotfixes 836651 and 826906 were not included in SP4. Customers who
apply SP4 in addition to this hotfix will have the hotfix overwritten.
A post-SP4 hotfix for these issues will be available shortly.
For more information, click the following article numbers to view the
articles in the Microsoft Knowledge Base:
836651 (http://support.microsoft.com/kb/836651/) FIX: You receive query
results that were not expected when you use both ANSI joins and
non-ANSI joins
826906 (http://support.microsoft.com/kb/826906/) FIX: A query that uses
a view that contains a correlated subquery and an aggregate runs slowly
Should instalation of those hot fixes be mandatory after instalation
of SP4 ?
Thanks
Alex
SQL2000 SP4 enterprise manager.
DB Alex table customer
would show blank space in oepn
|