adspace


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 self contained sub query?

1139


Equi join and non equi join is possible with sql server?

1134


What is the difference between upgrade and migration in sql server?

1183


Can sql servers link to other servers like oracle?

915


What is the difference between for xml raw and for xml auto?

1114


Explain “row_number()” in sql server with an example?

1078


What is standby servers? Explain types of standby servers.

1078


What is an indexed view?

1021


How do I create a trace in sql server?

1118


List out the different types of locks available in sql server?

1049


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1196


Why and when do stored procedure recompile?

1057


what is the difference between openrowset and openquery?

1193


What is a coalesce function?

1282


How to enter binary string literals in ms sql server?

1243