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
- 7188 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
Are connections to sql server encrypted?
Tell me something about security and sql azure?
Explain boyce and codd normal form(bcnf)?
How to sort query output in descending order in ms sql server?
How to stop log file growing too big?
What is temporary stored procedure?
What is change tracking in sql server?
What is the difference between the 2 operating modes of database mirroring?
What is the difference between char and varchar2 datatype in sql?
what is database replicaion? : Sql server database administration
What are the different types of columns types constraints in the sql server?
What do you know about system database? : SQL Server Architecture
Explain what are page splits? : SQL Server Architecture
How to check if stored procedure is running in sql server?
What are the advantages of sql stored procedure?
