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

How do I completely remove sql server instance?

566


Does a specific recovery model need to be used for a replicated database? : sql server replication

529


What is exporting and importing utility?

606


what's new in sql server 2016?

559


What are the two authentication modes in sql server?

600






What is a derived table?

509


Explain about SQLOS?

588


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

542


What do mean by xml datatype?

615


What functions can a view be used to performed?

620


What are the purposes and advantages stored procedure?

497


What is the difference between deallocate cursor and close cursor?

719


Describe how to use linked server?

541


Do you know clustered and non-clustered index?

525


How to divide query output into multiple groups with the group by clause in ms sql server?

565