Answer Posted / subbu
Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Tell me about the approaches which you used to counter the DI problems.
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is code near application topology?
Can we call future method from queueable?
How do use Having,Group by,Group function in SQL?
Explain nested join?
What is shrink log file?
What is constraints and its types?
How to convert numeric expression data types using the cast() function?
How to find out the list schema name and table name for the database?
Is sql server implemented as a service or an application? : Sql server database administration
Explain “@@rowcount” and “@@error” in sql server?
What is a constant or literal in ms sql server?
What is a matrix in ssrs?
How to list all triggers in the database with sys.triggers in ms sql server?