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 is wide table?

544


is there a column to which a default can't be bound? : Sql server database administration

543


Explain syntax for disabling triggers?

526


What is the impact on other user sessions when creating indexes?

548


How to replace the Query Result 'Null Value' with a text ?

571






While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

89


What is the difference between left and right outer join?

551


Explain foreign key in sql server?

587


Why use sub query in sql server and list out types of sub queries?

550


Do you know the capabilities of cursors?

539


How to turn on the mssql api module in php?

571


Why would you call update statistics?

591


How to add more data to the testing table in ms sql server?

558


How to execute a sql statement using mssql_query()?

553


Can sql server 2016 run on windows 7?

511