[THIN] Re: Summary Database

Yeah I know, I think it is kind of hard and time-consuming work to create
your own reports. A great job by Jason Conger anyway!

On 1/15/07, Malcolm Bruton <malcolm.bruton@xxxxxxxxxxxxxxxxxx> wrote:


 I have looked at this before and yes it is good.  Needs to have more
reports and I'm just not clever enough to do some more work on it…..Also
sadly we are still on XPe.  Hopefully not for much longer.


 ------------------------------

*From:* thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] *On
Behalf Of *Michel Roth
*Sent:* 15 January 2007 10:12
*To:* thin@xxxxxxxxxxxxx
*Subject:* [THIN] Re: Summary Database



Use 
WIRM!<http://www.jasonconger.com/ShowPost.aspx?strID=f0d11211-b409-462b-83e7-db1c17020ce5>

On 1/12/07, *Malcolm Bruton* < malcolm.bruton@xxxxxxxxxxxxxxxxxx> wrote:

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:
> http://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:
> http://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:
> http://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:
> http://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:
> http://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:
http://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:
http://www.freelists.org/list/thin
************************************************

Other related posts: