Forum Replies Created

Viewing 15 posts - 2,191 through 2,205 (of 3,348 total)

  • RE: Three Attack Vectors in SQL Server 2005

    derek.colley (3/7/2012)

    I have to point out that this article wasn't about hacking SQL Server 🙂

    I know. I was responding to the discussion here, that was slightly leaning in that direction.

    Yes,...

    March 7, 2012 at 8:27 am

    #1456050

  • RE: Three Attack Vectors in SQL Server 2005

    The three methods mentioned in the article all require (assuming that the domain and SQL Server have been setup wisely) that the person performing the "attack" has access to a...

    March 7, 2012 at 7:38 am

    #1456006

  • RE: Full Recovery Model

    Stewart "Arturius" Campbell (3/7/2012)

    Nice, simple back-to-basics question, thanks, Peter

    For the explanation, refer to Working with Transaction Log Backups, specifically the third paragraph

    And to add to that reference, the reason for...

    March 7, 2012 at 3:55 am

    #1455853

  • RE: Three Attack Vectors in SQL Server 2005

    derek.colley (3/7/2012)

    3. Lift n' shift the database .mdf files from one instance to another. Doing it this way means you'll lose much proprietary info such as logins, certificates...

    March 7, 2012 at 3:51 am

    #1455850

  • RE: MSDB Tables/Views

    David Burrows (3/6/2012)

    John Hanrahan (3/6/2012)

    Glad you all enjoyed the question. I enjoyed the 'whininess' and 'pendaticness' of some of the responses. It's all good.

    At least I got a...

    March 6, 2012 at 2:06 pm

    #1455576

  • RE: BETWEEN

    SKYBVI (3/6/2012)

    Your statements are contradictory.

    Before you were saying that every1 should upgrade to sql server 2008

    Nope, that's not what I wrote. Here is a quote (emphasis added, but words unchanged):

    "that's...

    March 6, 2012 at 7:33 am

    #1455299

  • RE: BETWEEN

    SKYBVI (3/6/2012)

    Hugo Kornelis (3/6/2012)

    SKYBVI (3/6/2012)

    So, the question was not properly asked. They should mention SQL SERVER 2008

    Why?

    SQL Server 2008 was released almost three years ago now. There has already been...

    March 6, 2012 at 6:58 am

    #1455275

  • RE: BETWEEN

    SKYBVI (3/6/2012)

    So, the question was not properly asked. They should mention SQL SERVER 2008

    Why?

    SQL Server 2008 was released almost three years ago now. There has already been another major release...

    March 6, 2012 at 6:19 am

    #1455250

  • RE: MSDB Tables/Views

    Nils Gustav Stråbø (3/6/2012)

    I see that I have failed BIG TIME in my first attempt to be a QOTD whining pedantic :crying:

    I promise to never try to be one again...

    Practice...

    March 6, 2012 at 5:57 am

    #1455235

  • RE: MSDB Tables/Views

    Nils Gustav Stråbø (3/6/2012)

    I don't complain about the functionality of that specific view, I'm just being an annoying pedantic 😀 Every QOTD has one.

    :laugh:

    However, if you were really pedantic, you...

    March 6, 2012 at 4:22 am

    #1455183

  • RE: MSDB Tables/Views

    Nils Gustav Stråbø (3/6/2012)

    And here comes the first complaint of the day (sorry) 😛

    So this view properly implements row-level security, allowing a "normal" user to see only his onw stuff...

    March 6, 2012 at 3:29 am

    #1455171

  • RE: Not In

    I don't need to repeat how the actual explanation is incorrect, as this has been pointed out already. But I don't think anyone has covered what will happen in case...

    March 1, 2012 at 8:24 am

    #1453665

  • RE: Arithmetic 1

    I could not locate a valid explanation

    And hyet, the explanation is simple. I lack the time to find the proper Books Online pages at this time, but they are in...

    February 29, 2012 at 7:29 am

    #1453158

  • RE: Model Database

    bitbucket-25253 (2/22/2012)

    Are you saying that if one uses T-SQL commands to alter the Model DB and then a T-SQL statement to create a new DB the same action of create...

    February 22, 2012 at 8:16 am

    #1450335

  • RE: Model Database

    bitbucket-25253 (2/22/2012)

    If only every one would read the question carefully it states

    In SQL Server 2008 R2, can I set the model database to read only? Will new databases created default...

    February 22, 2012 at 7:19 am

    #1450266

Viewing 15 posts - 2,191 through 2,205 (of 3,348 total)