Sorry, after i re-read my post I realized it wasn't very clear.

The Stored Procedure would need WITH EXECUTE AS SOME_USER where SOME_USER has the necessary level of access to...

You could create a stored procedure that executes the specific job with sp_start_job. If you add 'WITH EXECUTE AS YOUR_JOB_OWNER' to the stored procedure then the users will not need...

SQLCrazyCertified (6/17/2013)

Thanks, J Good.

Is this script good for SQL 2005?

I am getting the error when I run on 2005...but it worked on 2008 and above.

Msg 208, Level 16, State 1,...

Times are in microseconds.

SELECT TOP (250) p.NAME AS [SP Name]

,qs.execution_count

,ISNULL(qs.execution_count / DATEDIFF(Second, qs.cached_time, GETDATE()), 0) AS [Calls/Second]

,qs.total_worker_time / qs.execution_count AS [AvgWorkerTime]

,qs.total_worker_time AS [TotalWorkerTime]

,qs.total_elapsed_time

,qs.total_elapsed_time / qs.execution_count AS [avg_elapsed_time]

,qs.cached_time

FROM sys.procedures AS p...

Sounds like some try...catch error handling might do the trick.

Check out this link:

http://msdn.microsoft.com/en-us/library/ms175976.aspx

You are correct. Thanks...

Yes, the above query will...

This script will look at sys.dm_db_index_usage_stats to determine the last reads/writes that occurred on a table; however, this DMV is reset when SQL is restarted, so be aware of that.

WITH...

You can schedule a job that runs Monday morning at a certain time and runs the following:

You can use this query to get a list of the currently executing job...

This script has always done the trick for me. It scripts out DB users, roles, object level permissions, and schema level permissions. It works on 2005 and 2008R2, but have...

Paul Randal had a good, quick article on this for SQLMag...

http://sqlmag.com/blog/rebalancing-data-across-files-filegroup

You can always wrap your statement inside of a BEGIN TRAN and ROLLBACK and check sys.dm_tran_locks to see what locks it will take.

I ran a quick test using this example...

You can grant select access to only the sysjobschedules table like this:

--Create user on msdb for a server login 'testUSER'

--This is assuming you already have the testUSER login created on...

I believe Redgate has a product called SQL Doc that is supposed to be pretty good.

There are also a ton of T-SQL scripts out there that can help you do...

I wouldn't look at the Date Modified of the .mdf or .ndf files.

You might try something like this that will show you when the tables in the database were last...