Last modified date

  • graceb

    SSChasing Mays

    Points: 624

    How do I find out when the table or a database was last modified? I mostly

    want to find out if my user community

    is using the database still.

    The other question is when I tried

    to sp_addalias 'nhayner' , 'dbo' and got: User or role '\nhayner' already exists in the current database.

    I don't see nhayner in my database.

    My database was copied from another database.

    Please advice and copy me at gbarr@czn.com

    Thanks! Grace Barr

  • Andy Warren

    SSC Guru

    Points: 119676

    Hi Grace,

    I imagine you have an orphaned user - take a look at sp_changeuserslogin to see one way to fix it. Aliases are out dated - in 7.0 and higher you normally just use roles.

    To see if the db is still being used, one way would be to set it to dbo only and see if anyone complains! Another way would to use Profiler to trace activity related to that db.

    Also, there is a check box on the posting form where you can elect to be notified when someone replies to your post.

    Andy

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

You must be logged in to reply to this topic. Login to reply