How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisR
See if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:

> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR
|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisRSee if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:

> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:
>

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisRSee if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:
> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:
> > SQL2K sp3.
> >
> > Ive got some DB blocking going on and a couple of times now I see that a
> > spid is blocked by himself. How can this happen?
> >
> > TIA, ChrisR

How block the insertion of NULLS in SQL Server 2000?

Hi,
How block the insertion of NULLS in SQL Server 2000'
I know that in Ms-Access 2000 there is this option in the setting options,
but I could not find in SQL Server 2000.
Thanks,
--
Vilmar Brazão de OliveiraVilmar,
Use NOT NULL, as in
CREATE TABLE validvalue
(
value VARCHAR(20) NOT NULL
)
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vilmar" <xx1122@.x1212x.com.jc> wrote in message
news:OddUs9KKEHA.2024@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How block the insertion of NULLS in SQL Server 2000'
> I know that in Ms-Access 2000 there is this option in the setting options,
> but I could not find in SQL Server 2000.
> Thanks,
> --
>
> Vilmar Brazão de Oliveira
>|||CREATE TABLE <tablename>
(<columnname> <datatype> [NOT] NULL)
So for example, this allows NULLs:
CREATE TABLE A
(B int NULL)
...and this disallows them:
CREATE TABLE A
(B int NOT NULL)
"Vilmar" <xx1122@.x1212x.com.jc> wrote in message
news:OddUs9KKEHA.2024@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How block the insertion of NULLS in SQL Server 2000'
> I know that in Ms-Access 2000 there is this option in the setting options,
> but I could not find in SQL Server 2000.
> Thanks,
> --
>
> Vilmar Brazão de Oliveira
>

How block the insertion of NULLS in SQL Server 2000?

Hi,
How block the insertion of NULLS in SQL Server 2000?
I know that in Ms-Access 2000 there is this option in the setting options,
but I could not find in SQL Server 2000.
Thanks,
Vilmar Brazo de Oliveira
Vilmar,
Use NOT NULL, as in
CREATE TABLE validvalue
(
value VARCHAR(20) NOT NULL
)
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vilmar" <xx1122@.x1212x.com.jc> wrote in message
news:OddUs9KKEHA.2024@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How block the insertion of NULLS in SQL Server 2000?
> I know that in Ms-Access 2000 there is this option in the setting options,
> but I could not find in SQL Server 2000.
> Thanks,
> --
>
> Vilmar Brazo de Oliveira
>
|||CREATE TABLE <tablename>
(<columnname> <datatype> [NOT] NULL)
So for example, this allows NULLs:
CREATE TABLE A
(B int NULL)
...and this disallows them:
CREATE TABLE A
(B int NOT NULL)
"Vilmar" <xx1122@.x1212x.com.jc> wrote in message
news:OddUs9KKEHA.2024@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How block the insertion of NULLS in SQL Server 2000?
> I know that in Ms-Access 2000 there is this option in the setting options,
> but I could not find in SQL Server 2000.
> Thanks,
> --
>
> Vilmar Brazo de Oliveira
>

How block the insertion of NULLS in SQL Server 2000?

Hi,
How block the insertion of NULLS in SQL Server 2000'
I know that in Ms-Access 2000 there is this option in the setting options,
but I could not find in SQL Server 2000.
Thanks,
--
Vilmar Brazo de OliveiraVilmar,
Use NOT NULL, as in
CREATE TABLE validvalue
(
value VARCHAR(20) NOT NULL
)
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vilmar" <xx1122@.x1212x.com.jc> wrote in message
news:OddUs9KKEHA.2024@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How block the insertion of NULLS in SQL Server 2000'
> I know that in Ms-Access 2000 there is this option in the setting options,
> but I could not find in SQL Server 2000.
> Thanks,
> --
>
> Vilmar Brazo de Oliveira
>|||CREATE TABLE <tablename>
(<columnname> <datatype> [NOT] NULL)
So for example, this allows NULLs:
CREATE TABLE A
(B int NULL)
...and this disallows them:
CREATE TABLE A
(B int NOT NULL)
"Vilmar" <xx1122@.x1212x.com.jc> wrote in message
news:OddUs9KKEHA.2024@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How block the insertion of NULLS in SQL Server 2000'
> I know that in Ms-Access 2000 there is this option in the setting options,
> but I could not find in SQL Server 2000.
> Thanks,
> --
>
> Vilmar Brazo de Oliveira
>