Interested to Buy Any Domain ? << Click Here >> for more details...
Give two methods you could use to determine what DDL changes
have been made.
- 2 Answers
- 11468 Views
- I also Faced
- E-Mail Answers
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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are statistics, under what circumstances they go out of date, how do you update them?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you implement fine-grained auditing?
What is dcl? : sql server DBA
how can a session indicate its interest in receiving alerts?
How to start SQL Server in minimal configuration mode?
Can you redefine a table online?
how can you find out if a table can be redefined?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is logical system in sap basis
How would you extract DDL of a table without using a GUI tool?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
