Create table using SQL Server Management Studio Express

I am a newbie with MS SQL. Please help. I am trying to duplicate a database schema from my local sql express database to the mssql server.

Using the SQL Server Management Studio Express on my PC, I logged in to mssqlx... server and ran a script to create a table in my database. It was successful. But I couldn't see the table in the list even after a refresh and reconnect. A select query continued to work fine that means the table was there. But why couldn't I see it?

I can see my previous tables but their name begins with my userid_. Do all tables have to begin with my userid_ to be visible?

I will appreciate any hints.

Thanks,
Sanjay
 
Welll, on the suggestion of Stephen in another thread in the database forum, I downloaded the EMS SQL manager lite and regenerated the query for the local database and executed on the actual server and it worked like a charm.

So, I won't use SSME to create tables again.
 
Back
Top