Also I have issues with my CPU usage. most of the time in peak hours my CPU usage is 100%, i get frudatrated seeing that every time. Ofcourse there will...

I have just one instance on each box and the min memory is 0 , max is 18432 and 1024 for each query.

do you thinnk its good?

Still getting this error, i have no clue where to look into to fix this problem.

I see this message in the job step log file

Msg 15274, Sev 16, State 1,...

yes its a domain account. is there any way i can check without network admin

What can we expect to be changed by him?

Here State\Rev_IT' is the sql agent service account.

thanks

declare @dbname as varchar(80)

declare @msgdb as varchar(80)

declare @dbbkpname as varchar(80)

declare @datepart as char(1)

declare rs_cursor CURSOR for select name from master.dbo.sysdatabases where (name like 'STATE_%' and name not like 'STATE_CO%') or...

I see trace files only for past 2 days in the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG and i havea total of 4 files for 2 days each of size 20480...

Jeffery

I am haveing Enterprise on one of my server and would like to do ONLINE indexes and ofcourse i like your logic.

1) Any tables larger than 1000 pages (if less,...

Yes I get this message when i run it as query but not as job. since the job got failed i re ran it...

I am runnning this procedure on the same database, it is still running and now how cud i find out which indexes are rebuild and which are yet to be...

I am looking to check the status of my job step. one of the step in hte job is running for severeal hours. How can i check how much %...

But with that i dont see any % of completion of my Job.

YES. I just ran this it worked fine to me.

1./* CREATE A NEW ROLE */

CREATE ROLE db_executor

2. /* GRANT EXECUTE TO THE ROLE */

GRANT EXECUTE TO db_executor

olichap

Can you please share that job with me, I am looking for something similar.

thanks

Markus

Is it a free tool DDL Audit Sample Applications (1.0.0.0)?

How safe it is to run on production systems and how much does it cost?