I am not sue if that really gets you any thing other then an Alias. If you look at current activity after logging in it always shows the login name...

Brandie there is two parts to Veritas. The first is backup exec which backs up the OS and files and folders. The mdf and ldf...

Brandie I am not sure what your are saying. Veritas would not be able to restore data files because they can not just be backed up like a flat file...

Yes that is correct. You also said about the other department does the restores brings up other issues like security. No one other then the DBA’s should be able to...

If you are using Veritas, Netbackup  is the SQL  piece to be able to do the database backups and restores. SQL server will know of...

In 2005 you can just do this on the storedprocedures you want them to view.

use

[AdventureWorks]

GO

GRANT

VIEW DEFINITION ON

If you are trying to configure Reporting Services then go to your start menu, programs Microsoft sql server, configuration tools. It will be there. If...

Since you are running this through an application another possibility is for you to use an application role in the security database. Then it will...

They will only be sysadmin in sql if the Builtin\Administrators login is there. This usually goes against best practices having this login there though.

Why don’t you just create a database role in the security database, just give select permissions to the table or columns that you need to...

If you add the application user to the database that you wish it to be able to access and just grant the permission to the tables it need to access...

Here is a link to some documents on the subject that should help.

http://www.microsoft.com/technet/prodtechnol/sql/2005/library/security.mspx

If you make use of database roles and have your stored procedures owned by the role you can get away with just giving create stored procedure permission.

I aggree give them only the access they need. With the least amount of privileges needed to do what they were contracted for.

If you want to get the DDL for objects in query Analyzer right click on the object then select script objet to new window as create you will get the...