I discovered that when i added my database, I didn't use the standard to add it.

This is how I added my database:

I went to the server explorer and right-clicked on Data Connections.

Then I selected Add connection.

I then chose Microsoft SQL Server Database File (SqlClient) and added the database file name and other details, i tested the connection and clicked OK.

I should have used the Create New SQL Server Database option.

Now i have created a new database using the Create New SQL server Database option.

is it possible to transfer my tables and stored procedures to this new database i created?