Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Use statement not working

Author  Topic 

Vack
Aged Yak Warrior

530 Posts

Posted - 2008-06-09 : 11:10:47
trying to run the following script.

use 001
select *
from imitmidx_sql

Get incorrect syntax near 001

If I change the use 001 to Data_58 it works fine. Do I need special syntax when the database name is 001??

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-09 : 11:20:46
Use proper naming conventions for objects

use [001]
select *
from imitmidx_sql


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -