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
Explain different forms of normalization?
what's the information that can be stored inside a bit column? : Sql server database administration
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Please explain what is “asynchronous” communication in sql server service broker?
What are sql servers used for?
According to you what goes into making the best database administrator? : sql server database administration
Tell me what is the order in which the sql query is executed?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is a trigger and types of a trigger?
whats the maximum size of view state??
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
How self join is different from outer join?
Mention the uses of stored procedures.
Which are the third-party tools used in sql server and why would you use them?
query processing