Grant the Sales group permissions on that role in each database. B. Create an application role for each database. Grant the Sales group permissions in each database. C. Create a single application role, and grant it permissions in each database. D. Create an application role in each database, and grant it the appropriate permissions.
Branch offices report slow performance.
DB Admin is in the corporate office. A. Use SQL Profiler extended stored procedure and send them to the NT App log in the corporate office. B. Use SQL Profiler extended stored procedure and send them to the table in the corporate office. Carmen is member of the productgroup. In order to tighten Security on a SQL Server, remove NT Admin from default Membership.