[highlight=#ffff11] i have had maintainance plan to shrink every night... is that good way to do it?[/highlight]

you can do it occasionally(not as a every night job, it is better to...

did u check with the query run in production machine?

can u give the system configuration.

HI Thanks for ur answer,

3. WOW will it automatically used? what are the benefits of WOW?

1.sql server 2005 32-bit installation on 64-bit o.s.How it will affect the AWE/PAE?

What are the...

hi,

thanks for Your clarification,

if my environment like windows server 2008 64-bit

...

hi,

It's more explanatory. Thanks a lot.

thanks,

i read but not carefully:

Now what i understood is--Please correct me if i'm wrong.

Ex:

1. If windows server is 32-bit then Virtual Address Space is 4GB(V.S.)

And RAM is <4GB...

thanks fro ur replay,

i have a doubt:

If production system is having 16GB RAM then is it required to AWE ON?

i.e., if my RAM SIZE IS GREATER THAN V.S. then only...

hi,

these are the error what i observed in error log,

SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL...

it was started(manually restarted the service), but why it was unexpectedly stopped.

thanks,

but all are well( as u said) , drivers memory is free, and tempdb in simple mode only,

hi,

i have tried as your said, but it is not working again permissions issue.

hi,

your right, it's not opening the network path. what i need to do for this issue?

we have to use the evalution edition only.

how can i get scripted all the logins andjobs.

which Service pack ur server has. check the link:

http://dotnetwebprogramming.blogspot.com/2009/02/severe-error-occurred-on-current.html

hi,

i've fts is enabled as :

changetracking is auto and bakcground. is still need to create a job to populate indexes.

thanks