well i'm assuming it works, i configured profiler to track SPs with recompile and this was one of the many SPs it picked up.

the stored proc with the script ex...

Excellent thanks

Thanks for your response, i was thinking some how that those report files are stored on the file system......

so lets say i'm installing SSRS on each instance in a cluster...

Thanks alot guys...appreciate it

LOL, please disregard....should have known this....just the i couldn't find the monthly option.

thanks

this worked............, i configured an alias using tcp\ip.

thanks

yes

no i haven't, but i can try

Thanks for the info george i'll start looking into this.

thanks again for the response.

(SQL coming to a Halt)>> Users complain of slow performances when this issue occurs and jobs timing out.

i also noticed this error in the event log:

Error...

The problem occured again this Morning.

I have been using the values from perfmon.........this time it is showing Total Memory at 1.5GB and Target mem at 1.5 GB.

as shown in the...

Thanks for ur reply..

i recently inherited this environment 5 months however they had this same prob then.

SP version>> SP4 8.00.2040

The PEA swith is set in the boot.ini file...

Just to follow-up guys trying to assing values to variables:

example:

set @quart = (select DATEPART(Quarter ,Date)) from @nums where Date = convert(varchar(50),getdate(), 103))

but gettin the following error

Msg 242, Level 16,...

excellent, thanks guys

thanks jerry