August 10, 2009 at 3:43 am
Hi,
Just posting this to see if it also happens to you.
In SSMS on which I have with SP3 - go into any database and right-click views to create a new view.
In the view type:
Declare @ref as int
Set @ref = 1
(or any other values)
then hit execute and for me the debugger pops up and SSMS goes down.
I have tried it on two different installs with the same results.
Does this happen to you - can you make it crash using other techniques!
p.s. I am not logging this to point out code that may or may not be correct just the way SSMS deals with it.
August 11, 2009 at 8:39 am
I can replicate it. I have attached the screen shot as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 11, 2009 at 8:42 am
It is odd - I know you can't put variables in a view but you'd think SSMS would just return a TSQL error rather than commit suicide.
August 11, 2009 at 10:40 am
Tried this using SSMS - SQL Server 2008
When clicking execute - a message is displayed sating that
The query cannot be represented in the Diagram and Criteria Pane.
.
However you can click on the Continue button on the message box .
It then displays a message box stating
Query has executed successfully
If you attempt to save the view another message box is displayed stating
Incorrect syntax near the keyword DECLARE
Whatever the glitch, seems like it has been corrected
August 12, 2009 at 2:14 am
Hi
Although I didn't say it explicitly I did say SSMS with sp3 which means SQL 2005.
It's true it works in SQL 2008 but crashes 2005 so I guess they have fixed it.
August 12, 2009 at 5:22 am
Crashes?? Do you mean sql service stops when you execute statement to create new view or only ssms goes down?
I have only production servers with me so can't do that.
-LK
August 12, 2009 at 6:11 am
The whole things goes down - you get Visual studio debugger come up and then SSM closes. You might get the chance to save some work if you ignore the debugger for a bit.
If you really wanted to try it you could install the SQL Tools on your local PC - which may be useful for other things but not really worth it just to replicate this crash!
August 12, 2009 at 4:11 pm
Tried this using SSMS - SQL Server 2005 SP2
When clicking execute - a message is displayed sating that
The query cannot be represented in the Diagram and Criteria Pane.
.
However you can click on the Continue button on the message box .
It then displays a message box stating
Incorrect syntax near the keyword DECLARE.
MJ
August 13, 2009 at 2:10 am
That's strange - or not as that is what I'd expect it to say.
I wonder what the difference between SP3 and 3 was htat makes it crash. (I have SP3 with CU4 on top of it.)
What ever it is they seem to have fixed it for 2008 ( or may be not and it'll crop up in afer anothr service pack)
It's not a serious issue that I' bother contacting MS about just an oddity.:-)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply