LiveStats.XSP

We were running LiveStats.XSP 7.50 on our server and due to a server failure had to re-install.
However, after entering the license key and completing the install, the software still reports as being unlicensed.
What is the procedure to rectify this?

Thanks

That would be entirely up to LiveStats and how they handle their licensing.

I suspect that they tuck some license key into the database (or maybe Master/msdb?), but you really need to contact them.

|||the server name and port in DEEPMETRIX\analyzer\settings.xml needs to be working for livestats! you need to configure iis to accept connections on that host header and port or change the settings in the file.

<Licensing>
<Server>localhost:80</Server>
</Licensing>

there will be no connection from the internet, but there is a licensing app that opens a connection to the licensing server of deepmetrix and to the local instance of livestats. this service uses the above setting to post the license to the local instance.

the madcow|||Actually, it would be up to Microsoft to support the products they have purchased and pledged to support.sql

LiveStats.XSP

We were running LiveStats.XSP 7.50 on our server and due to a server failure had to re-install.
However, after entering the license key and completing the install, the software still reports as being unlicensed.
What is the procedure to rectify this?

Thanks

That would be entirely up to LiveStats and how they handle their licensing.

I suspect that they tuck some license key into the database (or maybe Master/msdb?), but you really need to contact them.

|||the server name and port in DEEPMETRIX\analyzer\settings.xml needs to be working for livestats! you need to configure iis to accept connections on that host header and port or change the settings in the file.

<Licensing>
<Server>localhost:80</Server>
</Licensing>

there will be no connection from the internet, but there is a licensing app that opens a connection to the licensing server of deepmetrix and to the local instance of livestats. this service uses the above setting to post the license to the local instance.

the madcow|||Actually, it would be up to Microsoft to support the products they have purchased and pledged to support.

LiveStats.XSP

We were running LiveStats.XSP 7.50 on our server and due to a server failure had to re-install.
However, after entering the license key and completing the install, the software still reports as being unlicensed.
What is the procedure to rectify this?

Thanks

That would be entirely up to LiveStats and how they handle their licensing.

I suspect that they tuck some license key into the database (or maybe Master/msdb?), but you really need to contact them.

|||the server name and port in DEEPMETRIX\analyzer\settings.xml needs to be working for livestats! you need to configure iis to accept connections on that host header and port or change the settings in the file.

<Licensing>
<Server>localhost:80</Server>
</Licensing>

there will be no connection from the internet, but there is a licensing app that opens a connection to the licensing server of deepmetrix and to the local instance of livestats. this service uses the above setting to post the license to the local instance.

the madcow|||Actually, it would be up to Microsoft to support the products they have purchased and pledged to support.

list Primary and foreign keys

I have a DB with 100 tables. I was wondering if anybody knows a quick way to list primary and foreign key with the column name for all the tables.

Your help would make my life a lot easier

thanks

In 2005 you can simple perform the following query.

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

There are a whole bunch of other system views that display similar information.

Larry Pope

List of Tables and Primary Key Foreign Key Names

Dear All,
I am trying to write some SQL that will give a list of all tables and
Primary Key/ Foreign Key constraints in a database. The code below goes part
of the way but not what I would like. It gives me:
Parent Table: Activities
Child Table: ActivitiesLocation
ForeignKey: 1
PrimaryKey: 17
TotalKeys: 1
(where 1 in the column name in the Activities table that is the Foreign Key
and column name 17 is where the Primary Key is to be found.)
Script:
SELECT TOP 100 PERCENT so1.name AS 'Parent Table', so2.name AS 'Child
Table', sf.fkey AS ForeignKey, sf.rkey AS PrimaryKey, sf.keyno AS TotalKeys
FROM dbo.sysforeignkeys sf INNER JOIN
dbo.sysobjects so1 ON so1.id = sf.rkeyid INNER JOIN
dbo.sysobjects so2 ON so2.id = sf.fkeyid
ORDER BY so1.name
How can I get a list of the column name of column no 17 in the Activies
Table and column no 1 in the ActivitiesLocation table. Is there a better way
to get a listing of the PK/FK for a database along with table names?
Thanks again.
Alastair> I am trying to write some SQL that will give a list of all tables and
> Primary Key/ Foreign Key constraints in a database.
http://www.aspfaq.com/search.asp?q=schema%3A|||Check out the information_schema.key_column_usage view. It should get you
started with what you need.
--Brian
(Please reply to the newsgroups only.)
"Alastair MacFarlane" <AlastairMacFarlane@.discussions.microsoft.com> wrote
in message news:9197A5C9-182B-451B-AE40-05DA1F98E62B@.microsoft.com...
> Dear All,
> I am trying to write some SQL that will give a list of all tables and
> Primary Key/ Foreign Key constraints in a database. The code below goes
> part
> of the way but not what I would like. It gives me:
> Parent Table: Activities
> Child Table: ActivitiesLocation
> ForeignKey: 1
> PrimaryKey: 17
> TotalKeys: 1
> (where 1 in the column name in the Activities table that is the Foreign
> Key
> and column name 17 is where the Primary Key is to be found.)
> Script:
> SELECT TOP 100 PERCENT so1.name AS 'Parent Table', so2.name AS 'Child
> Table', sf.fkey AS ForeignKey, sf.rkey AS PrimaryKey, sf.keyno AS
> TotalKeys
> FROM dbo.sysforeignkeys sf INNER JOIN
> dbo.sysobjects so1 ON so1.id = sf.rkeyid INNER JOIN
> dbo.sysobjects so2 ON so2.id = sf.fkeyid
> ORDER BY so1.name
> How can I get a list of the column name of column no 17 in the Activies
> Table and column no 1 in the ActivitiesLocation table. Is there a better
> way
> to get a listing of the PK/FK for a database along with table names?
> Thanks again.
> Alastair
>|||Thanks Aaron and Brian for both your replies. This group is definately on th
e
ball. Exactly what I wanted.
Alastair
"Aaron Bertrand [SQL Server MVP]" wrote:

> http://www.aspfaq.com/search.asp?q=schema%3A
>
>