Thank you Allen.

Thanks for your help Shas!

I get the 5M available memory from the Task Manager window, Performance tab. Under Physical Memory, the Available value is around 5M. Thanks.

Hi Allen, no other applications are on this server. Only the bare bones of Win 2000 and sql server. When I add up the memory usage, I get...

Hi there, I ran the dbcc shrinkfile which ran successfuly. The alter database command failed saying that the file cannot be dropped as it is not empty. What...

THANK YOU!!!

Thanks a lot for your help guys. I have given the role to the user and now he is able to see the jobs. What gets me is...

I have users with less privilages who can see the jobs. This is really bugging me, please help. Thank you.

Thank you for the alter database hint, that is exactly what I needed. Before I delete the file (big step), I want to get the gurus' opinion, if I...

I just read in the BOL that the execute permissions on jobs default to public. However, my user is not able to see the jobs at all. What...

Hi mr, what you are suggesting is the way things are already set up. The problem is, I have another user with the same permissions and he is able...

I am not sure what a wrapper sp is.

The xp_cmdshell is in a stored procedure that is being called from a parent sp. But when he runs...

Hi Allen, the username is in the logins and has "System Administrator" role assigned to it. I am not sure how to give it 'sa' rights. Can you...

This is the error I get when I try to start sql server agent:

"Could not start the SqlServerAgent on Local Computer.

The service did not return an error. This could...

Hi Allen, the service is run under a domain account. Its a sql server 7. The BUILTIN\Adminstrators has been removed by the previous DBA.

The Sql Agent error log...