i actually have created a new credential and created a new proxy so that the sql agent can use that proxy ... but i cant understand how to use that...

yup .... got it , thanks

regards

greg

select accountbranchnumber,accountnumber,accounttype,currentbalance,

postdatedimkey,monthname,condensecodedesc,statementdesc,branchname,accounttypedesc,groupname,

division from MM_EOMRetail

where

accountbranchnumber = 230 and accounttype = 'd'

order by division, groupname,accountbranchnumber,postdatedimkey

thanks

regards

greg

i cant make any attachments .....the comp wont allow me , i actually checked the query in the MSSMS it fast ... it hardly takes like a second to exec...

the indexes i have created is like this

CREATE NONCLUSTERED INDEX [MyTableIndex] ON [dbo].[MM_EOMRetail]

(

[accountbranchnumber ]...

hi ,

well i have created nonclustered indexes on the the colums thats used in where and group by claus

but the seems to be having no improvements in reports...

how would i know if the agent has the acess to the folder path ?

OK will do thanks , i have another question , its in SSIS , i have actually posted the issue ,

i dont know if you had a chance of looking...

Thanks for the suggestions guys , i actually ran the query in database engine tuning advisor

and it gave me some recomandations , i have to create some indexes and...

so when you talk of rendering the report .....do you think i should work on report caching ...and the data is not updated in the tables like till the end...

just checked the execution plan and it seems like "clusterd index scan cost = 0%" and "table scan is 94%"