SQL Server 2005 SP2. Israeli SQL Server User Group March 2005 Ami Levin firstname.lastname@example.org. Redistribution of bugs. http://support.microsoft.com/default.aspx?scid=kb;en-us;921896 About 140 confirmed bugs fixed Most of them are concerned with AS.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Israeli SQL Server User Group
* Important note!
CREATE LOGIN login_test
WITH PASSWORD = '3KHJ6dhx(0xVYsdf'
GRANT VIEW SERVER STATE TO login_test;
CREATE TRIGGER connection_limit_trigger
ON ALL SERVER WITH EXECUTE AS 'login_test'
FOR LOGON AS
IF ORIGINAL_LOGIN()= 'login_test'
AND (SELECT COUNT(*) FROM sys.dm_exec_sessions WHERE is_user_process = 1 AND original_login_name = 'login_test') > 3 ROLLBACK;