Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 PRINT line not executed

Author  Topic 

azamsharp
Posting Yak Master

201 Posts

Posted - 2005-05-30 : 10:39:57
Why does the PRINT line does not get executed.

DECLARE @Message nvarchar(50)

EXECUTE sp_GetSomething
@CategoryID = 1,
@Message = @Message OUTPUT

SELECT @Message

PRINT 'This works'

Mohammad Azam
www.azamsharp.net

azamsharp
Posting Yak Master

201 Posts

Posted - 2005-05-30 : 10:55:09
Never mind it was printing under the Messages Tab. I thought we can print it under Grid tab too

Mohammad Azam
www.azamsharp.net
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-05-30 : 23:16:41
try 'select' instead of 'print'

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -