Solved

Cannot generate scripts for data after table move.

Posted on 2009-07-01
4
191 Views
Last Modified: 2012-05-07
I have a database called Materials.

The table was created in a database named DB1.  We needed to move it from DB1 to DB2.
I generated scripts of the table and data and recreated it in DB2.
I took DB1 offline.

Now I am trying to script the Materials table (and data) again.  However, I am getting a "Failed" error because it is saying that the script cannot be generated becasue DB1 is offline!!
It shouldn't matter that DB1 is offline because the table exists only in DB2 now.

How do I fix this so that I can generate the scripts??
0
Comment
Question by:PIERCGG
  • 2
  • 2
4 Comments
 
LVL 35

Expert Comment

by:YZlat
ID: 24754500
are you trying to script the table in DB1 or DB2?
0
 
LVL 6

Author Comment

by:PIERCGG
ID: 24754513
I am trying to script it in DB2.  DB1 is offline.
I need the one in DB2 because a lot of new data was added since it was originally moved.
0
 
LVL 35

Accepted Solution

by:
YZlat earned 250 total points
ID: 24754518
0
 
LVL 6

Author Closing Comment

by:PIERCGG
ID: 31598775
That's it!  That's the answer!  It is a bug that occurs if the db is offline.  The bug doesn't occur if you just go ahead and detach the db.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question