Unless you are crystal reports Guru a third party might be the best bet.
It does hold a lot of info but it' not the easiest to extract. You can
construct SQL queries to get at it as well. This is something I have
struggled with for a long time.
Malcolm
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Berny Stapleton
Sent: 12 January 2007 04:11
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Summary Database
Actually,
Does anyone have a good spreadsheet or way of doing reporting out of the
summary database?
Berny
> It was a permission problem. The account had dbo permission however
did
> not
> have ownership of the tables. Once it had ownership of tables it
worked
> correctly. Thanks for everyone's input.
>
> Mike
>
> Original Message:
> -----------------
> From: Nagarajan C. Haridas nagarajan.haridas@xxxxxxxxxxxx
> Date: Thu, 11 Jan 2007 12:59:29 +0530
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Summary Database
>
>
> Can you check whether u have given DBO permission to the SummaryDB ?
>
> Also ensure the table which created has exclusive permissions?
> INSERT-DELETE-UPDATE.
>
>
> Nagarajan
>
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
> Behalf Of msemon@xxxxxxx
> Sent: Wednesday, January 10, 2007 8:05 PM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Summary Database
>
> This is a new installation so i am not worried about losing any data.
I
> will try deleting and recreating the database.
>
> Original Message:
> -----------------
> From: christopher.walter@xxxxxxx
> Date: Wed, 10 Jan 2007 09:28:55 -0500
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Summary Database
>
>
> Go into SQL Enterprise manager and look to see if your tables are
owned
> by DBO. If not then add the system administrator role to your account
> that you are using. From here you have a choice of changing all of
the
> owners of your tables and stored procedures to DBO or recreating your
> database. I had this about a month ago and found it was easier to
> recreate the database although there are some scripts out there that
> will help you set the ownership on multiple tables if you don't want
to
> lose the info in the summary database.
>
> Chris
>
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
> Behalf Of msemon@xxxxxxx
> Sent: January-10-07 9:09 AM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Summary Database
>
> Having an unusual problem with the Summary Database. In the Summary
> Database tab in Resource Manager it says the Farm Metric adn the
> Database
> Connection server are working
> correctly, however it says there is a Database connection error. The
> have
> setup the Summary Database on SQL 2000. The account that I am using to
> try
> an access the database
> has DBo rights. When I create the ODBC connection and test it is
> successful. I am using
> a Windows account and not a SQL login.
>
> Mike
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
> SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
> SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
>
>
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
> SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
>
>
> The information contained and transmitted by this e-mail is
proprietary to
> SLK Software Services Private Limited and is intended solely for the
use
> of
> the individual or entity to whom it is addressed and others authorized
to
> receive it. It may contain privileged or confidential information or
> information exempt from disclosure as per applicable law. If you are
not
> the intended recipient or responsible for delivery to the intended
> recipient, you may not copy, deliver, distribute or print this
message. If
> it is a forwarded message it may not have been sent with the authority
of
> the company. Any views of opinions are individual to the sender and
are
> not
> the opinion of or endorsed by the company. This message and
attachments
> has
> been virus checked. SLK Software Services Pvt. Ltd. will not accept
any
> claims for loss or damages arising out of viruses.
>
>
>
> SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
>
>
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
> SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
>
>
SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
************************************************
For Archives, RSS, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
//www.freelists.org/list/thin
************************************************
SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
************************************************
For Archives, RSS, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
//www.freelists.org/list/thin
************************************************
