Hi all Thought I'd share this because it has been driving me nuts all weekend.
I have a SQL 2008 R2 database which needed to be deployed to SQL 2008 Workgroup Edition. No problem? However SQL 2008 will not accept databases from R2, although they are both SQL it is a different animal altogether. The answer is to use R2 Enterprise Manager, right click database, tasks and script database. From the advanced option choose "Script as " and make sure this says 2008. There is also an option to script schema, data or both. Finally run the script generated Hope that helps someone. Graham --- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) application/ms-tnef --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
