Will the below code run in sql server 2005 and 2008 ?
Issue with SQL Server 2008, and future products is known. The fix is to run:
CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS
The important point being that cannot add a "group" to a server role directly. You have to add a "login" for that "group". Then you can add that "login":