I connect to SQL2000 database by Visual Basic. It run well on OS 98 and 2000 but it can't run on window XP with the same configure(MDAC, Visual Basic, Service Pack Version).
The error occurs when the default database(Initial Catalog) changed as the following code:
SqlCnn as new adodb.connection
SqlCnn.open "Connection String" ' Default database is "Product"
SqlCnn.Default Database = "Customer" ' Error occurs at this line of code.
Do you have any ideas to solve this problem?
thank you very much in advance.obvious questions, but are you running .net or 6? and also, are you sure the DSN is set up properly?|||Hi!
thank you very much.
I'm running Visual Basic 6.0 (Not VB.net) and DSN is correct because my program runs well on OS 98 and 2000.
I hope you'll give me countermeasure.
Showing posts with label window. Show all posts
Showing posts with label window. Show all posts
Wednesday, March 28, 2012
Monday, March 19, 2012
Microsoft Atlas in Reports?
Can Atlas popups be used in reporting services?
Currently I have a javascript pop-up link that opens a new window. What I would like to do is change this to open an Atlas popup.
Thanks
can this be done?Microsoft Atlas in Reports?
Can Atlas popups be used in reporting services?
Currently I have a javascript pop-up link that opens a new window. What I would like to do is change this to open an Atlas popup.
Thanks
can this be done?Monday, March 12, 2012
Mgt Studio - Exclamation Point with a check mark?
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:
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:
Mgt Studio - Exclamation Point with a check mark?
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...
> > 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 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...
>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...
>> > 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!
>>|||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...
>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...
>> > 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!
>>|||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...
> >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...
> >> > 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!
> >>
> >>
>
>|||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...
> 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...
>> >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...
>> >> > 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!
>> >>
>> >>
>>
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...
> > 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 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...
>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...
>> > 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!
>>|||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...
>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...
>> > 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!
>>|||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...
> >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...
> >> > 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!
> >>
> >>
>
>|||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...
> 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...
>> >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...
>> >> > 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!
>> >>
>> >>
>>
Mgt Studio - Exclamation Point with a check mark?
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 y
ou 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 th
e
> 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 starti
ng 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 s
een 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-s
ee
> 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 tr
y
> 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 littl
e 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. T
his 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:
>
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 y
ou 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 th
e
> 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 starti
ng 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 s
een 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-s
ee
> 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 tr
y
> 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 littl
e 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. T
his 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:
>
MgmtStudio: Use current connection/window when opening file
Is there a setting that I am missing, or is it just not possible to do.
When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.
Is there a way that I can set it to NOT do this, and use the existing Window/Connection.
As we have to SQL Logins and thus need to type our passwords each time a new connection is made...
Also, is CTRL-N not in use anymore to open a new connection/window ?
This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
MgmtStudio: Use current connection/window when opening file
Is there a setting that I am missing, or is it just not possible to do.
When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.
Is there a way that I can set it to NOT do this, and use the existing Window/Connection.
As we have to SQL Logins and thus need to type our passwords each time a new connection is made...
Also, is CTRL-N not in use anymore to open a new connection/window ?
This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Saturday, February 25, 2012
message output from XSLT XML Task
Where does output from <xsl:message> stylesheet elements go? It's not in the Progress or Output window, and there doesn't seem to be a property that controls the destination for messages.
Kevin Rodgers wrote:
Where does output from <xsl:message> stylesheet elements go? It's not in the Progress or Output window, and there doesn't seem to be a property that controls the destination for messages.
I have the same question.
The ability to see the output from <xsl:message> would partially make up for the inability to set breakpoints in XSLT.
|||Hi Kevin,
Interestingly enough, they go to standard output, which is really only visible if you're running dtexec directly. This is the default of the underlying System.Xml.Xsl engine, which the XML Task's XSLT operation is based on.
-David
|||
David, as I'm sure you know, it's possible for code to capture the output ot <xsl:message/>, and to send the output whereever it likes.
Good tip on standard output, though.
Monday, February 20, 2012
message output from XSLT XML Task
Where does output from <xsl:message> stylesheet elements go? It's not in the Progress or Output window, and there doesn't seem to be a property that controls the destination for messages.
Kevin Rodgers wrote:
Where does output from <xsl:message> stylesheet elements go? It's not in the Progress or Output window, and there doesn't seem to be a property that controls the destination for messages.
I have the same question.
The ability to see the output from <xsl:message> would partially make up for the inability to set breakpoints in XSLT.
|||
Hi Kevin,
Interestingly enough, they go to standard output, which is really only visible if you're running dtexec directly. This is the default of the underlying System.Xml.Xsl engine, which the XML Task's XSLT operation is based on.
-David
|||
David, as I'm sure you know, it's possible for code to capture the output ot <xsl:message/>, and to send the output whereever it likes.
Good tip on standard output, though.
Subscribe to:
Posts (Atom)