The GRANT statement should be as follows;

GRANT EXECUTE ON TO db_execute

sys.sysusers

sys.syslogins

If you use the script under the correct DB it should return all the sps which do not have EXECUTE permission.

If you know the trouble making sp, use the...

Not necessarily. Once you get the error, your application will stop at that point thus you can refer the profiler output to see that last entry. (assuming unwanted entries will...

Your correct. You can use the profiler for this case. Catch the below events and columns.

Events

RPC: Completed

SQL: Batch Complete

Columns

TextData

Any other columns would you think is necessary.

Apply some filters so that...

Make following things;

1.The particular users are belongs to the db_execute role.

2.The sprocs are given the EXECUTE permission for db_execute role. You can use the below script to see list of...

Lets assume if you want to check whether any of the columns 2,3,4 or all the columns have been updated or not. Then use the following IF condition

IF (COLUMNS_UPDATED() &...

If the SQL BROWSER service is started you can connect to the server by refering server name and the instance name. Otherwise you have to specify the port#.

In this case,...

Hope this will helpful for you to find a better solution.

Use COLUMNS_UPDATED() to check whether perticular column has updated or not.

You can use ‘deleted’ virtual table to capture old...

In case if your using SQL Server 2005, use sys.sql_dependencies.

Remember, there are some situations you will not find dependies recorded in the system view. Specially when you rename an...

This is a more generic question.

You need to make sure every db portion that pushes to production will be performed as intended. This is where the performance tuning comes into...

What is the version of your master database? I mean, is it the same database that you use in SQL Server 2000? Because all your earlier logins are stored in...

You can use SQL Server Integration Services also to read access data.

ALTER DATABASE JeanAnnTest

ADD FILEGROUP JA_FG;

ALTER DATABASE JeanAnnTest

ADD FILE

(

NAME = JeanAnn2,

FILENAME = 'c:\MSSQL\JeanAnnTestNewFilegroup777.ndf',

SIZE = 6MB,

MAXSIZE = 18MB,

FILEGROWTH = 1

)

TO FILEGROUP JA_FG;