Hi,
our company has in-house application ("IDT") working with SQL 2000 database.
We use windows authentification.
I need to stop staff from accessing SQL server via any others applications (such as Query Analyser, Enterprise Manager or Excel).

As I understand the Application role of SQL server should help, but I dont undestand how to implement it.

Please,
Help!!!

The information within this e-mail is confidential and intended solely for the use of the recipient(s). If you are not the intended recipient then please notify Natalia Brett via email at Natalia.[Email address protected] or by telephone on +44(0)1244 319912. Then delete the email from your system. Please do not read, copy, print, forward, disclose, or use the information contained within this email. Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Aktiv Kapital. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

Aktiv Kapital (UK) Ltd
Merchants House
Hamilton Place
Chester
CH12BE
UK
www.AktivKapital.co.uk


MS Sql Server LazyDBA home page