Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can you have a nested transaction?

Answer Posted / ram&saran

It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the system database in sql server 2005?

1099


What are ddl triggers and types of ddl trigger?

1097


can we have a nested transaction? : Sql server database administration

1195


What is the difference between composite index and covering index?

1008


What do you understand by a view?

1049


What are the recovery models for a database?

1149


What are the benefits of filtered indexes?

1099


What is the recovery model?

1062


Explain about temporary stored procedure?

1099


What is the purpose of forms?

1004


Tell me what is log shipping?

1033


What are parameterized reports? What are cascading parameters in ssrs reports?

165


What is difference between clustered and non clustered index?

1035


what is datawarehouse?

1159


What is openrowset sql server?

1193