Thanks, i know some how forgot while implementing it (stupid in that way).

good for showing a good route to write code as well.

server is a virtual server

if i use AWE max memory will it set for reporting services as well or it will be different as the services are different.

thanks

the server is 32bit, win 2003, with 2 processor and 8 GB RAM and a virtual one.

as you said with some OS settings AWE will help can you share that...

kindly check the login whether it is locked or password expired (if it is domain account).

thanks, i have tried to download it is working it a awesome way

need to try about permission.

GSquared (4/5/2012)

The whole point of a heap vs a clustered index is that fragmentation doesn't matter in a heap. They don't have a defined storage sequence (well, behind the...

is it a free tool, can we use it for giving access as well.

viking can you help in setting up that.

if any doc anything available kindly share it.

as mentioned earlier we have so many folders is there a short way to complete this.

Hello,

we are using domain accounts.

we have configured Content Manager to the user on top folder still he cant able to see most of the sub folders.

new folders and reports are...

No special reasons.

can you elobrate what is the effects of AWE and is there any negative impact?.

will server restart or service restart is needed?.

i have rough idea as it will...

Hello,

Post the exact SQL code which you are using.

use this to fetch DB Names

Select name from sys.databases

where name like 'xx%'

and run your view or procedures using "use DBNAME and query".

can we know what are you trying to do...

hello,

2 CPU and 8 GB RAM.

AWE is not enabled currently, can i know what will it do?

32 bit ,no changes, hardware changes like disk size may be.