Answer Posted / piyush
Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what type of index will get created after executing the above statement? : Sql server database administration
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How to use "begin ... End" statement structures in ms sql server?
What is the federation in sql azure?
What is sql injection? How to protect against sql injection attack?
Differentiate between SQL and ORACLE joins and write their syntax.
How to check status of stored procedure in sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
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 is executereader?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
Where is localdb stored?
How to turn on the mssql api module in php?
How to find tables without indexes?
