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
Can another user execute your local temporary stored procedures?
What is indexing and its types?
What command must you use to include the not null constraint after a table has already been created?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Explain the cursor lock types?
What functions can a view be used to performed?
How to reaname table name without using sp_Rename in sql server..?
What is de-normalization in sql database administration? Give examples?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Why can there be only one clustered index and not more than one?
Differentiate between mongodb vs. Sql server?
What is clr ddl trigger?
What is an identity column in insert statements?
What is merge?
When would you use the stored procedures or functions?