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
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