but before that i want to know how to give "View definition" rights to ROLE...

There are below permissions i have found in stored procedure for the user(login):

Alter

Control

Execute

Take ownership

View definition

When I have given "View definition" permission to a login, he was able to see the...

Is ther any way i can add all the stored procedure of database into the ROLE - in one go?

Do you have any idea or any good link which will help to create such type of ROLEs, i have never worked on ROLES.

isn’t it a good idea to create a role instead of give permission on each object, because if another user comes with the same requirement, i m goona add him...

its failing with below error::

Msg 17, Level 16, State 1, Line 1

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

few more concerns after reading above 🙂

Truncate Transaction Log will truncate the inactive transactions in your transaction log and shrink the transaction log file, but this will not reduce the...

[font="Verdana"]Steve, First of all thanks a lot for this excellent explanation.

As per my understanding log file contains uncommitted transactions only, the transaction which is already committed has gone to datafile?

Now...

Thanks Mani.....

But for the other system tables in the master database (such as syslogins and sysdatabases), it's impossible to create triggers, so we should take another approach.

So wts the other...

According to me it always depends on size/no of databases hosted on the box. Data flow, I/O, no of users etc etc. in this case if your server is having...

Could you let me know in details how to use that DDL triggers, and would it generate alerts so that i can triggered mails using operator.