This download comes as a pre-configured VHD. This download enables testing of application designs on the Windows Server Platform.

Default password: pass2word1

--Script created by Vyas
--http://vyaskn.tripod.com

SET NOCOUNT ON

DECLARE @OldUser sysname, @NewUser sysname

SET @OldUser = 'HRUser'
SET @NewUser = 'PersonnelAdmin'

SELECT 'USE' + SPACE(1) + QUOTENAME(DB_NAME()) AS '--Database Context'

SELECT '--Cloning permissions from' + SPACE(1) + QUOTENAME(@OldUser) + SPACE(1) + 'to' + SPACE(1) + QUOTENAME(@NewUser) AS '--Comment'

SELECT 'EXEC sp_addrolemember @rolename ='

• SPACE(1) + QUOTENAME(USER_NAME(rm.role_principal_id), '''') + ', @membername =' + SPACE(1) + QUOTENAME(@NewUser, '''') AS '--Role Memberships'
  FROM sys.database_role_members AS rm
  WHERE USER_NAME(rm.member_principal_id) = @OldUser
  ORDER BY rm.role_principal_id ASC

SELECT CASE WHEN perm.state <> 'W' THEN perm.state_desc ELSE 'GRANT' END

• SPACE(1) + perm.permission_name + SPACE(1) + 'ON ' + QUOTENAME(USER_NAME(obj.schema_id)) + '.' + QUOTENAME(obj.name)
• CASE WHEN cl.column_id IS NULL THEN SPACE(0) ELSE '(' + QUOTENAME(cl.name) + ')' END
• SPACE(1) + 'TO' + SPACE(1) + QUOTENAME(@NewUser) COLLATE database_default
• CASE WHEN perm.state <> 'W' THEN SPACE(0) ELSE SPACE(1) + 'WITH GRANT OPTION' END AS '--Object Level Permissions'
  FROM sys.database_permissions AS perm
  INNER JOIN
  sys.objects AS obj
  ON perm.major_id = obj.[object_id]
  INNER JOIN
  sys.database_principals AS usr
  ON perm.grantee_principal_id = usr.principal_id
  LEFT JOIN
  sys.columns AS cl
  ON cl.column_id = perm.minor_id AND cl.[object_id] = perm.major_id
  WHERE usr.name = @OldUser
  ORDER BY perm.permission_name ASC, perm.state_desc ASC

SELECT CASE WHEN perm.state <> 'W' THEN perm.state_desc ELSE 'GRANT' END

• SPACE(1) + perm.permission_name + SPACE(1)
• SPACE(1) + 'TO' + SPACE(1) + QUOTENAME(@NewUser) COLLATE database_default
• CASE WHEN perm.state <> 'W' THEN SPACE(0) ELSE SPACE(1) + 'WITH GRANT OPTION' END AS '--Database Level Permissions'
  FROM sys.database_permissions AS perm
  INNER JOIN
  sys.database_principals AS usr
  ON perm.grantee_principal_id = usr.principal_id
  WHERE usr.name = @OldUser
  AND perm.major_id = 0
  ORDER BY perm.permission_name ASC, perm.state_desc ASC

VHD Test Drive Evaluation Package:

Windows Server 2008 R1 Enterprise (x64) Server Full Installation + SQL Server 2008

VHD Test Drive Overview

This image is provided through the Microsoft VHD Test Drive Program. The intent of this program is to provide customers with fully configured virtual machines for the purpose of test, evaluation, demonstration, training & education and proof of concept. VHD Test Drive images may contain software from Microsoft and Microsoft partners. This image is part of a library and program that is expanding rapidly. Partners are encouraged to write VHDINFO@microsoft.com with regard to questions, issues and desired images.

Use the following information to log on to Microsoft Windows contained within the virtual machine

· Username: Administrator
· Password: pass@word1

Vous voulez construire une application web réussie ? Alors il est temps de Get Real. Getting Real est une manière de construire plus simplement, plus rapidement et mieux un logiciel.

Want to build a successful web app? Then it's time to Get Real. Getting Real is a smaller, faster, better way to build software.

eng
http://gettingreal.37signals.com/toc.php

por
http://gettingreal.37signals.com/GR_por.php