help on SQL syntax ?

Dear all,
I am not so familar with SQL syntax.
Is there a good link where keywords and syntax are clearly explain ?
I am running SQL server 2000 Sp4 on server 2003.
regards
sergeHi serge,
read the "BOL"
http://www.aspfaq.com/show.asp?id=2229
HTH, Jens Suessmeyer,|||Hi
Books online is a good source for a lot of information and should be the
first thing to look at. If it is not in your SQL Server program group then
you can download it from
http://www.microsoft.com/downloads/...&displaylang=en
John
"serge calderara" wrote:

> Dear all,
> I am not so familar with SQL syntax.
> Is there a good link where keywords and syntax are clearly explain ?
> I am running SQL server 2000 Sp4 on server 2003.
> regards
> serge|||If BOL is not your thing you might try this free book:
http://www.managedtime.com/freesqlbook.php3
Msql

Help on sql 7.0 sp4 tempdb is full

My C: drive was getting low on disk space so I:
Changed the allotted space for tempdb to not grow any larger.
Reduced the memory space from 815 meg to 637 meg in sql server properties.
Rebooted the NT 4 server.
Now I am getting this error every minute. Also, in Enterprise Manager ,
database, shows: "no items".
Help!
[298] SQLServer Error: 9002, The log file for database 'tempdb' is full Back
up the transacton log for the database to free up some log space. [SQLSTATE
42000]
Thank you
Lancer 3Hi Lancer,
The first option I would try is to move the tempdb to another drive which
has sufficient space and allow DB to auto grow.
But if you want to keep it in the existing drive and want to limit the
growth of tempdb, it is a good idea to run the following on a scheduled
basis.... Do this during the non peak hours....
BACKUP LOG tempdb WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE('tempdb',8)
Also go through this article
http://www.sql-server-performance.com/tempdb.asp
--
Thanks
Yogishsql

Help on sql 7.0 sp4 tempdb is full

My C: drive was getting low on disk space so I:
Changed the allotted space for tempdb to not grow any larger.
Reduced the memory space from 815 meg to 637 meg in sql server properties.
Rebooted the NT 4 server.
Now I am getting this error every minute. Also, in Enterprise Manager ,
database, shows: "no items".
Help!
[298] SQLServer Error: 9002, The log file for database 'tempdb' is full
Back
up the transacton log for the database to free up some log space. [SQLST
ATE
42000]
Thank you
Lancer 3Hi Lancer,
The first option I would try is to move the tempdb to another drive which
has sufficient space and allow DB to auto grow.
But if you want to keep it in the existing drive and want to limit the
growth of tempdb, it is a good idea to run the following on a scheduled
basis.... Do this during the non peak hours....
BACKUP LOG tempdb WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE('tempdb',8)
Also go through this article
http://www.sql-server-performance.com/tempdb.asp
Thanks
Yogish

Help on sql 7.0 sp4 tempdb is full

My C: drive was getting low on disk space so I:
Changed the allotted space for tempdb to not grow any larger.
Reduced the memory space from 815 meg to 637 meg in sql server properties.
Rebooted the NT 4 server.
Now I am getting this error every minute. Also, in Enterprise Manager ,
database, shows: "no items".
Help!
[298] SQLServer Error: 9002, The log file for database 'tempdb' is full Back
up the transacton log for the database to free up some log space. [SQLSTATE
42000]
Thank you
Lancer 3
Hi Lancer,
The first option I would try is to move the tempdb to another drive which
has sufficient space and allow DB to auto grow.
But if you want to keep it in the existing drive and want to limit the
growth of tempdb, it is a good idea to run the following on a scheduled
basis.... Do this during the non peak hours....
BACKUP LOG tempdb WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE('tempdb',8)
Also go through this article
http://www.sql-server-performance.com/tempdb.asp
Thanks
Yogish

Help needed - Moving database from one server to another server

I need to move database from an SQL 2000 SP4 to a SQL 2005 SP1 server. I
tried the import/export wizard but it is giving me an error. Would I be
able to do a backup from the SQL 2000 SP4 server and then do a restore on
the SQL 2005 SP1.
Any help would be appreciated...
Eric Sabo
It's easier to do a backup/restore or detach/copy/attach.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Sabo, Eric" <sabo_e@.cup.edu> wrote in message
news:%23vPMQWqAHHA.2276@.TK2MSFTNGP03.phx.gbl...
I need to move database from an SQL 2000 SP4 to a SQL 2005 SP1 server. I
tried the import/export wizard but it is giving me an error. Would I be
able to do a backup from the SQL 2000 SP4 server and then do a restore on
the SQL 2005 SP1.
Any help would be appreciated...
Eric Sabo

Help needed - Moving database from one server to another server

I need to move database from an SQL 2000 SP4 to a SQL 2005 SP1 server. I
tried the import/export wizard but it is giving me an error. Would I be
able to do a backup from the SQL 2000 SP4 server and then do a restore on
the SQL 2005 SP1.
Any help would be appreciated...
Eric SaboIt's easier to do a backup/restore or detach/copy/attach.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Sabo, Eric" <sabo_e@.cup.edu> wrote in message
news:%23vPMQWqAHHA.2276@.TK2MSFTNGP03.phx.gbl...
I need to move database from an SQL 2000 SP4 to a SQL 2005 SP1 server. I
tried the import/export wizard but it is giving me an error. Would I be
able to do a backup from the SQL 2000 SP4 server and then do a restore on
the SQL 2005 SP1.
Any help would be appreciated...
Eric Sabo

Help needed - Moving database from one server to another server

I need to move database from an SQL 2000 SP4 to a SQL 2005 SP1 server. I
tried the import/export wizard but it is giving me an error. Would I be
able to do a backup from the SQL 2000 SP4 server and then do a restore on
the SQL 2005 SP1.
Any help would be appreciated...
Eric SaboIt's easier to do a backup/restore or detach/copy/attach.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Sabo, Eric" <sabo_e@.cup.edu> wrote in message
news:%23vPMQWqAHHA.2276@.TK2MSFTNGP03.phx.gbl...
I need to move database from an SQL 2000 SP4 to a SQL 2005 SP1 server. I
tried the import/export wizard but it is giving me an error. Would I be
able to do a backup from the SQL 2000 SP4 server and then do a restore on
the SQL 2005 SP1.
Any help would be appreciated...
Eric Sabo