What is @@Identity in sql?
Answer / deepthi
Is a system function that returns the last-inserted
identity value
Is This Answer Correct ? | 23 Yes | 1 No |
What are tables in sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How to create a simple stored procedure in ms sql server?
What is the osql utility?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is triggers and stored procedures?
explain different types of jions with examples briefly?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Tell me what is log shipping?
how to trace the traffic hitting a sql server? : Sql server database administration
Explain what is the function of sql server agent windows service?