Wednesday, March 7, 2012

Get SQL 2005 Server Licence Info

Hi!
I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
VBScript
From a remote location I connect to the server and grab those info with my
administrative rights, but I'm not accessing the DB with a SA account...
With SQL 2000 Server I retrieved those info from registry...
In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\80\MSSQLLicenseInfo\MSSQL8.00
Value Mode and ConcurrentLimit
But now hot to get this info for SQL 2005'
Thanks a lot!
FredOften, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:
Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).
If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> Hi!
> I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> VBScript
> From a remote location I connect to the server and grab those info with my
> administrative rights, but I'm not accessing the DB with a SA account...
> With SQL 2000 Server I retrieved those info from registry...
> In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\80\MSSQLLicenseInfo\MSSQL8.00
> Value Mode and ConcurrentLimit
> But now hot to get this info for SQL 2005'
>
> Thanks a lot!
> Fred
>|||Hey
Could you please try to answer the question?
Your post is making me waste my precious time!
Go away with your completly boring comment!
You prevent people with real knowledge to answer my questions since all my
posts seem to be answered!!!
Fred
"Arnie Rowland" wrote:
> Often, the quality of the responses received is related to our ability to
> 'bounce' ideas off of each other. In the future, to make it easier for us to
> give you ideas, and to prevent folks from wasting time on already answered
> questions, please:
> Don't post to multiple newsgroups. Choose the one that best fits your
> question and post there. Only post to another newsgroup if you get no answer
> in a day or two (or if you accidentally posted to the wrong newsgroup -and
> you indicate that you've already posted elsewhere).
> If you really think that a question belongs into more than one newsgroup,
> then use your newsreader's capability of multi-posting, i.e., posting one
> occurrence of a message into several newsgroups at once. If you multi-post
> appropriately, answers 'should' appear in all the newsgroups. Folks
> responding in different newsgroups will see responses from each other, even
> if the responses were posted in a different newsgroup.
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> >
> > Hi!
> >
> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> > VBScript
> >
> > From a remote location I connect to the server and grab those info with my
> > administrative rights, but I'm not accessing the DB with a SA account...
> >
> > With SQL 2000 Server I retrieved those info from registry...
> >
> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > Server\80\MSSQLLicenseInfo\MSSQL8.00
> > Value Mode and ConcurrentLimit
> >
> > But now hot to get this info for SQL 2005'
> >
> >
> >
> > Thanks a lot!
> >
> > Fred
> >
>
>|||Arnie Rowland,
Your comment is not justified. Posting in multiple groups is very wise.
Different people visit different sites, and reaching them requires it.
Time is often critical, and waiting "a day or two" is out of the
question.
Sorry I can not help you Fred. Good luck.
Terry
Arnie Rowland wrote:
> Often, the quality of the responses received is related to our ability to
> 'bounce' ideas off of each other. In the future, to make it easier for us to
> give you ideas, and to prevent folks from wasting time on already answered
> questions, please:
> Don't post to multiple newsgroups. Choose the one that best fits your
> question and post there. Only post to another newsgroup if you get no answer
> in a day or two (or if you accidentally posted to the wrong newsgroup -and
> you indicate that you've already posted elsewhere).
> If you really think that a question belongs into more than one newsgroup,
> then use your newsreader's capability of multi-posting, i.e., posting one
> occurrence of a message into several newsgroups at once. If you multi-post
> appropriately, answers 'should' appear in all the newsgroups. Folks
> responding in different newsgroups will see responses from each other, even
> if the responses were posted in a different newsgroup.
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> >
> > Hi!
> >
> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> > VBScript
> >
> > From a remote location I connect to the server and grab those info with my
> > administrative rights, but I'm not accessing the DB with a SA account...
> >
> > With SQL 2000 Server I retrieved those info from registry...
> >
> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > Server\80\MSSQLLicenseInfo\MSSQL8.00
> > Value Mode and ConcurrentLimit
> >
> > But now hot to get this info for SQL 2005'
> >
> >
> >
> > Thanks a lot!
> >
> > Fred
> >|||> Your comment is not justified. Posting in multiple groups is very wise.
But if you multi-post instead of posting independently, all can see all answers. If you post
independently, one can spend 5 minutes writing an answer just to then find out that a satisfactory
answer has already been given in another group. Since there is a lot of traffic here, some posts go
un-answered (no-one here is paid to help), avoiding this waste of resources is considered polite.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Terry" <tduffy@.calamos.com> wrote in message
news:1159795280.559822.85290@.i42g2000cwa.googlegroups.com...
> Arnie Rowland,
> Your comment is not justified. Posting in multiple groups is very wise.
> Different people visit different sites, and reaching them requires it.
> Time is often critical, and waiting "a day or two" is out of the
> question.
> Sorry I can not help you Fred. Good luck.
> Terry
> Arnie Rowland wrote:
>> Often, the quality of the responses received is related to our ability to
>> 'bounce' ideas off of each other. In the future, to make it easier for us to
>> give you ideas, and to prevent folks from wasting time on already answered
>> questions, please:
>> Don't post to multiple newsgroups. Choose the one that best fits your
>> question and post there. Only post to another newsgroup if you get no answer
>> in a day or two (or if you accidentally posted to the wrong newsgroup -and
>> you indicate that you've already posted elsewhere).
>> If you really think that a question belongs into more than one newsgroup,
>> then use your newsreader's capability of multi-posting, i.e., posting one
>> occurrence of a message into several newsgroups at once. If you multi-post
>> appropriately, answers 'should' appear in all the newsgroups. Folks
>> responding in different newsgroups will see responses from each other, even
>> if the responses were posted in a different newsgroup.
>>
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
>> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
>> >
>> > Hi!
>> >
>> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
>> > VBScript
>> >
>> > From a remote location I connect to the server and grab those info with my
>> > administrative rights, but I'm not accessing the DB with a SA account...
>> >
>> > With SQL 2000 Server I retrieved those info from registry...
>> >
>> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
>> > Server\80\MSSQLLicenseInfo\MSSQL8.00
>> > Value Mode and ConcurrentLimit
>> >
>> > But now hot to get this info for SQL 2005'
>> >
>> >
>> >
>> > Thanks a lot!
>> >
>> > Fred
>> >
>|||Yeah, I understand, but I'm not at home and I had to do a request to let me
go to this site to post question, it took about a week and now you're
requesting me to request an access to use another software than the webpage...
If Microsoft thought it would be better like this, they would do it...
They are the one who knows, aren't they?
Fred :P
"Tibor Karaszi" wrote:
> > Your comment is not justified. Posting in multiple groups is very wise.
> But if you multi-post instead of posting independently, all can see all answers. If you post
> independently, one can spend 5 minutes writing an answer just to then find out that a satisfactory
> answer has already been given in another group. Since there is a lot of traffic here, some posts go
> un-answered (no-one here is paid to help), avoiding this waste of resources is considered polite.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Terry" <tduffy@.calamos.com> wrote in message
> news:1159795280.559822.85290@.i42g2000cwa.googlegroups.com...
> > Arnie Rowland,
> >
> > Your comment is not justified. Posting in multiple groups is very wise.
> > Different people visit different sites, and reaching them requires it.
> > Time is often critical, and waiting "a day or two" is out of the
> > question.
> >
> > Sorry I can not help you Fred. Good luck.
> >
> > Terry
> >
> > Arnie Rowland wrote:
> >> Often, the quality of the responses received is related to our ability to
> >> 'bounce' ideas off of each other. In the future, to make it easier for us to
> >> give you ideas, and to prevent folks from wasting time on already answered
> >> questions, please:
> >>
> >> Don't post to multiple newsgroups. Choose the one that best fits your
> >> question and post there. Only post to another newsgroup if you get no answer
> >> in a day or two (or if you accidentally posted to the wrong newsgroup -and
> >> you indicate that you've already posted elsewhere).
> >>
> >> If you really think that a question belongs into more than one newsgroup,
> >> then use your newsreader's capability of multi-posting, i.e., posting one
> >> occurrence of a message into several newsgroups at once. If you multi-post
> >> appropriately, answers 'should' appear in all the newsgroups. Folks
> >> responding in different newsgroups will see responses from each other, even
> >> if the responses were posted in a different newsgroup.
> >>
> >>
> >>
> >>
> >> --
> >> Arnie Rowland, Ph.D.
> >> Westwood Consulting, Inc
> >>
> >> Most good judgment comes from experience.
> >> Most experience comes from bad judgment.
> >> - Anonymous
> >>
> >>
> >> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
> >> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> >> >
> >> > Hi!
> >> >
> >> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> >> > VBScript
> >> >
> >> > From a remote location I connect to the server and grab those info with my
> >> > administrative rights, but I'm not accessing the DB with a SA account...
> >> >
> >> > With SQL 2000 Server I retrieved those info from registry...
> >> >
> >> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> >> > Server\80\MSSQLLicenseInfo\MSSQL8.00
> >> > Value Mode and ConcurrentLimit
> >> >
> >> > But now hot to get this info for SQL 2005'
> >> >
> >> >
> >> >
> >> > Thanks a lot!
> >> >
> >> > Fred
> >> >
> >
>

No comments:

Post a Comment