Hi Rasmus,

it is possibly to simplify your script up to one select statement ;-):

SELECT 'EXEC sp_addsrvrolemember '''+pr.name+''', '''+pm.name+''''

FROM sys.server_role_members AS rm

JOIN sys.server_principals AS pm ON rm.role_principal_id=pm.principal_id

JOIN sys.server_principals AS pr...

Juts wanted to add my comment about the physical order of rows in table.

In case when clustered index defined on table they are in "physical order" (as per BooksOnline), and...

Good question. The only place where I disagree with author is location of clustered index columns inside the non-clustered indexes. They are located in leaf pages not in index (B-tree)...

Thanks SSC Veteran, a very useful script! However this script do not save all information about the table. The missing parts are triggers and extended properties (MS_Description for instance). If...