Incorrect Results -- is a hotfix available?

I have a query that is returning incorrect results. It is reproducible on
SQL 2000 SP4 (version 2040) and SP3a (version 760). It tried on 6 different
machines, all with different operating systems/hardware/etc.
Is there a hotfix available?
The following should not return any rows, but 1 row is returned:
declare @.fg table (FK1 int, FK2 int, FK3 int, FK4 int)
insert into @.fg
select 4, 4, 798, 13734
declare @.dg table (ID int, C1 varchar(20))
insert into @.dg
select 4, 'AAA'
declare @.drg table (C1 varchar(20))
insert into @.drg
select 'AAA'
declare @.fgt table (ID int, C1 char(1))
insert into @.fgt
select 4, 'F'
declare @.dwf table (ID int, FK1 int, FK2 int)
insert into @.dwf
select 798, 4, 46
declare @.f table (ID int)
insert into @.f
select 46
declare @.dwc table (ID int)
insert into @.dwc
select 4
select ID = 1
from @.fg fg
inner join @.dg dg on dg.ID = fg.FK1
inner join @.drg drg on drg.C1 = isnull(dg.C1, '')
inner join @.fgt fgt on fgt.ID = fg.FK2
inner join @.dwf dwf on dwf.ID = fg.FK3
inner join @.dwc dwc on dwc.ID = dwf.FK1
inner join @.f f on f.id = dwf.FK2
left join (select ID = 1, FK1 = 1234) ag on ag.ID = fg.FK4
left join (select ID = 1, C1 = '') dt on dt.ID = ag.FK1
inner join (select C1 = 1) c1 on c1.C1 = 1
inner join (select C2 = 1) c2 on c2.C2 = 1
where
isnull(dt.C1, '') = 'XYZ'This produces 0 rows on SQL Server 2005 (build 1399) and on SQL Server 2000
(build 2151 and build 2162).
You might want to see which (if any) specific hotfix references this issue.
See http://www.aspfaq.com/sql2000builds.asp
#2162 was available publicly until Friday or so, it was pulled due to a
couple of pretty serious issues. I noticed at least one of those issues on
#2151 also, which I am currently running, so please only try to obtain the
absolute highest build number you need, especially if you use a failover
cluster and/or rely on BULK INSERT.
Based on a quick scan, looks like the build # you need is 2145, but I did
not read the KB articles in full.
A
"davedave" <davedave@.discussions.microsoft.com> wrote in message
news:54BCCA28-6F9C-484D-976C-F357D2BF7D07@.microsoft.com...
>I have a query that is returning incorrect results. It is reproducible on
> SQL 2000 SP4 (version 2040) and SP3a (version 760). It tried on 6
> different
> machines, all with different operating systems/hardware/etc.
> Is there a hotfix available?
> The following should not return any rows, but 1 row is returned:
> declare @.fg table (FK1 int, FK2 int, FK3 int, FK4 int)
> insert into @.fg
> select 4, 4, 798, 13734
> declare @.dg table (ID int, C1 varchar(20))
> insert into @.dg
> select 4, 'AAA'
> declare @.drg table (C1 varchar(20))
> insert into @.drg
> select 'AAA'
> declare @.fgt table (ID int, C1 char(1))
> insert into @.fgt
> select 4, 'F'
> declare @.dwf table (ID int, FK1 int, FK2 int)
> insert into @.dwf
> select 798, 4, 46
> declare @.f table (ID int)
> insert into @.f
> select 46
> declare @.dwc table (ID int)
> insert into @.dwc
> select 4
> select ID = 1
> from @.fg fg
> inner join @.dg dg on dg.ID = fg.FK1
> inner join @.drg drg on drg.C1 = isnull(dg.C1, '')
> inner join @.fgt fgt on fgt.ID = fg.FK2
> inner join @.dwf dwf on dwf.ID = fg.FK3
> inner join @.dwc dwc on dwc.ID = dwf.FK1
> inner join @.f f on f.id = dwf.FK2
> left join (select ID = 1, FK1 = 1234) ag on ag.ID = fg.FK4
> left join (select ID = 1, C1 = '') dt on dt.ID = ag.FK1
> inner join (select C1 = 1) c1 on c1.C1 = 1
> inner join (select C2 = 1) c2 on c2.C2 = 1
> where
> isnull(dt.C1, '') = 'XYZ'
>

Incorrect Operating system error 112(There is not enough space on the disk.) -

MSsql server gives this error while there is 24 GB physical disk space available.
I think an bug.
I have a disk of 100 GB All the files together are 100 GB big, but an part is windows-nt compressed so the pysical disk space of these files is 77 GB.
I tried to increase the tempdb by hand, but still gives this message.
If I delete files from the disk I can increase the tempdb.Forgot to mention is SQL2000 sp2 on W2K server sp1sql

Including a data table in a graph

Is there an option to include a 'data table' (to show values) as part of the
graph - as is available with Excel?No, this option is not supported by any of the RS rendering extensions
available out of the box (HTML, Excel, PDF, etc.).
There are two options here:
* since the chart data work very similar to a matrix, you can just an
additional matrix to the report. The equivalent for category groupings in
charts is dynamic column groupings in matrix. Series groupings are dynamic
row groupings in matrix. Series values (i.e. static series groupings) in
charts are static row groupings in matrix.
* Technically, the processing engine exposes two types of information
through the RenderingObjectModel: the rendered chart image and the
underlying chart data. Someone could write a rendering extensions which
renders both, the image and the underlying data.
Option 1 (adding the matrix) is much less work and easier to do.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:AD2BD663-7560-4163-8E65-95223E63B1D6@.microsoft.com...
> Is there an option to include a 'data table' (to show values) as part of
the
> graph - as is available with Excel?|||Currently the charting tool is rather limited. There are plans to greatly
expand the graphing functionality -- and the ability to integrate
full-featured third-party graphing components like Dundas -- with the 2005
version.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"PD" <PD@.discussions.microsoft.com> wrote in message
news:AD2BD663-7560-4163-8E65-95223E63B1D6@.microsoft.com...
> Is there an option to include a 'data table' (to show values) as part of
> the
> graph - as is available with Excel?|||By limited, I should have said relative to other full-featured charting
tools out there. The charting tool, is actually fairly good for a 1.0
release.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"PD" <PD@.discussions.microsoft.com> wrote in message
news:AD2BD663-7560-4163-8E65-95223E63B1D6@.microsoft.com...
> Is there an option to include a 'data table' (to show values) as part of
> the
> graph - as is available with Excel?

in what situations principal database might become unavailable ?

Is it correct to say

in any case exept when data or log file not available pricipal db will be availabe

and manual failover could be done only from from principal?

Refer to ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/00a5fbc0-af53-46a7-bfb1-405b9ad2427b.htm BOL topic in this case for your doubts.