When I create a temp table or other temp objects then when after writing Create Table #TableName line as a part of the statement I add on the next line: Drop...

Allen,

There are a lot of differences between EM and SSMS.

As for the maint plans, "remove files older then....days" is now replaced with Cleanup Task. Everyone here spent some time figuring...

Yes, you can start services on the different accounts in the Properties of SQL Server on the Security tab for SQL Server and in the properties of the Agent on...

Thank you! Thank you! Thank you!

If you would not write about it, maybe I would. We do have to be polite to each other, we do visit this forum to...

I think that thanking people if they reply to your question is a good manner as well as telling if your issue was resolved. If the replies did not clear...

"after all architecture skills don’t become outdated very quickly (if at all)" -

Simon,  this is not true. Each generation of the products brings its own new architecture. I passed  both...

Did you check the event logs like Application Log? it may have records that your log file could not be opened because it is used by another process. While I don't...

Yes. For example when you create a maintenance plan you should specify the number of records in sysdbmaintplan_history. The general settings for sysjobhistory are under Agent properties Job System tab.

Hi,

If it is a cluster, local groups can not be seen by SQL Server. I tried that. Use the Domain Global group instead.

Well, good point.

Correction to the joke: "Developer always think he is ahead...". Another line for him: "Developer comes to the place in his virtual reality..."

????? $$$$$ ?????

I am presenting YV-Cert. This certification will reflect how well the person can save money for himself and his company. I will post full requirements and prices when...

OK,

I correct my question, now it says: "How all 3 of them could meet at the same place at the same time?"

- the DBA comes on schedule

- the Developer is...

Steve,

This editorial on compliance that you mentioned was not yesterday, it was on 10/3/2006.... Time really is going fast.....

On a more professional note, don't forget your business process for...

How all 3 of them met in the same place anyway? They each belong to a different habitat.

Nad,

check if the account that is used to run the job has Delete right on the folder with the transaction log backups