How can I compact MS SQL 2000 Database?

Now my database is contain a big size and still grow up. I think may I can compact it to small size like ms-access.
How can I compact MS SQL 2000 Database?You can shrink the databse by any of the following option.

1.You can use the syntax dbcc shrinkdb <databasename> on query analyzer

or

2.selse sqlserver -> enterprise manager ->select the database -> right clik this and select the option shink

for more information u can use books online shrink database option|||To prevent the database from unwanted growth, you can set the 'Auto shrink' option (in Enterprise Manager, right click on your database, choose properties, select options tag and check the auto shrink option).

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
>