Hi,
i was just going thru the interview questions in web for SQL. There in
almost all sites i found this questions without answer. Can anybody help me
by giving an answer for this ?? The questions is only this much "Two Methods
of retrieving SQL"

Thanks in advance. waiting for ur reply

--

Well, the question is not a question because it does not have a question
mark. How can you answer something that is not a question? The sentence
that you provided is more of a statement than a question.

Without proper context it is difficult to determine what the "question" is
asking.
Do they want you to retrieve the Transact-SQL that makes up stored
procedures and views? You can use sp_helptext.
Do they want you to retrieve the sql statements that are being executed by a
user? If so you can use Profiler, DBCC INPUTBUFFER, or fn_get_sql. Read up
on these within Books Online (within the SQL Server program group).

--
Keith


[quoted text, click to view]