Do I have to assign the Lock Pages in Memory privilege for Local System?

IMPORTANT: The following KB article adds support for Locked Pages to SQL Server Standard Edition http://support.microsoft.com/kb/970070 NOTE: I’ve updated this because of some questions about 32bit systems.  Some who attended one of my talks at the recent PASS conference asked me the following question “Do I need to use the Group Policy Editor to assign…


Database compatibility and new features

Have you attempted to execute queries using some of the new keywords and constructs only to see error messages like the following? Msg 321, Level 15, State 1, Line 5 “sql_handle” is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode…