4
votes
2answers
93 views
How to avoid execution of DatabaseStart Event
When your Database contains a EVENT of type DatabaseStart and you are able to crash the Database Engine during startup with your fabulous code.
How would you fix the database to …
2
votes
1answer
117 views
Are there “SQL Design Patterns”?
I have just searched through StackOverflow but couldn't find much...
To all the SQL experts,
is there anything comparable to the "design patterns movement" which has taken place …
3
votes
3answers
81 views
Running ASA in a virtual machine
Does anyone have experience running ASA under VMWare or Xen or anyother virtual machine. If so what was your experience doing so (performance, security, replication issues). The da …
2
votes
1answer
34 views
How to localize System Messages
We use in all procedures customized error codes to give feedback to the client what was wrong.
// Initialized during Database generation
sp_addmessage 20102, 'Some Custom Error Me …
4
votes
5answers
169 views
What is the best way to simulate Oracle Autonomous Transactions in SQL Anywhere?
What`s the best way to simulate Oracle Autonomous Transactions on SQLA?
I`m think publishing an webservice on database and create a stored funcion/procedure to consume it.
That`s …