Development Notes

Posted on May 13, 2007 by thekhuc

Problem: Drop Failed for User - Error MSSQLSERVER 15421 / The database principal owns a database role and cannot be dropped. Msg 15421.
Solution: http://blog.davestechshop.net/archive/2006/10/05/DropFailedForUserMsg15421.aspx
Problem: Why Don’t I See a Security Tab on the Properties dialog for My Files and Folders in Windows XP?
Solution: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=286

Filed under: ASP.NET 2.0, T-SQL, Tutorials and Tricks | No Comments »

What is a MS SQL Server Trigger?

Posted on March 28, 2006 by thekhuc

A trigger is an object contained within a SQL Server database that gets called each time a row in a table is INSERTED, DELETED, or UPDATED. It is used to execute a batch of SQL code whenever one of these SQL commands, INSERT, UPDATE, or DELETE, is executed against a specific table.
Trigger is stored in [...]

Filed under: T-SQL, Tutorials and Tricks | No Comments »