SQL Azure: SMO Exception when scripting objects in SSMS 2008 R2

Question

I am using SQL Server Management Studio 2008 R2 to manage a SQL Azure database. When I try to right-click on any of the objects in the database, and do Script Table As -> CREATE -> New Query Editor Window, I get the following exception screen every time:

SQL Azure SMO Exception When Scripting Objects

Scripting for SELECT -> New Query Editor Window is the only option that seems to work without generating an Exception like above. Any ideas??

possible duplicate of Could not generate script from SQL Azure — mellamokb
– mellamokb, Commented Sep 22, 2011 at 20:33

Herve Roggero · Accepted Answer · 2011-09-27 15:21:38Z

2

Here are additional details about this issue.

Latest service update for SSMS: http://support.microsoft.com/kb/2507770

Blog discussing the necessary upgrade: http://social.msdn.microsoft.com/Forums/en-AU/ssdsgetstarted/thread/3dd65548-cf58-41e8-804d-3f6873132a7b

answered Sep 27, 2011 at 15:21

Herve Roggero

5,1841 gold badge19 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Azure: SMO Exception when scripting objects in SSMS 2008 R2

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related