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 is use of attribute hierarchy optimized state? : sql server analysis services, ssas

0 Answers  

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

Tell me what do you understand by a view? What does the with check option clause for a view do?

0 Answers  

What types of replication are supported in sql server?

0 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,




What are commonly used odbc functions in php?

0 Answers  

How to concatenate two binary strings together?

0 Answers  

What is a partitioned view?

0 Answers  

How many database files are there in sql server 2000?what are they?

0 Answers  

Why use “pivot” in sql server?

0 Answers  

What is SQL server agent?

2 Answers   HCL, SAP Labs,

How do you open a cluster administrator?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories