If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database.

Answer Posted / ramakrishna

select text from sysindexes

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are constraints? : Sql server database administration

513


What are the source of constraints?

504


What is equi join with example?

549


How to use subqueries in the from clause in ms sql server?

563


What is sql language?

544






How do you drop an index?

498


What is wide table?

531


What is an indexed view?

577


Explain a join?

605


Explain about temporary stored procedure?

520


How many types of cursor type are there?

587


Explain what role entity and relationship play in an ER diagram.

569


What is Extended user-defined?

533


Is the primary key column of a table an index in ms sql server?

533


How to connect to a sql server using odbc_connect()?

614