isql error message

[anuu]

Hi,

I have created a database as pubs.qa and wrote a command utility to
query a table.

isql -S server -E -d pubs.qa -i qry.sql -b -n
contents of qry.sql

select * from users
go

when i run this command, error message
Msg 911, Level 16, State 1, Server XXXXXXX, Line 1
Could not locate entry in sysdatabases for database 'pubs'. No entry
found with that name. Make sure that the name is entered correctly.

However, I am able to use this database in Query Analyzer and execute
the query.

I am just wondering if the database name with '.' is the problem...

Any pointers to proceed further.

Thanks in advance
-Anu

[Simon Hayes]

Probably - try using delimiters, ie [pubs.qa] Since the dot/period
character is used to separate parts of an object name in MSSQL
(server.database.owner.object), it is usually a bad idea to use it
within an object name. pubs_qa would probably be a better choice in
this case.

See "Delimited Identifiers" and "Using Identifiers as Object Names" in
Books Online.

Simon

[sqlmatt]

Right, try:
isql -S server -E -d [pubs.qa] -i qry.sql -b -n

[anuu]

sqlmatt wrote:

Right, try:
isql -S server -E -d [pubs.qa] -i qry.sql -b -n

Thanks, it worked.

-Anu