1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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.

Question Posted / shalini

Answers were Sorted based on User's Feedback



If you are working on a SQL database and if suddenly a developer changes the code and your queries..

Answer / sumesh.tc

SELECT syscomments.text AS text
FROM sysobjects INNER JOIN
syscomments ON sysobjects.id =
syscomments.id where sysobjects.name=(stored procedure name)

Is This Answer Correct ?    5 Yes 0 No

If you are working on a SQL database and if suddenly a developer changes the code and your queries..

Answer / ramakrishna

select text from sysindexes

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What are constraints?

0 Answers  

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

What is an sql server agent?

0 Answers  

How to loop through returning rows?

0 Answers  

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,




What are the differences between substr and charindex in sql server.

0 Answers  

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

What are null values in ms sql server?

0 Answers  

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

What is change tracking in sql server?

0 Answers  

Can sql servers linked to other servers like oracle?

0 Answers  

Where is localdb stored?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories