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.


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: 91

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.


Latest Activity

Profile IconKevin Rolnick, Tony Williams, Mark Sullivan and 48 more joined Azure User Groups
Sep 21, 2018

© 2019   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service