Database

use tempdb
Declare @userName char(100)
Declare @DatabaseUserID [smallint]

--internal sql user name or domain\username
Set @userName = 'InternalUser'
select @DatabaseUserID = [sysusers].[uid] from sysusers where name = @userName
IF @DatabaseUserID IS NULL
BEGIN
EXEC sp_grantdbaccess @userName
EXEC [sp_addrolemember]
	@rolename = 'db_datareader',
	@membername = @userName
EXEC [sp_addrolemember]
	@rolename = 'db_datawriter',
	@membername = @userName
END

create trigger empCopyTrig on emp
for Update
as
insert into empc Select * from deleted
Go

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!