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

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

© 2018   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service