An administrators prank - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

An administrators prank

Author

Topic

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2001-04-25 : 15:25:25

Has anyone ever did this to one of the users or developers?

CREATE TRIGGER trgAgencyUpdt
ON Agency
FOR UPDATE
AS
if (select spid from master..sysprocesses where loginame = 'bethv') = @@SPID
begin
print 'Warning SQL Server has detected insufficient resources in front of the keyboard. Please replace the user and try again.'
rollback
end

I think it would be funny... but those darn "dont do this in the work place" thoughts get in the way. hehe

Daniel
SQL Server DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources