SELECT syscomments.text AS text FROM sysobjects INNER JOIN

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 / sumesh.tc

2 Answers
7041 Views
Microsoft, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do mean by xml datatype?

1004

Explain what are page splits? : SQL Server Architecture

1001

What is indexed view? How to create it?

930

How to view the error log for any specific instance? : sql server database administration

984

How do I create a partition table in sql server?

1045

What is rank function?

974

Explain hostprotectionattribute in sql server 2005?

958

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

820

How to run queries with sql server management studio express?

1014

Which tcl commands are available on the sql server?

1015

Explain the phases a transaction has to undergo?

985

What are the 3 types of schema?

1041

How to add the custom code in Report?

116

What is the chart in report?

142

Can you type more than one query in the query editor screen at the same time?

949