Yes.but My Question is - "is there anyway to avoid Rollbacking of inner transactions alone??"

I am having doubt - is it achivable Or not? The senario is , "If the outer transaction is rolled back, then all inner transactions are also rolled back" is it any way to avoid Rollbacking of inner transactions?? Thanks, srinivasan r

In the next link, http://www.mssqltips.com/tip.asp?tip=1541 , there is a paragraph where it mentions that clustering in SQL server is about availability, opposite about others setups about incresasing power processing; Is there something about it (clusters for add power processing) in SQL Server (perhaps...

Hi, Do anyone can confirm me, i am little bit confused whether using alias name will improve the performances Or not? In my point of view, it won't do. Because i observed one thing by the CPU time & elapsed time is less, when i did not use alias name in my query. If it's not Helping to improve...

Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...

I want to retrieve names having single quotes. To do this i tryed as select * from hospital where name like' " ' " ' and select * from hospital where name like ''' . But I failed with these two ways . Please help me to do this

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

Hi, MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever). Is there a flag/setting in the DB...

what is the diffrence in DBMS and RDBMS?

Well Mr. Aprato, What I was trying to tell is. I have a database (SQL SERVER 2005 database) with a single table having Seven columns. i.e. Date column, FirstNumber column, SecondNumber column.....up to FifthNumber and lastly BonusNumber. In this case I have already connect the database to a form in VISUAL...