Timeline for Is attaching a database on the same server under a different database name possible?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 6, 2014 at 19:11 | comment | added | user507 | I would take the error or information you are getting when trying to create diagrams and post as a new question. | |
| Dec 6, 2014 at 18:41 | comment | added | IEnjoyEatingVegetables | Shawn, turns out I had saved the stored procedure and didn't have to use the mdf they provided me. I followed your link to DBCC CHECKPRIMARYFILE, and read up anyways. Thanks. I do have another question though... SSMS is unable to create a database diagram for the main database. My question is, "Can I create a new database with that mdf?". I created a mock database, to see if the issue of not being able to create a diagram was only for the main database. Sure enough, you can create diagrams for new databases. SO how could I copy the current db to a new one, so I can extract the diagram? | |
| Dec 6, 2014 at 18:26 | vote | accept | IEnjoyEatingVegetables | ||
| Dec 6, 2014 at 18:26 | |||||
| Nov 30, 2014 at 19:24 | history | answered | user507 | CC BY-SA 3.0 |