Forum Replies Created

Viewing 15 posts - 31 through 45 (of 619 total)

  • RE: How to query AD to return IF ORIGINAL_LOGIN() is in a specific AD group

    Thanks Lowell.

    For the interest of anybody, we have decided to go with the below: Origenal code pilfered from here.

    /****** Object: DdlTrigger [Logon_Trigger_Monitor_Excel] Script Date: 06/13/2012 16:32:40...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    June 14, 2012 at 9:33 am

    #1501110

  • RE: How to query AD to return IF ORIGINAL_LOGIN() is in a specific AD group

    Lowell (6/13/2012)

    another possibility, but where you would have to grant execute permissions to Everyone ON xp_logininfo (or the trigger has to Execute AS a power user's context) so they...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    June 13, 2012 at 8:31 am

    #1500406

  • RE: How to query AD to return IF ORIGINAL_LOGIN() is in a specific AD group

    Hey All,

    I have moved along with this and now have the below which i have been testing on my ss2k5 local instance.

    /****** Object: DdlTrigger [Logon_Trigger_Monitor_Excel] Script...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    June 13, 2012 at 8:18 am

    #1500398

  • RE: How to query AD to return IF ORIGINAL_LOGIN() is in a specific AD group

    All,

    Thanks for the speedy responses. Lowell, that quite a good idea but I think Andrew's query is more what I'm looking for, needing no additional rights or tables.

    Thanks again.

    A.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    June 13, 2012 at 5:36 am

    #1500276

  • RE: Unsent Log on database mirror seems stuck at 112KB

    Thanks all for your responses. This has now been resolved.

    I stopped both endpoints (principle and mirror) and restarted and the unsent log now goes down to 0KB.

    The article I...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    June 6, 2012 at 3:22 am

    #1497487

  • RE: Unsent Log on database mirror seems stuck at 112KB

    Can nobody help?

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 31, 2012 at 3:48 am

    #1495078

  • RE: General Qestions

    Koen Verbeeck (5/30/2012)

    Enter Sandman, Sad but true and Unforgiven were pretty awesome 🙂

    Have always thought Unforgiven was a bit weak. And Unforgiven II......... Dont get me started.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 30, 2012 at 3:49 am

    #1494531

  • RE: General Qestions

    oh well.

    Sandman and Of Wolf and Man must have been good.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 30, 2012 at 3:39 am

    #1494523

  • RE: Attach Database failed for server 'M3'

    prettsons (5/30/2012)

    The I/O error (torn page) error occurs when SQL Server tried to access a page that had previously not been written to disk correctly. This can be happen due...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 30, 2012 at 3:08 am

    #1494512

  • RE: General Qestions

    Koen Verbeeck (5/30/2012)

    anthony.green (5/28/2012)

    So I wonder if Koen is still alive or if he got taken to hospital with burst ear drums over the weekend

    I'm alive 😀

    Metallica was great, although...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 30, 2012 at 3:00 am

    #1494504

  • RE: General Qestions

    Eugene Elutin (5/28/2012)

    Schadenfreude-Mei (5/28/2012)

    pdanes (5/28/2012)

    Eugene Elutin (5/24/2012)

    P.S. There is an universal solution to stop queries running forever:

    Ask electrician to connect your server room power supply via your floor light...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 29, 2012 at 5:54 am

    #1494112

  • RE: Recover the log file in SQL Server 2005

    venkatb.dba (5/28/2012)

    Hi,

    Thanks for your reply!!!

    The database is in simple recovery model. and i have no backups available for the database.

    Regards,

    Venkat

    Do you know how the log was deleted? It shouldnt have...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 28, 2012 at 8:47 am

    #1493830

  • RE: SQL 2008 SYSADMIN RIGHTS ISSUE

    It could likely be that your 'user/login' just requires dbo rights to a database. You will probably find that as a domain admin or local admin under to ss2005, you...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 28, 2012 at 8:33 am

    #1493819

  • RE: General Qestions

    pdanes (5/28/2012)

    Eugene Elutin (5/24/2012)

    P.S. There is an universal solution to stop queries running forever:

    Ask electrician to connect your server room power supply via your floor light switch, so when...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 28, 2012 at 8:17 am

    #1493813

  • RE: General Qestions

    Eugene Elutin (5/28/2012)

    Ian Scarlett (5/28/2012)

    Hmmm... I wonder if the OP will start going for interviews as a plasterer with all this knowledge being imparted. 😛

    I can say (reading detailed DIY...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

    May 28, 2012 at 7:55 am

    #1493799

Viewing 15 posts - 31 through 45 (of 619 total)