Andy, excuse my lack of knowledge on this one. I just saw that I had the group whose security i was checking under the role of DB-DDLADMIN, DB-DATAREADER, AND DB-DATAWRITER.

Once...

Andy,

Thank you so much for the info. I would assume if OVERRIDE is supposed to be used, the output would have stated that.When I run this in query analyzer, do...

Thank you so much, I not only increased the log file but the data file also needed to be increased. Also, thank you for the DBCC commands to do the...

HI. I would very much be interested in the dll. i have a feeling the developers are going to want to put application security.

And one of my questions was how...

Actually since then, i applied the MS02-38 and when i did the SELECT @@VERSION, i see the new version that goes with this fix. so i know i'm on target...

I think i've got the idea with the backups. So if i want to keep Mon thru Fri's backup each on a seperate file, would I be safe to store...

Can you explain to me what you refer to as "2 sets". and does that also mean you keep 2 sets of transaction logs to go with these full backups?...

Andy, thank you for the idea. I can see the individual records for the logins in sysxlogins but it just occurred to me at 4:00 AM this morning what the...