Give two methods you could use to determine what DDL changes
have been made.
Answer Posted / monal
IN SQL 2005:
YOU CAN CREATE DDL TRIGGER TO TRACK CHANGES MADE WITH DDL
STATEMENTS.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
what functionality does oracle provide to secure sensitive information?
What is fill factor? : sql server DBA
internal architecture
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you communicate with operating system files from oracle?
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you record information about current session?
What the different components in replication and what is their use? : sql server DBA
how can you process messages in order asynchronously?
What are the different sql server versions you have worked on? : sql server DBA
Explain about your sql server dba experience? : sql server DBA