Error getting list of objects from db in SQL Server 2014

user_4382091 0
Viewed 8801

I am new to SQL Server 2014 and I was trying to generate data script from a database but I kept getting this error:

Error getting list of objects from db_name

The query for creating tables and inserting data was successful and generating schema script was successful too. I did some research and found this link.

I did turn auto close option off according to a guy's reply but it didn't work, I followed up on the link to another thread but there's nothing.

sql-server
2 Answers
  1. Click on "Save Report" button
  2. Open the generated file and analyze the message regarding the error, this can give a clue on how to solve the problem.

In my case was that the sql output file was being used by another process. I closed the SQSMS, reopened and that's it.

user_105329850

I ran into this issue and what appeared to solve it for me was to generate a "schema only" script. Once this is successful, go back and try to generate the "data only" script again.

user_6071880
Related