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.
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.
Replies to This Discussion
-
Permalink Reply by David Pallmann on
-
Can you share your script? You may be using a feature that SQL Azure doesn't support.
-
Permalink Reply by Stephen Zhu on -
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.
About
Latest Activity
Wind blows when the land gets unevenly heated up by the sun making the air just above the land, rise and expand. When the hot air above the land expands, its place is filled in by the heavier and cooler air above it. This makes the wind blow. So as…
© 2010 Created by Azure Admin.
Powered by 
.
