You may need to dig in the registry, if it is rememebring anything it is most likely tin there. Personally if I could do it I would wipe the server...

I don't think that is the case if you drop an account in NT. Also I believe if these are NT accounts you can turn auditing on to see when...

Actually I did it backwards I was giving you mm/dd/yyyy Jim is right except change to CONVERT(VARCHAR,FLD,103) 3 gives yy and 103 gives yyyy is the only difference. My bad...

You are running the SP under an account wit Admin privledges for Win2K right?

It if the field is datetime you may be able to do CONVERT(VARCHAR,FLD,101) to get it to work. Otherwise if the language setting doesn't help you may have to parse...

I looked at all the sys tables. There is no last login that I can find. I would suggest an outside app, or trigger or so kind of internal job...

Here is what I sent to Microsoft. Someone else may want to do something similar just to see if they will answer or make a change in this.

In SQL 7...

You got that right. I just love people who don't test anything before they use it somewhere they souldn't.

D*$% Sorry about that, guess you really should only be doing 1 thing at a time to avoid mistakes.

But deny would be taking the check box out, revoke is an X ad grant is a check. You could create a role with REVOKE on those tables and put...

Sorry I made an error in my statement. All databases have Public with select rights from the begining but the user can only access those of the DB they are...

For some, even some in the master database are granted selected access whether or not you gave them. Until you asked I did not even realize this and see that...

Hey anybody seen this. Another poke at Microsoft http://zdnet.com.com/2100-1105-837426.html

Or you suffer from numerous ID10T errors throughout the day.

Yes.