Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 9,399 total)

  • RE: On formatting SQL code

    diamondgm (3/29/2016)

    TomThomson (3/28/2016)

    Eric M Russell (3/28/2016)

    The stored procedure I'm currently tasked with refactoring reads like a 20 page short story by Clive Barker.

    You have my deepest sympathy.

    I wrote some of...

    March 29, 2016 at 5:28 am

    #1868178

  • RE: Today's Random Word!

    ThomasRushton (3/29/2016)

    Ed Wagner (3/28/2016)

    TomThomson (3/28/2016)

    Hugo Kornelis (3/28/2016)

    crookj (3/28/2016)

    djj (3/28/2016)

    DonlSimpson (3/28/2016)

    Ed Wagner (3/28/2016)

    Revenant (3/28/2016)

    Ed Wagner (3/28/2016)

    djj (3/28/2016)

    Ed Wagner (3/26/2016)

    EL Jerry (3/25/2016)

    djj (3/25/2016)

    Grumpy DBA (3/25/2016)

    Revenant (3/25/2016)

    DonlSimpson (3/25/2016)

    Grumpy DBA (3/25/2016)

    djj (3/25/2016)

    Dynamics

    Equilibrium

    Homeostasis

    Biology

    Balneology

    Shower

    Cap

    Baseball

    Season

    Salt

    Sea

    Mediterranean

    Diet

    Food

    (for) thought

    Deep

    Sea

    Seafood

    linguine

    Fettuccine

    March 29, 2016 at 5:21 am

    #1868177

  • RE: The SIGN

    Revenant (3/25/2016)

    I too had to go and brush up on SIGN. Thanks, Steve!

    Me too. I don't use it much. In fact, I don't remember the last time I...

    March 29, 2016 at 5:17 am

    #1868174

  • RE: Row Level Security Updates

    Steve Jones - SSC Editor (3/28/2016)

    TomThomson (3/28/2016)

    Nice question,

    It's very like the question 11 days go. Are you trying to din this into us by repetition? (If so, good...

    March 29, 2016 at 5:11 am

    #1868173

  • RE: Unique Constraints

    Nice, simple, straightforward question. I admit I'm surprised that only 55% of the respondents got it right so far.

    March 29, 2016 at 5:06 am

    #1868172

  • RE: Protecting sa

    eric.merrill (3/28/2016)

    A few years ago as part of our DOD audit we had to disable the account. As a secondary check we renamed it as well although we discovered...

    March 28, 2016 at 6:20 pm

    #1868116

  • RE: Protecting sa

    K. Brian Kelley (3/28/2016)

    Ed Wagner (3/28/2016)

    ZZartin (3/28/2016)

    Ed Wagner (3/28/2016)

    Iwas Bornready (3/28/2016)

    Steve Jones - SSC Editor (3/25/2016)

    DBA_Rob (3/25/2016)

    I can't think of a SQL Server environment where I didn't end up needing...

    March 28, 2016 at 3:04 pm

    #1868093

  • RE: Today's Random Word!

    TomThomson (3/28/2016)

    Hugo Kornelis (3/28/2016)

    crookj (3/28/2016)

    djj (3/28/2016)

    DonlSimpson (3/28/2016)

    Ed Wagner (3/28/2016)

    Revenant (3/28/2016)

    Ed Wagner (3/28/2016)

    djj (3/28/2016)

    Ed Wagner (3/26/2016)

    EL Jerry (3/25/2016)

    djj (3/25/2016)

    Grumpy DBA (3/25/2016)

    Revenant (3/25/2016)

    DonlSimpson (3/25/2016)

    Grumpy DBA (3/25/2016)

    djj (3/25/2016)

    Dynamics

    Equilibrium

    Homeostasis

    Biology

    Balneology

    Shower

    Cap

    Baseball

    Season

    Salt

    Sea

    Mediterranean

    Diet

    Food

    (for) thought

    Deep

    Sea

    Seafood

    March 28, 2016 at 2:53 pm

    #1868089

  • RE: Querying multiple databases

    kaplan71 (3/28/2016)

    Hello --

    I reran the script, and it did produce output. The only thing is, the names of the respective databases were not listed. Is the output based on the...

    March 28, 2016 at 9:28 am

    #1868009

  • RE: Today's Random Word!

    Revenant (3/28/2016)

    Ed Wagner (3/28/2016)

    djj (3/28/2016)

    Ed Wagner (3/26/2016)

    EL Jerry (3/25/2016)

    djj (3/25/2016)

    Grumpy DBA (3/25/2016)

    Revenant (3/25/2016)

    DonlSimpson (3/25/2016)

    Grumpy DBA (3/25/2016)

    djj (3/25/2016)

    Dynamics

    Equilibrium

    Homeostasis

    Biology

    Balneology

    Shower

    Cap

    Baseball

    Season

    Salt

    Sea

    Mediterranean

    March 28, 2016 at 9:27 am

    #1868006

  • RE: Querying multiple databases

    kaplan71 (3/28/2016)

    Hello --

    I inserted the syntax UNION ALL in the script, and the following errors appeared on-screen:

    Msg 156, Level 15, State 1, Procedure FindPatient, Line 34

    Incorrect syntax near the keyword...

    March 28, 2016 at 9:25 am

    #1868004

  • RE: Protecting sa

    Steve Jones - SSC Editor (3/28/2016)

    sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try and prevent...

    March 28, 2016 at 7:51 am

    #1867972

  • RE: Protecting sa

    ZZartin (3/28/2016)

    Ed Wagner (3/28/2016)

    Iwas Bornready (3/28/2016)

    Steve Jones - SSC Editor (3/25/2016)

    DBA_Rob (3/25/2016)

    I can't think of a SQL Server environment where I didn't end up needing to turn on mixed authentication,...

    March 28, 2016 at 7:50 am

    #1867971

  • RE: Protecting sa

    Iwas Bornready (3/28/2016)

    Steve Jones - SSC Editor (3/25/2016)

    DBA_Rob (3/25/2016)

    I can't think of a SQL Server environment where I didn't end up needing to turn on mixed authentication, but when it...

    March 28, 2016 at 7:06 am

    #1867951

  • RE: Today's Random Word!

    djj (3/28/2016)

    Ed Wagner (3/26/2016)

    EL Jerry (3/25/2016)

    djj (3/25/2016)

    Grumpy DBA (3/25/2016)

    Revenant (3/25/2016)

    DonlSimpson (3/25/2016)

    Grumpy DBA (3/25/2016)

    djj (3/25/2016)

    Dynamics

    Equilibrium

    Homeostasis

    Biology

    Balneology

    Shower

    Cap

    Baseball

    Season

    Salt

    March 28, 2016 at 5:45 am

    #1867934

Viewing 15 posts - 3,481 through 3,495 (of 9,399 total)