Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of TRIGGERS are there in MS SQL Server?
- 8 Answers
- 31323 Views
- CarrizalSoft Technologies, TCS, United Healthcare, I also Faced
- E-Mail Answers
Answer Posted / yugal
SQL Server 2008 includes three general types of triggers:
1)DML triggers
2)DDL triggers
3)Logon triggers.
| Is This Answer Correct ? | 26 Yes | 5 No |
Post New Answer View All Answers
How to generate create view script on an existing view?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is failover clustering overview?
List out the differences between the clustered index and non-clustered index in sql server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
How to configure and test odbc dsn settings?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is the use of keyword with encryption.
How to download and install microsoft .net framework version 2.0?
What are the default system databases in sql server 2000?
Distinguish between nested subquery and correlated subquery?
How to get @@error and @@rowcount at the same time?
Define full outer join in sql server joins?
How do I find the sql server instance name?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
