% of create,update and terminate acct.. in methodtypecolumn...

did u run the create table and insert data script...

i also dont know but we need how many % create acct,updateacct,terminateacct also..based on...

This are table script and sample data..pls run this and then run the query given b4...

I want to modify query to get result set of % of createaccount, %of terminateaccount,and...

% of errorcount...so need 3 more column...

EG.. i want error count for today mean wed,tue mean yesterday and total errorcount from wed(today) till last wed...

hi..what if i dont have enough disk space on that domain?

yes how can i monitor 1 server from another in the same domain?

i want an email alert to operator...

no i did not setup dbmail, i setup only operator notification..in my testing machine it works fine after restart of sql server agent..but in other server does it req. or...

ok i got the answer ; but does it req. to restart sql server agent?

between email addresses i have to put ; or , ?

for that do i need to setup database mail profile or not?

thanks,,

sir i want the script very simple way like it give me the result like this:

database name total allocated size for db ...