| | |
Tables appear under wrong database in SQL Server Mgmt. Studio Express
Please support our MS SQL advertiser: Intel Parallel Studio Home
Thread Solved |
•
•
Join Date: Nov 2009
Posts: 6
Reputation:
Solved Threads: 0
Whenever I create a new database from a C# program and create tables for that database, the tables always show up under the creator's default database instead of being listed under the newly created database. This observation is from Microsoft SQL Server Management Studio Express. Is there some setting in Microsoft SQL Server Management Studio Express that I may apply to the users to remedy this?
FYI: SQL Server 9.0.3042
SQL Server Management Studio Express 9.00.2047.00
FYI: SQL Server 9.0.3042
SQL Server Management Studio Express 9.00.2047.00
•
•
Join Date: May 2004
Posts: 72
Reputation:
Solved Threads: 5
0
#2 15 Days Ago
•
•
•
•
Whenever I create a new database from a C# program and create tables for that database, the tables always show up under the creator's default database instead of being listed under the newly created database.
If you're using the same connection string that created the database to send the create table commands, remember there's no database specified on that connection. Once you've created the database, you'll have to create a new connection that specifies the new database's name. Use that connection to create the tables.
If that doesn't apply to what you're doing (i.e., you're already creating a new connection) or it doesn't solve the problem, please post the relevant code so we can help.
--smg
•
•
Join Date: Nov 2009
Posts: 6
Reputation:
Solved Threads: 0
0
#3 14 Days Ago
•
•
•
•
Hi again!
If you're using the same connection string that created the database to send the create table commands, remember there's no database specified on that connection. Once you've created the database, you'll have to create a new connection that specifies the new database's name. Use that connection to create the tables.
If that doesn't apply to what you're doing (i.e., you're already creating a new connection) or it doesn't solve the problem, please post the relevant code so we can help.
![]() |
Similar Threads
- SQL Server 2005 express connection error (VB.NET)
- error "Could not open a connection to SQL Server" (MS SQL)
- SQL Database connection via network (VB.NET)
- formatting in sql server (MS SQL)
- ms access database to sql server (MS Access and FileMaker Pro)
- Copy a table from one database to another database in another ms sql server using .. (MS SQL)
- How do I Backup the MS SQL server 2000 database file (mdf) to my local PC ? (MS SQL)
- SQL Server 2005 Install - What Do I Need? (MS SQL)
Other Threads in the MS SQL Forum
- Previous Thread: Retrieve row based column having null value in sql2000
- Next Thread: Smart Searches
| Thread Tools | Search this Thread |





