Hi

It depends on the level of read/writes/inserts/deletes, this needs to be balanced, obviously different tables will differ, Generally what i look at is:

Read only intensive only tables: 90% + Fillfactor

Updates & Reads:...

Thanks for the reply

This is a problem I hope can be fixed with the new SQL 2008, I understand the need to lock things down, but another role that...

Hi

I want the non-SA users to be able to do the following:

Edit a job which they dont own

Change the schedule i.e the time

Disable/Enable

I look forward to hearing from you. 

I have looked at this (SQLAgentOperatorRole), and it still doesnt solve my problem at all. Non SA users still cant control jobs they dont own.

Hi

When it comes to editing it, thats where the problem is.

What if i dont want people to edit the package from the server, cant that be done remotely?

Hi

Thanks for the reply.

Problem is that they might need other things as well, at the moment the job activity monitor doesnt even work, i.e it doesnt show the status of jobs,...

Hi

Network backups will always fail after it reaches around 30% or so, the fact is that you cannot backup to a network share

You will need a local drive/NAS/SAN to...

Just wanted to know if anyone has got a solution for me ?

I am having the problem now and again:

This time, it appears its a backgroud process blocking my query:

SET STATISTICS XML OFF

Thats all I see after running dbcc inputbuffer(51)

Hi

Do you know if Opalis is a free tool, it would be difficult to convince people to invest in such a software just for scheduling jobs.

your views ?

Hi

I have checked and all indexes, and they all seem to be set to "ONLINE = OFF" 

Do you reckon that all indexes be set = ON to stop this problem...

Hello

Do you know if SP2 has addressed this problem?

Thanks

Hi

I already had a look at the website, and as you rightly said users can only edit/manage jobs they own, the problem is that...

Just out of curiosity, is there any other way of ordering data Desc without specifying Desc in the code ?

That is exactly what I have (i.e S.procedure and not code directly to users, I only placed the code here to that we can all see whats running at the...