Gpupdate /force
Source:
A Description of the Group Policy Update Utility
http://support.microsoft.com/kb/298444
Thursday, September 23, 2010
Policy: Default Domain Security vs Default Domain Controller Security
How does precedence work for the Default Domain Controller Security Settings vs the Default Domain Security Settings
http://serverfault.com/questions/82923/how-does-precedence-work-for-the-default-domain-controller-security-vs-the-defaul
Useful comment:
It's worth noting that domain password policy is controlled by the resultant set of policy of all GPOs at the root of the domain, and not just the contents of the "Default Domain Policy". I don't ever modify the "Default Domain Policy" or "Default Domain Controllers Policy" in the field. I always create additional GPOs to override these settings, such that I can always disable my GPOs and return Active Directory back to "stock" behaviour if I need to.
http://serverfault.com/questions/82923/how-does-precedence-work-for-the-default-domain-controller-security-vs-the-defaul
Useful comment:
It's worth noting that domain password policy is controlled by the resultant set of policy of all GPOs at the root of the domain, and not just the contents of the "Default Domain Policy". I don't ever modify the "Default Domain Policy" or "Default Domain Controllers Policy" in the field. I always create additional GPOs to override these settings, such that I can always disable my GPOs and return Active Directory back to "stock" behaviour if I need to.
Policy: Change when to prompt user for expiring password
Computer Configuration > Windows Settings > Security Settings > Local Policies >
Security Options > Interactive Logon: Prompt user to change ...
Security Options > Interactive Logon: Prompt user to change ...
Wednesday, September 22, 2010
MS Query: Incorrect syntax near keyword ...
FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS"
(http://support.microsoft.com/kb/273813)
Bottom line:
Problem occured because there's a column name that conflict with SQL keyword
Solution:
Exclude the column from query OR upgrade to latest MDAC
(http://support.microsoft.com/kb/273813)
Bottom line:
Problem occured because there's a column name that conflict with SQL keyword
Solution:
Exclude the column from query OR upgrade to latest MDAC
Tuesday, September 21, 2010
2007: Cannot subtotal data obtained from MS Query
You cannot do this because when you get data from an external source, the
output converts to a Table. Once of the limitations of a table is that you
cannot use Data > Subtotals. The only option is to convert the table to a
range (and then you will be able to use Data > Subtotals) but then you will
lose the data connection with the external data source.
(www.excelbanter.com/showthread.php?t=242276)
This happens when you convert the range to a Table (Ctrl+T or Ctrl+L). A Table cannot be subtotaled. To overcome this problem, try either of the following:
1. Convert the Table back to a Range - Click on any cell inside the Table and in Table Tools (Yellow button at the top) > Design > Tools > Convert to Range > Yes. Now you will be able to convert to a Range
2. Create a pivot table - If you want to let the Table remain, then just create a pivot table. Drag Part number and Description to the row area and quantity to the data area.
(www.merawindows.com/Forums/tabid/324/forumid/90/threadid/45543/scope/posts/Default.aspx)
Bottom line:
Copy then Paste Values to another worksheet
output converts to a Table. Once of the limitations of a table is that you
cannot use Data > Subtotals. The only option is to convert the table to a
range (and then you will be able to use Data > Subtotals) but then you will
lose the data connection with the external data source.
(www.excelbanter.com/showthread.php?t=242276)
This happens when you convert the range to a Table (Ctrl+T or Ctrl+L). A Table cannot be subtotaled. To overcome this problem, try either of the following:
1. Convert the Table back to a Range - Click on any cell inside the Table and in Table Tools (Yellow button at the top) > Design > Tools > Convert to Range > Yes. Now you will be able to convert to a Range
2. Create a pivot table - If you want to let the Table remain, then just create a pivot table. Drag Part number and Description to the row area and quantity to the data area.
(www.merawindows.com/Forums/tabid/324/forumid/90/threadid/45543/scope/posts/Default.aspx)
Bottom line:
Copy then Paste Values to another worksheet
Monday, August 30, 2010
Recommended settings for Processor Scheduling and Memory Usage
If it is a Citrix only server (as in doesn't provide other services such as Web Interface etc) - then certainly go with the "Programs" performance setting. "Programs" as you could imagine is intended for when interactive users are running programs on the system (which is exactly what TS users do), whereas "Background Services" is tuned more for running services such as SQL, AD, IIS etc.
When you select Background Services, higher priority is given to the operating system.
When you select Applications, higher priority is given to user mode programs.
(www.brianmadden.com/forums/t/11518.aspx)
When you select Background Services, higher priority is given to the operating system.
When you select Applications, higher priority is given to user mode programs.
(www.brianmadden.com/forums/t/11518.aspx)
Monday, August 23, 2010
Automatically insert one-time timestamp
Automatically insert timestamps in excel sheet using formulas
http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/
Section: Back to Generating Time Stamps
http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/
Section: Back to Generating Time Stamps
Subscribe to:
Posts (Atom)