Well said Jeffrey. Agreed. That's what I mentioned in my previous post.

There is always a TSQL script task in the MP. This would allow to you do any SQL Server...

AWE is not required on 64-bit machines

Lock Pages in Memory is good setting to use.

Please check if you are experiencing any memory pressures due to the adhoc queries.

If you...

First of All , by recovering state I mean RECOVERY_PENDING

A...

All the solutions are really good but please consider the fact that the db is in recovering state...

I think you have these options,

1. Free up some space on D...

EXEC sp_updatestats gives more detailed messaging and also kind of how far the update completed as of now. But this updates all tables within a db.

On the Other Hand you...

I don't think Profiler can be used to veiw permissions.

Instead you can check who all has the execute permissions on the stored proc in the SSMS.

...

Trace Flag 1400 should be enabled only in you are using RTM edition of SQL Server 2005.

Starting from SP1 and above, Trace Flag needn't be enabled for the sake of...

HI Ben,

Please check the script from the following link...

This gives all the details about the...

Please check these roles in MSDB

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

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

Thank You,

Best Regards,

SQLBuddy

OPENROWSET and OPENDATASOURCE are used for accessing remote OLEDB resources. They should be used only if they are accessing the remote OLEDB resources infrequently.

If you are frequently accessing remote...

Please try this. This is just a basic definition

Use <Db_name>

Go

CREATE CLUSTERED INDEX CIX_Job_Id_Property_id

ON [dbo].[Valuation_Common]( job_id, property_id);

GO

Thank...

Well, I wouldn't know because I will never schedule a shrink database task or put that in a maintenance plan of any kind. I wouldn't even put it in an...

Shrink Database Task doesn't have the reorganize option avialable in SSMS and TSQL. It has only TRUNCATE ONLY and NO TRUNCATE options.

...

There is always a TSQL script task in the MP. This would allow to you do any SQL Server Tasks that could be accomplished using TSQL Scripts.

...

There is no way in which we can say that when the index fragmentation will reach 50%. It all depends on the activity going on the table.

But a good practise...