Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Give two methods you could use to determine what DDL changes
have been made.

Question Posted / monal

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


Please Help Members By Posting Answers For Below Questions

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2089

what do you understand by flashback feature of oracle?

1046

How do you trace the traffic hitting a sql server? : sql server DBA

1634

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2028

what are the types of connection load-balancing?

1047

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?

2862

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1962

What is the importance of a recovery model? : sql server DBA

1083

how can you record information about current session?

1105

Where would you look for errors from the database engine?

2897

what is a crs resource?

1240

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

2152

what is ora 24313?what is the procedure to exclude that error?

2614

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4411

What are the operating modes in which database mirroring runs? : sql server DBA

1242