Thursday, February 9, 2012

T-SQL: Disable/Enable trigger script

Disable trigger script

USE AdventureWorks
--Make sure we are in the correct DB

ALTER TABLE HumanResources.Employee DISABLE TRIGGER HumanResources.dEmployee
--disabletrigger from a specific table

Enable trigger script

USE AdventureWorks
--Make sure we are in the correct DB

ALTER TABLE HumanResources.Employee ENABLE TRIGGER HumanResources.dEmployee
--enable trigger from a specific table

Erros encountered

When using the following script

ENABLE TRIGGER HumanResources.dEmployee ON HumanResources.Employee

I was getting the error

Error Message : Incorrect syntax near 'ENABLE'.

Using the version indicated above using the ALTER TABLE syntax, solved this issue

Monday, February 6, 2012

TetraChalk: Tetris Clone in XNA

This is a game which everyone in game development must one time or another create. Here is my version of it and I am pleased to say that I managed to polish it a bit unlike most of the games that I start.

I will try to write a tutorial on how I created the game

XNA Falling Blocks game: Tetrachalk


For now, you can download the game here.  Please feel free to comment on the game in the comments section below.