:w00t: They right Victor, I passed the edition. It does not have anything to do with Windows, is a SQL stuff. In order to see more memory, you need to...

:hehe: If the upgrade is in-place that is correct. The 3GB flag needs to be researched first for your environment. I do not have that flag set and I have...

:w00t:Yes, if you use 2005, there is a flag in the server configuration that you set this AWE. No reconfigure needs to be run. Just to make sure it takes...

:hehe:Thank you and please disregard the question. My bad, I had user selected to run the search. As soon as I added groups to the search I was able to...

Hello, the first thing we need to do for AWE enable is to run sp_configure and enable advance Options to see AWE, then enable AWE and then set the amount...

Sorry, no. The service pack is intelligent enough to bring down the services on both nodes. I run into the same issue and there was no other option but scheduled...

OK, One of the reboot does with tempdb is, even if you shrinked and it does not reflect the shrinkage, is to regain the space not used. That way we...

:w00t: Just a crazy question, how often do you reboot the box? maintenance or otherwise? I agree with moving the location won't a lot. I had kind of a similar...

:w00t: Totally agree, We reboot our servers every now and then for many reason, patches, etc. Once we had a guy who, with his best intention. Reboot the server without...

First of all, let me strongly prevent you to grant execute permissions to that to anyone without explicit need to run it. Reasons? To mention just one, the user must...

Thanks. I will use DBCC and then shrink it a normal size. :w00t:

Thanks.

Log reader is running fine. I just stareted with this company and inherited a spaghetti soup. No consistency on configuration, backups are all over the place, some databases are...

Yes, you can. Enable replication at the server you are going to use as central processing. Your publications will be created in the servers with the databases to be...

Thank you for your input. Here is what I have so far.

No longer available until SP2 -- I do have SP 2 I am assuming I have to...

Yes. If I script the objects I get the permissions for each object. The issue I am experiencing is when I script the users to get like

sp_addrolemember scripting