Forum Replies Created

Viewing 15 posts - 571 through 585 (of 1,221 total)

  • RE: Data Ownership

    Bryan Esposito (10/21/2008)


    ... How would you feel about a Republican running around town tearing down signs for the Democrat candidates?

    Happened to my wife last election cycle.

    That aside, the McCain campaign...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Financial Crisis

    Well, unchecked capitalism is what's failing. Things were de-regulated, people found loopholes to make money and exploit the system, and now the proverbial chickens have come home to roost.

    I...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Financial Crisis

    Loner, I agree. It really bites that these people play with our money, then when they lose it, we have to pay again to bail them out. There's...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Hey, Gary. I just worked on cleaning up a big address table, talk about fun! Anyway, how about something like this:

    select left(Address, charindex(' ', Address) - 1) as...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: I need a reality check re: compatibility level & locking

    Thanks for the replies. I expected 2005 to have made improvements in the lock manager, but since my experience with 2005 is minimal, I don't have research material for...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Take the Plunge

    Excellent comments all around, I particularly like Gail's and Anders'.

    For me, it's about bandwidth and control. The area I live in just got a second set of circuits for...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    Carla Wilson (10/7/2008)


    Wayne,

    Wow, good job investigating system tables/views and triggers! (although I did not expect you to drop everything to do it - - I was just reply to...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    Giovanny Gomez Convers (10/7/2008)


    Hi!,

    When I try delete a user on database, appears the next error message:

    "SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    Slightly slow afternoon, so I decided to go exploring. My gut feeling is that it won't work in 2005 or 2008, but I love working with system objects and...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    Carla Wilson (10/7/2008)


    Wayne West (10/3/2008)


    If you wanted to live dangerously...

    I wouldn't recommend it because I'm not comfortable doing anything to system objects.

    ...

    Oh, what the heck. I just...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    Pieter (10/7/2008)


    thanks Wayne!

    We do data warehousing instead of OLTP and like the space savings associated with "set ansi_padding off". Is there a way that we can make it work and...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The South African SQL Server Usergroup is Back

    Good going, Gail! I hope it takes off!

    I'm surprised that they don't have a "tips on starting a SSUG" at PASS in the Professional Development track. I'd kind...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    Carla, have you considered experimenting with a trigger on the information_schema.columns view? BOL says you can apply triggers to views, but I don't know if you can bind them...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    I'm seeing something interesting, and was wondering if someone can tell me what's going on. As an experiment to see what would appear in the log, I modify a...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    You might double-check your code, Joanna, the only time my audit table shows --ENCRYPTED-- is when I create an encrypted view. I assume it would do likewise for any...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 571 through 585 (of 1,221 total)