THX.

THX.

so if i understand right if i have 32BIT system with 4GB box mem only enable the /3GB switch?

if i only enable the /3GB switch on 32BIT with 4GB mem...

Hi,

the max/min server memory on the SQL was not set(is the default).

the AWE is not set beacuse this is DEV edtion in 64BIT system.

all my SQL servers that i'm responsible...

in Perfmon i can't tell the alert if cpu stay over XX% more then 1min or so.

ok i found script that use the DAC connection to decrypt SP and it's works great.

THX

the tools cost money.i try the script that i found in google but all they does is to delete the SP that i want to decrypt.

can you point me to...

i lost my source code to a few encrypted SP

Thx.

are you sure that rebuild index do what update statics and reorganized index do?

THX

ok it's working.

now for the final phase,how in this script i can pass the variable for the all users in the "SELECT loginname FROM master.dbo.syslogins"

THX

it's working,but the username variable isn't passing.why?

when i copy the script as is, i get

Msg 102, Level 15, State 1, Line 10

Incorrect syntax near '+'.

this script isn't working.

can any one help me with my script or how i can insert the exec code into the sp_MSforeachdb?

Thx