Find SQL Server Product key installed on server

Hello;

I am trying to get information of SQL Server licensed key which is installed on our servers. I am using SQL Server 2005 standard edition. Is there a way to find out the product key which is installed on servers. I did some searches and found some thirdparty software to get that information but I don't want to use them on production, is there a way which microsoft recommends.

ThanksHello;

I am trying to get information of SQL Server licensed key which is installed on our servers. I am using SQL Server 2005 standard edition. Is there a way to find out the product key which is installed on servers. I did some searches and found some thirdparty software to get that information but I don't want to use them on production, is there a way which microsoft recommends.

Thanks
mmmm. Do you really think that Micro$oft is going to recommend software that could be used by the unscrupulous to pirate their software? :confused:|||Microsoft has a tool that is normally used by bulk licensors of their software that is used for license reporting that does display this information. If you are using bulk licensing (where you deploy from a set of master images, then write a check directly to Microsoft for the copies you have in production use) then check with either your own license administrator (usually a domain admin) or with your Microsoft Sales Representative.

-PatP

Find All Children Of A specified Group ID

Hi all, Im designing a product menu like the one seenhere.
I need to be able to itterate through all product menu groups in a table and find all children of a specified parent. Sorry for the cryptic Explanation and crappyDiagram!

Please see mydiagramWhat does you table(s) look like? Can you post the DDL and some sample data?|||Certainly.

Here you go.|||Have you ever looped through all directories on a drive, folder by folder by coding a function that searches all subdirectories of a single directory and calls itself on each directory that it finds?

This is what im trying to achieve here, only by using stored procedures.|||>>Have you ever...

Sure. Here are some links which should get you on your way.

http://www.sqlteam.com/item.asp?ItemID=8866
http://www.intelligententerprise.com/001020/celko1_1.jhtml?_requestid=57013|||Nice one, Ta very much indeed!

final product

Hi all,

I have build a small asp.net websites where I want to generate some reports, but I have some questions?

Do you have to install the reporting services on the system where the final product will be hosted?

I have tried to use the report viewer to build a local delivery report, but I can not see the printer, any solution to that ?

Yes you have to install Microsoft Report Viewer.

But, if you create a kit for your web site=> properties on the kit =>Prerequisites=>chech ""Microsoft Reports for VS 2005" (something like this) and also

VERY IMPORTANT chech the second options from down "Telecharger les components requires a partir de l'amplacement de mon application" (sorry but i have VS in french)

Thease option will create the kit with all you nead to run reports after the instalation!!!

Popa Iulia

__________________________________

MCP.MCAD.MCSD

|||

iuliax:

Yes you have to install Microsoft Report Viewer.

Popa Iulia

__________________________________

MCP.MCAD.MCSD

I know that report viewer has to be installed? What about SQL services?

When using report viewer with asp.net local delivery the printer icon disappear?

any solution to that?

|||

Hi there,

I am not sure if could solve that problem of not seeing printer on the reportviewer.

If you have solve the problem that please let me know, as I am also having same problem here. The printer does not appear on the toolbar. Even though I switched the Showprinter properties of reportviewer true.

Thanks

MEmam

kms

|||

Hi there,

I am still waiting for the any answer.

Please if there anyone is welcome to help me to solve the problem of why I can't see printer option on my reportviewer.

Thanks in advance if there is anyone who could provide me the answer. It will be a great help.

regards,

Emam