select text from sysindexes

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.

Question Posted / ramakrishna

2 Answers
7190 Views
Microsoft, I also Faced
E-Mail Answers

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

Explain about builtinadministrator?

1048

What is sleeping status in sql server?

1018

Can sql servers linked to other servers like oracle?

939

What are the tool windows in sql server management studio? : sql server management studio

1065

In which sql server version report builder introduced?

148

How to write a query with a right outer join in ms sql server?

903

what are triggers? : Sql server database administration

900

Can a trigger be created on a view?

948

What is relationship? What number of sorts of relationship are there?

1126

What are trace files?

946

How to delete duplicate rows?

987

What will be query used to get the list of triggers in a database?

992

Which are new data types introduced in sql server 2008?

1035

How does the report manager work in SSRS?

148

What is sql server locking?

976