Name the triggers which support SQL Server 2000
Name the triggers which support SQL Server 2000?
Expert
SQL Server 2000 supports AFTER and INSTEAD OF triggers only. The BEFORE triggers cannot be supported by any SQL server. A table might have one or more AFTER triggers for update, insert and delete actions; AFTER triggers might not be assigned to views. A view or table might have at most one INSTEAD OF trigger for each and every triggering action of update, insert or delete.
Explain an unsupported method to shrink a database.
Briefly explains the three kinds of SQL commands?
Illustrates all databases should be in third normal form or not?
Explain the way to audit the SQL sent to the server.
Illustrates the relationship between a queue and underlying array of data structure?
State the steps for “this message could not delete” from the particular tables?
Explain how is the HASH file used and where we can use it?
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
Explain the Hash file and the Sequential File?
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
18,76,764
1949427 Asked
3,689
Active Tutors
1450096
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!