Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 7220 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
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Why I am getting this error when dropping a database in ms sql server?
What is Transparent Data Encryption?
How network traffic be reduced by using the stored procedure?
How to defragment table indexes?
What are information schema views?
Write a sql query to display the current date?
When would you use sql joins?
What are the instances when triggers are appropriate?
What is rs.exe utility?
Explain what is raid and what are different types of raid levels?
Is resultset an interface?
What’s the use of custom fields in report?
