Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: Holidays

    sunny Brook (5/26/2009)

    Type in Holiday Table in the upper right Search area on this page, and hit Go. You would get a lot hits.

    Thanks, amazing that adding table to holiday...

    May 26, 2009 at 3:37 pm

    #1000227

  • RE: Holidays

    Andy Hogg (5/26/2009)

    I believe that your thinking with a holiday dates table is spot on Joshua.

    Your job could simply determine if today's date is in the table, and if not,...

    May 26, 2009 at 1:45 pm

    #1000160

  • RE: Schema AD Group select denied for one group, but not another

    Does anyone know if this could have anything to do with the server being on a different domain than the users and groups? Like, my server is servername.domain1.system.root, and...

    May 22, 2009 at 3:16 pm

    #999221

  • RE: Schema AD Group select denied for one group, but not another

    Carl Federl (5/21/2009)

    Found that a state of 3 means "maximum user connections exceeded" and the value can be checked by running

    exec sp_configure 'user connections'

    I have yet to see an...

    May 21, 2009 at 3:37 pm

    #998594

  • RE: Schema AD Group select denied for one group, but not another

    Carl Federl (5/21/2009)

    User Debbie.Smith that exists in group [IT-ABC Production Infastructure Users] can not log in and work. It either gives her a connection failed SQLState: 28000 sql server error...

    May 21, 2009 at 12:18 pm

    #998461

  • RE: rapidly growing log file

    doug turner (5/21/2009)

    How do your either completely truncate the log and reclaim the disk space, or keep the log files from growing too large?

    Ask yourself whether you REALLY need a...

    May 21, 2009 at 10:45 am

    #998398

  • RE: Schema AD Group select denied for one group, but not another

    I have tried running sp_validatelogins, it returns nothing. This group has not been renamed in AD, it's only existed so long as I've been testing this out.

    I wrote this...

    May 21, 2009 at 10:42 am

    #998396

  • RE: Schema AD Group select denied for one group, but not another

    Heya, that's a great script, and just as I thought it returns nothing, these two logins are identical in every way. I'm starting to think maybe the ones name...

    May 21, 2009 at 8:19 am

    #998292

  • RE: SSAS Cube without a DW logic

    John Rowan (5/1/2009)

    I'm not sure what 'best practices' are out there for this, but I agree with your line of thought. I personally would handle this by modeling out...

    May 1, 2009 at 2:01 pm

    #987569

  • RE: SP3 domain group won't work

    Steve Jones - Editor (4/16/2009)

    Could there be a deny in there somewhere?

    Can you add the specific user? Can you create a new user and a new group in AD, then...

    April 16, 2009 at 10:54 am

    #979059

  • RE: SP3 domain group won't work

    sunny Brook (4/16/2009)

    If nothing helps, Restart the server/services, which probably will help.

    Sometime the security/permissions won't take effect until after a restart.

    Ya, that's a HUGE problem, this is a server...

    April 16, 2009 at 9:42 am

    #978975

  • RE: SP3 domain group won't work

    MarkusB (4/16/2009)

    I don't think it's related to SP3, at least I don't have such issues on my servers.

    Could it be that the login for the group is disabled?

    Another possibility...

    April 16, 2009 at 9:01 am

    #978936

Viewing 12 posts - 1 through 12 (of 12 total)