2D Game with Unity 3D

Short tutorial for building 2D game on Unity 3D, click here to download

Add role member using tsql in mssql 2000

EXEC sp_grantdbaccess 'jeff', 'jeff'
EXEC sp_addrolemember 'Sales_Managers', 'Jeff'

Get User Member from Spesified Role using T-SQL

declare @uidrole as int
declare @rolename varchar(20)
set @rolename='role_name'
select @uidrole=uid from dbo.sysusers where name =@rolename
select * from dbo.sysusers where gid=@uidrole

Grant non sa user to create function on mssql 2008 r2

GRANT ALTER ON SCHEMA::dbo TO user_biasa

Restore BAK file on MSSQL 2008 R2

alter database db1
set single_user with
rollback immediate
restore database db1
from disk ='d:\db_backup_2012_11_20_235900_7740000.bak'
with move 'db_data' to 'i:\db.mdf',
move 'db_log' to 'i:\db_log.mdf',
replace