Forum Replies Created

Viewing 15 posts - 166 through 180 (of 295 total)

  • RE: What happens to a variable after COMMIT or ROLLBACK

    Nice and easy start to the week .. nice question thanks.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Hekaton

    Nice and easy for the end of the week - thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Database permissions

    Not a big fan of questions involving deprecated features, that never seem to go away.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: T-SQL counts

    Nice easy one thanks.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Truncate

    Good question, learnt something

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Filestream data

    Don't often use FILESTREAM so was nice to h ave to go and do some 'forced' reading on it.

    Thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Executing Dynamic SQL

    Thanks, nice one-ish

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Disable [guest] database user in [msdb] database

    good question - had me thinking at a broader level rather than down to the individual databases - hence the wrong answer....

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Declare Variable

    And again, nice and easy wins the race.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Datefirst

    Nice and steady wins the race - easy QotD for the week.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Database sycronisation

    Nothing has been set up. Im looking for ideas to see if this is possible. Replication the entire database with to ensure the two are in sync I don't think...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Alter Certificate

    Straight forward good question, complicated by rushing to answer it 🙁

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: wildcards

    The question is broken...

    Msg 8152, Level 16, State 14, Line 5

    String or binary data would be truncated.

    The statement has been terminated.

    (0 row(s) affected)

    Had to try it after seeing so many...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Garbage Collection

    Good question -

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Global Configuration Settings

    Sean Smith-776614 (8/29/2013)


    Lesson is use the complete name. For example, rather than using "advanced options" use "show advanced options". If MS ever introduces "hide advanced options" then you may need...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

Viewing 15 posts - 166 through 180 (of 295 total)