Subject Transactional Commands in Stored procedures.
Author Mahesh Ishwar
Hello All,
I was goin' thru the following link
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='323'

& can't to know that there can't be any DDL statements and transactional commands in stored procedures & triggers. I understand why DDL statements are not allowed, but couldn''t get the reasons for not allowing Begin Transaction, End transaction, commit, etc.
Can anyone tell me why this is so..?

Thanx in Advance.
Meghansh




---------------------------------
Yahoo! Plus - For a better Internet experience


[Non-text portions of this message have been removed]