How to Configure ACID in ms-sql server
-
Hi every body
any body know how do set or configure ACID in ms-sql server
-
I'm not sure exactly what you mean. The SQL Server engine provides a certain level of ACID properties "out of the box" and you, the programmer, can specify different levels depending on your application's needs. But this is a big subject that can't possibly be dealt with effecively in a forum.
Not to sound to self aggrandizing, but not too long ago, I wrote a series of articles on the subject, hopefully they will be helpful...
http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart1.asp
http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart2.asp
http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart3.asp
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
I prefer using the Jimmy Hendrix extended producedure "Purple Haze"...
Good Hunting!AJ Ahrens
webmaster@kritter.net
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply