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 |
|
djaysoft
Starting Member
1 Post |
 Posted - 2009-05-18 : 10:49:41
|
| HiI have SQL Express 2008 installed on a development server running Windows Server 2003 for Small Business Server. I have tried to create several new databases with tables using Microsoft SQL Server Management Studio but when I disconnect and reconnect to the server instance and click the + tree expander in the Object Explorer I get error 1038 Failed to retrieve data for this request (Microsoft.sqlserver.Management.Sdk.Sfc) An Exception Occured while executing a Transact-SQL statement or batch. (Microsoft.Sqlserver.ConnectionInfo). Cannot Use empty object or column names. Use a single space if necessary. Line 1:Incorrect syntax near".Microsoft SQL Server Error:1038). If I browse to the databases through My Computer I can see they are there and I can view (but not change) the tables in Access. Any assistance on this would be most gratefully received. Best regards, David. |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-18 : 23:52:26
|
| Probrably because you don't have access to the databases. You need sa to give your rights to them all or use the system admin login and password. |
 |
|
|
|
|
|
Disappearing Databases