473,320 Members | 1,987 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do you find the Existing Per Seat License info

Hi , I am a junior DBA and I have been asked to Install and confingure SQL server 2000 on Win 2003 server, and I would like to create a replica of the existing server, so how do i find the no. of Per Seat License, information on the Existing SQL Server. so that I can put in the same.

Thanks,
Raj
Nov 28 '07 #1
1 3893
Jim Doherty
897 Expert 512MB
Hi , I am a junior DBA and I have been asked to Install and confingure SQL server 2000 on Win 2003 server, and I would like to create a replica of the existing server, so how do i find the no. of Per Seat License, information on the Existing SQL Server. so that I can put in the same.

Thanks,
Raj
Run this SQL in analyser..


Expand|Select|Wrap|Line Numbers
  1.  
  2. SELECT(CASE WHEN CONVERT(char(20), SERVERPROPERTY('LicenseType')) = 'Per_Seat'
  3.      THEN 'Per Seat Mode'
  4.      WHEN CONVERT(char(20), SERVERPROPERTY('LicenseType')) = 'Per_Processor'
  5.      THEN 'Per Processor Mode'
  6.      ELSE 'Disabled'
  7.      END) AS License_Type,
  8.      CONVERT(char(20), SERVERPROPERTY('NumLicenses')) AS Number_Of_Licenses,
  9.      CONVERT(char(20), SERVERPROPERTY('ServerName')) AS Server_Name
  10.  
  11.  
Regards

Jim :)
Nov 28 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: dba_db2 at nospam gmx.net | last post by:
We have got a brand new mutltiprocessor machine IBM pseries server with 2 processors. Now we want to buy a IBM DB2 license for this box. Does anyone know whether it is possible to buy a single...
5
by: Ben | last post by:
We have a MSSQL with per seat license of 20. The MSSQL is sitting in the same machine as the asp.net. Does that mean that the the no. of connections and Max Pool Size are limited up to 20 only?...
0
by: Robert Warnestam | last post by:
Hello, I have some problems deploying Crystal Reports. I'm using Visual Studio 2005 Beta 1. In this version Crystal Reports (9.7.3500.0) is included. I created a small test application...
1
by: rdemyan via AccessMonster.com | last post by:
I'm trying to implement a licensing scheme. There are three types of licenses: Trial - good for 30 to 60 days Interim - good for 1 year Fully Paid - no expiration Everything is working fine...
4
by: Jurgen Haan | last post by:
Hi hi everyone. We have upgraded our DB2 LUW 8.2.1 which was directly installed from our DB2 CD's to DB2 LUW 8.2.6 (FP13). (system: HP DL385 (AMD64), single socket, dual core. 8GB memory. SLES...
3
by: pike | last post by:
DB2 on AIX 5.3. I cannot find our v.9 license key. /var/ifor/nodelock contains a license key for our v.8 installation. We have v.9 installed on the same machine and I'm assuming there is a...
3
by: Alami | last post by:
I'm newdie in c programming. this is my first project in programming. I have to write a program for a airline reservation. this is what i have done yet. but when it runs it shows the number of...
8
by: gigonomics | last post by:
Hi all, I hope someone can help me out. I need to return the best available seats subject to the constraint that the seats are side by side (or return X consecutive records from a table column...
3
Slick47
by: Slick47 | last post by:
Hey guys, I've gone one problem (so far) in my program to be able to assign and display seats. When I compile my program I get the error: SeatAssign.java:54: setSeats(char) in SeatAssign cannot...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.