Does SQL Server 7 has anything to do with JVM?

I hava a MSDN Universal subscription. I was told the reason I can't get a copy of SQL Server 7 from Microsoft is because the "Java settlement". Does anyone know why?
According to: http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodS, SQLServer7 is supported until Dec 31, 2005. I do not understand why Microsoft is still supporting it but us developers can not get a copy!
Hi,
The http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodS states
that SQL 7 will be supported till Dec 2005, but the availibility of SQL 7
was only till March 99.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||My understanding March 1, 1999 is the General Availibility (GA) date, or the first shipping date, not the last day it will be shipped.
|||Hi,
I am sorry, it was my mistake.
Your understanding is correct.
The Softwares like (SQL 7) is still supported to benefit the existing users
of it.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

does showContig Block ?

does DBCC ShowContig Block ?
I want to run this in prod but cant find any documentation that indicates if
this blocks or not
thanks in advance
GAJHi,
Use WITH FAST option along to avoid blocking.
Note:
A fast scan does not read the leaf or data level pages of the index, so will
not create blocks.
Usage:
USE dbname
GO
DBCC SHOWCONTIG ('table_name') with fast
GO
Thanks
Hari
MCDBA
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:e#rtZkUDEHA.2052@.TK2MSFTNGP11.phx.gbl...
> does DBCC ShowContig Block ?
> I want to run this in prod but cant find any documentation that indicates
if
> this blocks or not
>
> thanks in advance
>
> GAJ
>|||If you run it on a heap, WITH FAST has no effect and it will still take a
table S lock. WITH FAST allows it to take a table IS lock when run on
clustered and non-clustered indexes.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uld4HaWDEHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Use WITH FAST option along to avoid blocking.
> Note:
> A fast scan does not read the leaf or data level pages of the index, so
will
> not create blocks.
> Usage:
> USE dbname
> GO
> DBCC SHOWCONTIG ('table_name') with fast
> GO
> Thanks
> Hari
> MCDBA
>
> "Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
> news:e#rtZkUDEHA.2052@.TK2MSFTNGP11.phx.gbl...
indicates
> if
>|||crud.
about 80% of our tables are HEAPS (long Story) so running this in prod puts
us on our lips...
Correct ?
Greg J|||Assuming that 'puts us on our lips' is bad, then yes, you don't want to do
it. What are you trying to acheive - there may be another way to do it...
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:OdsxqBdDEHA.2308@.tk2msftngp13.phx.gbl...
> crud.
> about 80% of our tables are HEAPS (long Story) so running this in prod
puts
> us on our lips...
>
> Correct ?
>
> Greg J
>

Does MSDE run ok on Windows XP Home, Media Edition?

We can't seem to get TCP/IP working...
Hi Jon,
Have you enabled tcp/ip using svrnetcn.exe?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:%23QouccA6EHA.3708@.TK2MSFTNGP14.phx.gbl...
> We can't seem to get TCP/IP working...
|||Yep, and Named Pipes. It's listening on the default port of 1433, but
when SQL starts, in the log, it doesn't say it's listening on TCP. There
are no warnings/errors either.
The PC does have a firewall on it, would that make any difference?
Greg Low [MVP] wrote:

> Hi Jon,
> Have you enabled tcp/ip using svrnetcn.exe?
> HTH,
>
|||Hi Jon,
Yep, sure would. Have you put an exception for port 1433 (assuming you're
using the default port) ?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:e24tD0M6EHA.3376@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Yep, and Named Pipes. It's listening on the default port of 1433, but when
> SQL starts, in the log, it doesn't say it's listening on TCP. There are no
> warnings/errors either.
> The PC does have a firewall on it, would that make any difference?
> Greg Low [MVP] wrote: