.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

How can we cancel a transaction?

Posted By :nishithraj     Posted Date :March 16, 2010    Points :10   Category :Sql Server 
Using ROLLBACK TRANSACTION;

You can also find related Interview Question to How can we cancel a transaction?  below: 

what are the content in Transaction log file backup?

  

Step 1 : Begin and End Transaction information

step 2 : Modified transaction information

step 3 : create or alter table information or index information (More...)

How does the Transaction topic work in asp ?

  
In Asp there is an Assembly called System.Transactions which contains classes that allows the applications to work under the transactions which were organized by
Microsoft Distributed Transaction Coordinator (MSDTC ) and
Local Transaction Manager(LTM ).

This System.Transactions assembly allows both implicit and explicit way of operation

The Explicit programming model is based on the Transaction class and
The Implicit programming model using the Transaction Scope class. (More...)

What advantage does a transaction have over a batch or script?

  
In short A transaction executes as a single unit of work. If a transaction fails, it can be rolled back as a unit, leaving data in a consistent state. (More...)

On a routine monitoring of the data files and transaction log, you notice that the transaction log is extremely close to being full. What will happen if the log fills? What steps can you take to avoid running out of transaction log space?

  
If the transaction log fills, you are unable to modify the data in the database until the log is archived or expanded. To avoid a full transaction log, you can monitor the log space regularly, expand the log whenever necessary, set the log to grow automatically, and create an alert to notify you when the available log space falls below a specified level (alerts are not covered in this training kit). Scheduling or performing frequent transaction log dumps is the best way to reclaim available space in the transaction log.
(More...)

Database: What is recorded as transaction log for Truncate ?

  
Data page deallocation are recorded as transaction log for truncate command.

(More...)

. How will you cancel a deployment from central admin -> solution managment, if its stuck at "deploying" or "Error".

  
Ans. You can either try to force execute timer jobs using execadmsvcjobs command or can cancel the dpeloyment using stsadm command stsadm -o cancaldeployment -id {GUID} command. The Id here would be GUID of the timer or deployment job. You can get the Id from stsadm enumdeployment command. This will display all the deployments which are process or are stuck with Error. (More...)

How to cancel a stsadm deployment ?

  
You can cancel the deployment using stsadm command
"stsadm -o cancaldeployment -id {GUID} command or can either try to force execute timer jobs using execadmsvcjobs command".

The Id here would be GUID of the timer or deployment job.

You can get the Id from stsadm enumdeployment command also.

This will display all the deployments which are inprocess or are stuck with Error. (More...)

How will you cancel a deployment if its stuck at "deploying" or "Error".

  
You can either try to force execute timer jobs using execadmsvcjobs command or can cancel the dpeloyment using stsadm command stsadm -o cancaldeployment -id {GUID} command. The Id here would be GUID of the timer or deployment job. You can get the Id from stsadm enumdeployment command. This will display all the deployments which are process or are stuck with Error. (More...)

What is Transaction Propagation? And how WCF support it?

  
Transaction propagation is the ability to propagate transaction across the boundaries of a single service. Or in other words, we can say that a service can participate in a transaction that is initiated by a client.
In a SOA environment, transaction propagation becomes a key requirement. As we know that WCF supports SOA, so it provides support for transaction propagation as well.
To enable transaction propagation, we need to set the value of TransactionFlow property of the binding being used. This can be done programmatically as follows:
WSHttpBinding bindingBeingUsed = new WSHttpBinding();
bindingBeingUsed.TransactionFlow = "true";
Or It can be done declaratively by updating configuration file as follows:


transactionFlow="true" />


Default value for TransactionFlow property is "False".
(More...)

Does all WCF bindings support for Transaction Propagation?

  
No. Not all WCF bindings support transaction propagation. Only following list of bindings support for it.
. wsHttpBinding
. netTcpBinding
. netNamedPipeBinding
. wsDualHttpBinding
. wsFederationHttpBinding
(More...)

What are the various Transaction Flow Options available in WCF?

  
If a service is configured for Transaction Propagation, WCF further supports various options for service methods to be part of any transaction initiated outside service boundaries.
. NotAllowed Transaction Propagation is not allowed for particular service method. Its default value.
. Allowed Transaction Propagation is allowed but not compulsory.
. Mandatory Transaction Propagation is compulsory for that service method.
For example, Transaction Propagation is mandatory for CreditAccount service method in following code snippet.
[ServiceContract]
interface IPaymentService
{
[OperationContract]
[TransactionFlow(TransactionFlowOption.Mandatory)]
void CreditAccount(..);
}
(More...)

What is the role of transaction manager in WCF?

  
Transaction manager while sitting on client side, initiate the transaction and coordinates with all the processes that participate in a distributed transaction to commit or roll back. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend