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
- 5984 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
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How can sql injection be stopped? : sql server security
How do I know if localdb is running?
Explain how to send email from sql database?
How will you monitor replication latency in transactional replication? : sql server replication
How to list all field names in the result set using mssql_field_name()?
What is policy management?
How can I create a report based on a query? : sql server management studio
What is left outer join in sql server joins?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Explain sql delete command?
What is difference between table aliases and column aliases? Do they affect performance?
What programming language would you use to create embedded functions in ssrs?
What are the differences between lost updates and uncommitted dependencies?
What are the extra roles available in msdb? : sql server security
