Command(s) completed successfully but... the tables are not created

Question

I backed up my database table's and entire schema into .sql script using Visual Studio's Database Publishing Wizard.

I then tried to re-create those tables on another PC, not before re-creating the database itself, with the same exact name and everything (using a script that I created via SSMS's Script Database as).

I then open that tables .sql file using SSMS and execute it.

SSMS reports:

Command(s) completed successfully

But examining Object Explorer reveals that no tables were created.

Why is this happening?

What have I missed?

Answer 1

I've just been having the exact same problem symptoms also using Visual Studio's Database Publishing Wizard, - but with a slightly different cause / fix.

Even though SQL Server Management Studio says it is connected to the correct database (in the drop down in the ribbon, and in the status bar of the window), it wasn't actually connected to anything.

To identify and fix either:

SELECT DB_NAME() AS DataBaseName

If you get

master

(or any other unexpected database name) as the result, then you are connected to the wrong database and should select the correct DB from the dropdown. This was the cause of your problem.

If you get

Command(s) completed successfully

then somehow you aren't connected at all - this happened to me.

To fix, click the "change connection" button to disconnect and reconnect.