great, thanks for the answer, this will be my first time using this method ( STUFF)

guys i think i did it,

SELECT nkey,

(SELECT msg + '|'

FROM #tmpdata r2

WHERE r2.nkey = r1.nkey

ORDER BY msg

FOR XML PATH('')) AS fmsg

FROM #tmpdata r1

GROUP BY nkey

but my problem is that at...

i think that would be enough for the report, thanks for the help 🙂

so far, i found this, dbcc log, but not sure if i can get an info regarding user that created or modify stored procedure.

sorry for that, the audit is for our sql server 2000 🙁

thanks guys for all that info. 🙂

any help guys? i really need to know this, because i have to submit a report that list down all stored proc with the user that created it.

that's great, thank you very much, thanks guys for all that information!

i noticed you guys used a different condition statement by using BETWEEN condition and >= <

Is there a difference in performance? given the table has the right indexes.

thanks for the reply, so meaning, it's all about knowing the expected length of the value. But is there an impact if I always set the ANSI_PADDING to OFF?

i learn a lot today, thanks for all that answer 🙂

thanks guys for all the answers.

Sorry if my example is not that clear. My example assume that all are the same (same number of records, indexes, where clause). Honeslty I'm...

thanks for the link, sorry if my question is not clear, i have sysadmin role so what i want is to decrypt the stored proc in a standard way of...

hakimali (5/17/2011)

---

Running the following code will give you the names and the code of all stored procedures with a varchar declaration. It will not give you the line number, but...

Thanks to all that reply to this post.

Yes you are correct. I need to change...