lars (11/23/2008)

---

if i execute the [dbo].[_SPLOG_AutoGenStatements] with different tables and option i get allways

this error msg.

Meldung 208, Ebene 16, Status 0, Prozedur _SPLOG_AutoGenStatements, Zeile 177

unknown Objectname '#sp'.

is there something missing...

I went through a similar exercise not long ago...

I haven't actually run the code from this article, since I'm quite happy with mine :P, but looked through it and...

RE: CR/LF/NewLine (Cade Roux)

Actually, with Transact-SQL, it's even easier, just embed the newline in your string. Try this in your Management Studio/Query Analyzer

SELECT 'This is a string

with some

embedded new line...

Ok, so I'm a (posting) noob on this site, but aren't loops discouraged in these forums?

If you have a zero-based Tally table, you can replace your initializer and loop with...