What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ?
Answer Posted / sanjeev kumar
u hve to run query against transaction log.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
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.
What are commonly used odbc functions in php?
What is ms sql server reporting services?
Explain about builtinadministrator?
Why are you getting errors when creating a new odbc dsn?
What is not null constraint?
How to view existing indexes on an given table using sys.indexes?
Explain intellisense for query editing
What are the different types of stored procedures?
is there a column to which a default can't be bound? : Sql server database administration
What are the types of indexing?
How to set database to be read_only in ms sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Can we install sql server 2016 on windows 7?
query processing