Shahab,

Can you confirm if you have configured your maintenance plan to write report to a text file in directory?

If yes, then that file will give you precise information on...

Greg,

The link below might be of some help to understand the notification sent to you by the Resource Monitor.

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

If I am not wrong, I think the notification is...

Jacques,

With reference to your statement about the error messages being the same in both Job history and SQL Server logs, its the default nature of SQL Server to have similar...

Thank you very much for trying the solution. Very happy that I could be of some help.

Good Day to you too!

It exists in each of the databases for which you would like the list. For Eg: If you want the list of users in master database, select Master and give...

We can get the list of users from sys.database_principals. If you want to list only SQL_USER then you can specify type_desc='SQL_USER' in the where clause. If you do not specify...

From your response I think we can eliminate any possible executing of create index or reindex commands on the database.

Can you let me know which SP do you have...

Giovanni,

I think two different operations on the same database are happening at the same time. For eg: you are executing an Alter Database statement to add a file or trying...

This is my first post here. Yesterday I restored a database that was 86GB in size. It took me precisely 46:20 minutes. It was a simple restore using EM. I checked the...

Darren,

Thanks, I did try Suggestion Wizard and the question 'What servers are like microsoft'. It does not understand it. If I ask the EQ 'show osnames that have platform' it...