logical.

the script should count the no of CPUs then allocate 80% of memory should be allocate to SQL Server.And min memory always should be 512MB.

Thanks Rade.

can you suggest popular quest-lightspeed forums.

we wanted to install litespeed on all the servers with automated way.

any suggessions pls.

thanks..

Thanks..

any suggession ?

thanks...

I tried to changed the sqlinstance name with below script but its not changing the sqlinstance name.if i select @@servername then its showing the changed name but it is showing...

just i need to run the automate script in one server at a time.

The script should take the comutername dynamically and addthe servername as "computername\inst" .

EXEC Sp_addserver 'computername\inst'...

i am trying to create .cmd files .

i got it...pls ignore..

Thanks.

Can you please provide the system tables\views which are related to lightspeed configuration entries.

we have so many new servers ,manual configuration is time taking , so we need a script .

sqlserver instance and lighspeed installed in a server.

I need a script that will configure lightspeed for that instance.

sa