Microsoft SQL Server 2005 Console Write Line

Question

Is there a way to write a message to the console? I'd like to write some debug data if it's possible.

Answer 1

Well, there's the PRINT command:

PRINT 'Hello, world!'

I'm not sure if that's what you're looking for, though

Answer 2

you ment like: print?

like in

print 'hello world'

??

Answer 3

Higher overhead but you can log to the event logging system with xp_logevent.

Answer 4

For long-running operations, instead of PRINT, you might need to use the RAISERROR with NOWAIT option workaround, since the messages display is cached.