Query to find the list of Triggers in the database categorized with Trigger Type SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S1.deltrig > 0 THEN ‘Delete’ WHEN S1.instrig > 0 THEN ‘Insert’ WHEN S1.updtrig > 0 THEN ‘Update’ END ‘TriggerType’ FROM sysobjects S1 JOIN sysobjects S2 ON S1.parent_obj = S2.[id] WHERE S1.xtype=’TR’
Archive for February, 2010
Following code can be used to validate a credit card number and to get the card brand by card number: /// /// Enum for card type. /// public enum CardType { MasterCard = 1, BankCard = 2, Visa = 3, AmericanExpress = 4, Discover = 5, DinersClub = 6, JCB = 7, unKnown = 8 [...]
VS command prompt >aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 ed -d gamepoint2 >aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 -d gamepoint2 -et -t Teams >aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 -d gamepoint2 -et -t MatchSetups >aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 -d gamepoint2 -et -t MatchResults WebConfig Change the name of database [...]
