I have a problem in connecting Azure sql through sql server 2008 management studio

I can connect to my database correctly, but I cannot execute any sql commands.
The error message is:
TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot execute script.

------------------------------
ADDITIONAL INFORMATION:

Object reference not set to an instance of an object. (Microsoft.SqlServer.Smo)

------------------------------

with error stack:
at Microsoft.SqlServer.Management.Smo.Server.get_IsSingleUser()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.DebugWrapper.Start()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.OnDebugScript(Object sender, EventArgs a)

Does anybody have idea about this issue? Thank you.

Views: 97

Reply to This

Replies to This Discussion

Can you share your script? You may be using a feature that SQL Azure doesn't support.
Thank you for your reply. It seems that I have identified the problem.
I made a mistake that I pressed "debug" button to run my script. (e.g. select @@version)
I switched to "execute" and everything is fine now.

RSS

Latest Activity

Profile IconKevin Rolnick, Tony Williams, Mark Sullivan and 48 more joined Azure User Groups
Sep 21, 2018
chandupatla joined Mike Holdorf's group
Thumbnail

Dallas Azure User Group

Dallas Azure User Group - Meetings held at the Microsoft Technology Center in Las Colinas
Apr 20, 2017
Anthony.Tex.M posted a status
"We are ACTIVE on http://www.hccug.org ... and open for new members!"
Feb 21, 2017
Ani Arth posted an event
Thumbnail

Live! 360 Orlando at Loew's Royal Pacific Resort

November 17, 2014 to November 21, 2014
Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. These co-located events will incorporate knowledge transfer and networking, along with out-of-this-world education and training, as you create your own custom conference, mixing and matching sessions and workshops to best suit your needs. Whether you are a developer who uses Visual Studio, SQL Server, and SharePoint;…See More
Jun 6, 2014

© 2019   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service