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.
| Author |
Topic |
|
alikemal
Starting Member
1 Post |
 Posted - 2004-08-04 : 12:48:34
|
| I have recieved an error, implying that the database could not be found, from a windows application where MSDE is running. When I use oSql, the database, which gives the error, appears in the master database but tables are not seem to be found in this database. What can be the cause of this problem. Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-04 : 13:02:40
|
So the database shows up if you do this in osql:>1 SELECT name>2 FROM master.dbo.sysdatabases>3 WHERE name = 'SomeName'>4 GO If so, what happens when you go this:>1 USE SomeName>2 GO>1 SELECT * FROM sysobjects>2 GOChange SomeName to the name of your database.Do you see your objects?Tara |
 |
|
|
|
|
|
Cannot Access Database