durai nagarajan (3/2/2012)

---

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...

The backup of the certificate will be encrypted so this should afford some protection, but as Steve said careful here who you provide access to!

anand_vanam (3/1/2012)

---

the reason for this issue;...

Can you post the script

yes, you're starting the service thats why. I prefer to run the exe directly by changing to the Bin path for the instance i wish to start and then executing...

how many cpus how much RAM?

yes you can upgrade individual instances, if you run the GUI version of the service pack you will see the appropriate checkboxes for each instance. If patching from the command...

you are trying to start the instance from the system32 directory, you need to change directory to the correct bin location path before issuing the start command!

na1774 (2/28/2012)

---

Hi Everyone,

I am trying to move my DB data files into different drive. I used Alter DB and Modify File Commands. But After I changed the Location of File....

YaHozna (2/29/2012)

---

Hi, hoping to get some advice on an 'issue' I'm currently facing with regard to memory usage.

Quick bit of background would probably help. My company has recently implemented a...

you've just slapped the hand cuffs on every query executing on the server!

As Gail said, find out why...

full machine backup and subsequent restore to the physical box would be my chosen avenue

dunne.neal (2/28/2012)

---

Hi

I am having problems connecting to a local instance of sqlexpress.

ive tried (local)\sqlexpress but i get the error saying that the server cant be found

i click on browse...

does the computer account for server A definitely have delegation enabled

edit...

Not if they're in an environment that is segregated from the public network,...