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
- 7166 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
List the different index configurations possible for a table?
What is nested transaction?
How you can change a cross join into an inner join?
What does truncate do?
What is coalesce and check constraint in sql server?
Explain Capacity planning to create a database? and how to monitor it?
how many bits ip address consist of? : Sql server database administration
What are the common performance issues in sql server?
Which are the third-party tools used in sql server and why would you use them?
What is triggers in ms sql server?
How is table type constraint applied to a table?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is sql server used for?
How to use clusters?
How you trouble shoot when any job fails
