Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Worst Practices - Part 1 of a Very Long Series!

    my personal conventions...

    Tables:

    - Users

    - OrderDetail

    Columns:

    - FirstName

    - UnitPrice

    Sprocs:

    - sp_

    [action] e.g., sp_UsersInsert, sp_OrderDetailInsert

    (Reason: New databases don't contain sp_* sprocs, so why bother with usp_*?)

    T-SQL variables:

    - have to admit it, sometimes I go hungarian...

  • RE: Dump SQL Permissions

    I'm definitely gonna take a look at this, but I'm wondering...

    Can this tool (or another other tool/script/sproc) show a "last logged in" date?

    Always trying to determine if a particular user is...

Viewing 2 posts - 1 through 2 (of 2 total)