Ok, so basically most of the "security" is done via Active Directory...adding users to the specific groups. Then in SQL Server, I just add users to the groups? So I...

Found the HostName in SQL Profile, trace running on user pc's only. So going forward this is great, pitty can get a history cos I know the date we lost...

Kewl, will take a look, thanks for the info!

Thanks, that works. How to get that info somewhere when a user logs in to the sql server management console is what Im looking for. Any ideas?

Thank you! Will take a look 😀

Hi!

Thanks for the quick reply. A table has missing information, and it seems someone updated information on the table and deleted information. The only way this could have happened....is via...

Hi,

Thanks for the feedback, but thats part of the issue Im having in a way. I would have to go through each table and field name, to link them. Is...

Ok great, gonna give that a try then and see how it goes 😉

Thanks for the reply, and I see your point. I think that makes sense though....the databases are not super busy. So then maybe scrap the Diff backups and do full...

Hi Chris,

Thanks for the reply. No...I dont imagine it will grow much bigger than a gig a year.

Thought doing Diff backups each night is better in terms of disk...