Some of our workstations have Mgt Studio appearing with a check mark on the
exclamation point that executes a query window. Some do not.
What is the meaning of this icon?
Thanks!
Read about SET PARSEONLY. Btw, you can easily test this yourself by starting Profiler, press that
button and in the trace see what SQL is submitted. The button is meant for you to test your code for
syntax errors, without executing the SQL statements.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
> Some of our workstations have Mgt Studio appearing with a check mark on the
> exclamation point that executes a query window. Some do not.
> What is the meaning of this icon?
> Thanks!
|||I don't think you understand what I meant.
I know about the check mark that parses a query for errors - that's been
around since QA.
But on my Mgt Studio screen - the ! point icon has a very little hard-to-see
check mark on top of it - a workstation next to it does not have the icon
appearing like this.
"Tibor Karaszi" wrote:
> Read about SET PARSEONLY. Btw, you can easily test this yourself by starting Profiler, press that
> button and in the trace see what SQL is submitted. The button is meant for you to test your code for
> syntax errors, without executing the SQL statements.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:C5DAEDAE-B87D-4354-B2F3-557FABABCB98@.microsoft.com...
>
|||I don't think it's a checkmark, I just always thought it was a stray
artifact of a badly-resized icon. I've logged onto several machines to try
and find one that looks different, and they all look the same to me (both
direct login and over RDP). Can you show screen shots comparing the two?
Is it possible it's just a visual artifact issue, and not an actual icon
difference that is intentional?
Aaron Bertrand
SQL Server MVP
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...[vbcol=seagreen]
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little
> hard-to-see
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
|||Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never seen that before. Perhaps
a service pack thing?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...[vbcol=seagreen]
>I don't think you understand what I meant.
> I know about the check mark that parses a query for errors - that's been
> around since QA.
> But on my Mgt Studio screen - the ! point icon has a very little hard-to-see
> check mark on top of it - a workstation next to it does not have the icon
> appearing like this.
> "Tibor Karaszi" wrote:
|||Well - I don't know if I can post images on this forum (is it possible?) -
but I did post the images on this forum if you want to go look at it.
http://www.vbforums.com/showthread.php?t=483415
"Aaron Bertrand [SQL Server MVP]" wrote:
> I don't think it's a checkmark, I just always thought it was a stray
> artifact of a badly-resized icon. I've logged onto several machines to try
> and find one that looks different, and they all look the same to me (both
> direct login and over RDP). Can you show screen shots comparing the two?
> Is it possible it's just a visual artifact issue, and not an actual icon
> difference that is intentional?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:F6EF4C02-96DF-43F0-9F47-751F2F1D3B65@.microsoft.com...
>
>
|||Yes, I don't recall ever seeing it *without* the checkmark, and I can't find
a single instance of client tools that doesn't have it. As I said in my
other reply, I merely thought it was a badly generated icon with extra
pixels flailing about.
Aaron Bertrand
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%232vcbR42HHA.5116@.TK2MSFTNGP04.phx.gbl...
> Ahh, I see. Very hard indeed to see (a tiny green one, right?). I've never
> seen that before. Perhaps a service pack thing?
|||Interesting. Did you check the build number for each SSMS?
OK, I fired up a virtual machine, which is RTM, and it didn't have the little green checkmark.
(Aaron, I do think it *is* a tiny tiny checkmark.)
SSMS build number on a machine where I *don't* have the checkmark: 9.00.1399.00. This is RTM
SSMS build number on a machine where I *don't* have the checkmark: 9.00.2047.00. This is sp1
SSMS build number on a machine where I *have* the checkmark: 9.00.3042.00. This is sp2.
So, it seems this wad added in sp2.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:37330604-00F8-405B-B437-33EAA6D1AC9E@.microsoft.com...[vbcol=seagreen]
> Well - I don't know if I can post images on this forum (is it possible?) -
> but I did post the images on this forum if you want to go look at it.
> http://www.vbforums.com/showthread.php?t=483415
> "Aaron Bertrand [SQL Server MVP]" wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment