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
What is self contained sub query?
Equi join and non equi join is possible with sql server?
What is the difference between upgrade and migration in sql server?
Can sql servers link to other servers like oracle?
What is the difference between for xml raw and for xml auto?
Explain “row_number()” in sql server with an example?
What is standby servers? Explain types of standby servers.
What is an indexed view?
How do I create a trace in sql server?
List out the different types of locks available in sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Why and when do stored procedure recompile?
what is the difference between openrowset and openquery?
What is a coalesce function?
How to enter binary string literals in ms sql server?