How to fix error Msg 1801, Level 16, State 3, Line 1

Question

_{Thursday, December 8, 2011 2:52 AM}

Msg 1801, Level 16, State 3, Line 1

All replies (4)

_{Friday, December 9, 2011 3:30 AM ✅Answered}

Hi Needknowledge.me,

**>> Msg 1801, Level 16, State 3, Line 1
**
What did you want to do?  As RamJaddu mentioned, it might be the database which is already existed already.

Assuming you want create tables in an existing database, please follow the steps as below:
Open SSMS, and click "New Query" (top left, underneath File). Choose the database that you're working with, and you're off to the races. If you need help with the CREATE TABLE syntax, you'll find it here.

I suspect that you try to reattach database with SSMS by the steps as (click Databases >> right click >>Attach) or using T-SQL statements. It might be attaching a file using a database name that already exists.  And also, it's possible that your database file is corrupted.

Here is a thread with the same error message as yours, please refer to this thread. http://social.msdn.microsoft.com/Forums/eu/sqlsetupandupgrade/thread/cd4caa28-04a6-43f4-b16d-b519fbb070c6

Regards, Amber zhang

---

_{Thursday, December 8, 2011 3:21 AM}

Hi,

Sorry but please post some more information such as what you are doing when you recieve the error, the code you are running, the version of SQL Server, did this work before, etc?

Alternatively try googling the error.

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog or Twitter.
Please click the Mark as Answer button if a post solves your problem!

---

_{Thursday, December 8, 2011 11:58 AM}

This error comes up when you try to create database which already exists on the server please see here for more

http://www.sql-server-performance.com/2007/database-already-exists/

http://uk.linkedin.com/in/ramjaddu

---

_{Saturday, December 20, 2014 4:59 PM}

Hi there

I want add script file in sql  server but  when execute i have error:
 Msg 1801, Level 16, State 3, Line 3

Please help me

Thanks