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.
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
Is it possible to have clustered index on separate drive from original table location?
What are the advantages of using stored procedures?
Can you explain powershell included in sql server 2008?
Can you name some of the dml commands in sql?
explain extended properties
Are connections to sql server encrypted?
Tell me the difference between clustered and non-clustered index?
How many null values we can have in a unique key field in sql server?
What is user-defined scalar function?
Is oracle faster than sql server?
What do you mean by collation recursive stored procedure?
Why we should not use triggers?
How network traffic be reduced by using the stored procedure?
How can I tell if sql server is 32 or 64 bit?
How to connect to a sql server using odbc_connect()?