Please verify if 'platinum' and 'MELWEB\MEL-SV-SQL-WEB' has sufficient permission for step 1 (Subplan_1) in Maintenance job. For Example if it’s a backup job the user should be granted db_backupoperator role...

After uninstalling SQL Server please delete the SQL Server root folder and clean the registry with registry cleaning utilities. It should work.

Agree with Tomas but I wouldn’t just ask for what they have changed, I would also for backward compatibility of their own product. It really doesn’t make sense, every time...

robert.hall (5/4/2012)

---

I am having trouble getting my Maintenance Plans to work, the error is:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

05/04/2012 16:25:38,RDHtest.Subplan_1,Error,0,MELWEBDBS01,RDHtest.Subplan_1,(Job outcome),,The job failed. ...

I guess I know his answer... Google / SSC.

I assume you overlooked the Principle of Least Privileges. Now, the user has too much privilege than she should have and can peek into the data that she shouldn’t see.

You are just verifying the read performance & ignoring write performance. If it’s going to be OLTP transaction table, your DMLs would suffer. Plus, clustered index on 3 GUID columns...

i would say that you need to think about what will happen in thte future - while this system only really lists the names and addresses of students and employees,...

I too agree that nothing can substitute hands on experience on SQL Server. Please mind it, it need not be office / work experience. As stated above you can setup...

It’s an old thread. Please start a new thread for your question. Posting the questions in old thread fragments the responses.

Msg 1101, Level 17, State 10, Line 1

Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping...

Incidentally, a lot of the 'select distinct top 1000' statements mentioned above don't have any order by. Does that mean they would default to an index order if it existed?...

CAUTION: be careful and don’t try anything similar on PROD environment if you are unsure.

One clarification, before somebody misread Lynn’s suggestion as ‘buy more space and resolve the issue’. It just means remove unwanted files from tempdb drive and let SQL Server utilize it...

This is not a bug but the way it is designed. If user gets the role through a role the enumeration is possible at role not at user level.