Explain log shipping?
No Answer is Posted For this Question
Be the First to Post Answer
How you can get the list of largest tables in a database?
Can XML be used to access data?
Define constraints and give an example of their use?
What happens if null values are involved in bitwise operations?
How do I create an extended event in sql server?
How to make a remote connection in a database?
what is advantages in sql 2005 over sql 2000?
How m-m relationships are implemented?
What are three SQL keywords used to change or set someone?s permissions?
Explain what is analysis service repository?
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
Can a cursor be updated? If yes, how you can protect which columns are updated?