Viewing 3 posts - 1 through 3 (of 3 total)
Basically: Create a new role in MSDB, set permissions for that role, modify existing sysjobs_view to include the new role, and add the user to the MSDB role.
Script to use...
June 27, 2006 at 5:36 am
Or, simply put the line below in a batch file:
isql /U sql_username /P sql_password /S servername /i k:\filename.sql /o k:\logfile.log
And put yout T-SQL commands in the filename.sql file.
June 27, 2006 at 5:18 am
Had the same problem, resizing did help for a while (frequency between the errors increased).
Take a look at MS KB article 909369.
http://support.microsoft.com/kb/909369
I have just implemented it on a testserver,...
June 23, 2006 at 5:06 am
Viewing 3 posts - 1 through 3 (of 3 total)