Forum Replies Created

Viewing 15 posts - 286 through 300 (of 3,232 total)

  • RE: Deploying first Cube and failing

    One thing to keep in mind when you use this impersonation mode is password changes. Most windows domain admins have password policies in place requiring users to change passwords...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 9:08 am

    #1243624

  • RE: Deploying first Cube and failing

    Mark F-428640 (10/28/2010)

    Hi John while waiting for your response I found a way to deploy I simply provided my windows login details in the impersonation tab and that seem to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 9:00 am

    #1243614

  • RE: Deploying first Cube and failing

    I use a domain account. This can be a special account that you set up just to run your cubes, or you can use your domain account to run...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 8:58 am

    #1243610

  • RE: Deploying first Cube and failing

    Working with the data source in BIDS uses your user credentials to access the objects from your data source. When you go to deploy the cube (and when the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 8:44 am

    #1243588

  • RE: Shrinking Log files on regular basis -SQL Server 2005

    Right, OP needs to keep an eye on it. My point was that just because he/she is not shrinking the file does not mean that more disk space is...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 8:33 am

    #1243583

  • RE: Shrinking Log files on regular basis -SQL Server 2005

    ps. (10/28/2010)

    you probably need more disk space. or put the log file on a drive having ample free space for the log file to accomodate its growth.

    I would say just...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 28, 2010 at 8:19 am

    #1243570

  • RE: Hidden or Unknown Job Perks

    SQLBill (9/2/2010)

    Great manager.

    Great director.

    Work from home three days a week.

    25 paid days of time off.

    Work laptop to use when working from home.

    On call for one week once every two months.

    Guaranteed...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 27, 2010 at 10:25 am

    #1243037

  • RE: Parent/Child relationship

    Thanks Gus, your correct.

    Chrissy321, You mentioned that you can't put the flag at the parent level because application/security reasons. Rarely have I seen where outside factors like app security...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 27, 2010 at 10:16 am

    #1243027

  • RE: Parent/Child relationship

    Am I missing something Gus?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 27, 2010 at 10:01 am

    #1243014

  • RE: Parent/Child relationship

    Here's one option......

    SELECT c.ChildID,

    c.ParentID,

    c2.Flag

    FROMChild c

    LEFT JOIN (

    SELECT ParentID,

    CASE WHEN SUM(CASE WHEN Flag = 'Y' THEN 1 ELSE 0 END) >= 1 THEN 'Y' ELSE 'N' END as...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 27, 2010 at 9:51 am

    #1243005

  • RE: Shrinking Log files on regular basis -SQL Server 2005

    I would eliminate the step to shrink the logs. You'd be better off letting the logs grow to their optimal size. Shrinking the log reclaims the space, but...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 27, 2010 at 9:43 am

    #1242995

  • RE: Today's Random Word!

    Big League Chew

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 27, 2010 at 9:24 am

    #1242979

  • RE: Database design issue

    Also I am not able to explain here but if needed please tell me if you guys need more info on the table.

    Yes, more info would help a ton. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 26, 2010 at 3:48 pm

    #1242587

  • RE: Capturing the row table that has generated an error in a stored procedure

    pmscorca (10/25/2010)

    Hi, thanks.

    It is occured to have data with an error (f.e. conversion error, arithmetic overflow, ...). The goal isn't to insert the right data but to find which row...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 26, 2010 at 3:42 pm

    #1242586

  • RE: How to get the result from SP to dataflow task

    Data Flow source adapters do allow for SP execution. Does attempting this give you an error?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    October 26, 2010 at 3:20 pm

    #1242579

Viewing 15 posts - 286 through 300 (of 3,232 total)