July 21, 2001 at 2:19 pm
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
July 21, 2001 at 4:32 pm
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply