Showing posts with label business. Show all posts
Showing posts with label business. Show all posts

Thursday, March 22, 2012

Changing a SQL 2000 CD Key?

My company has recently sold a part of its business, and along with that business goes a live SQL 2000 server. However, the license for said SQL Server was not part of the sale. So, to make a long story short I've been tasked with finding a way to A) change the license key of the existing installation to the new owner's license key while B) keeping the existing installation intact and running.

Now I've done enough digging to know exactly where the key info is kept in the registry (in HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Registration), but I'm more than a bit leery of changing the key at the registry level without confirmation that it will work. I do have a test server I can use as a test if necessary, but I'd prefer to get more feedback before I begin trials.

Thank you in advance

You've installed a specific license for SQL Server. If you're selling the computer on which that license resides you'll have to uninstall that license and install another license. Assuming, of course, the license for the OS that resides on the server is being sold. You should check that selling the OS license is possible in your jurisdiction; license are sometimes not transferable.

Tuesday, March 20, 2012

Changes that 15MB/Sec to 25 MB/Sec

For the last 6 months our database disk transfer rate has been at 15MB/Sec
during normal business hours.
Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one day
and has stayed at that rate since. The number of transactions/sec is the
same from the change 15MB/Sec to 25MB/Sec.
What could make this rate change so quickly?
Changes in index planes, larger transactions, and etc.?
Please help me with this issue.
Thanks,
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>
|||Then there is always system patches, bios updates, and driver version
changes.
Anthony Thomas

"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eaju62IOFHA.164@.TK2MSFTNGP12.phx.gbl...
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>

Changes that 15MB/Sec to 25 MB/Sec

For the last 6 months our database disk transfer rate has been at 15MB/Sec
during normal business hours.
Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one day
and has stayed at that rate since. The number of transactions/sec is the
same from the change 15MB/Sec to 25MB/Sec.
What could make this rate change so quickly?
Changes in index planes, larger transactions, and etc.?
Please help me with this issue.
Thanks,Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>|||Then there is always system patches, bios updates, and driver version
changes.
Anthony Thomas
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eaju62IOFHA.164@.TK2MSFTNGP12.phx.gbl...
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>

Changes that 15MB/Sec to 25 MB/Sec

For the last 6 months our database disk transfer rate has been at 15MB/Sec
during normal business hours.
Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one day
and has stayed at that rate since. The number of transactions/sec is the
same from the change 15MB/Sec to 25MB/Sec.
What could make this rate change so quickly?
Changes in index planes, larger transactions, and etc.?
Please help me with this issue.
Thanks,Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>|||Then there is always system patches, bios updates, and driver version
changes.
Anthony Thomas
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eaju62IOFHA.164@.TK2MSFTNGP12.phx.gbl...
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>