Results 1 to 3 of 3

Thread: Print

  1. #1
    Join Date
    Sep 2002
    Location
    Brazil
    Posts
    56

    Unanswered: Print

    Hello Guys,


    Is it Possible to receive the PRINT Message from a Stored Procedure in the applications?

    If no, how SQL Entrerpris Manager receives the print generated from the RESTORE DATABASE WIHT STAT ?


    Code:
    RESTORE DATABASE [dbProdApp] 
    FROM  DISK = N'C:\S_HOMSQL_Db_20030513_dbProdSys_Temp_Manual.bak' 
    WITH  
    	FILE = 1,  
    	NOUNLOAD ,  
    	STATS = 10,  
    	RECOVERY ,  
    	REPLACE ,  
    	MOVE N'dbSolomonProdSys_Log'  TO N'c:\dbProdSys_Temp_log.ldf',  
    	MOVE N'dbSolomonProdSys_Data' TO N'c:\dbProdSys_Temp.mdf'

    Thankxs Everybody!
    Diogo Hudson Dias
    DBA - SQL 6.5/7.0/2000
    ASBACE - ATP

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can mention PRINT statement in the SP to get the information. Refer to books online for PRINT topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Sep 2002
    Location
    Brazil
    Posts
    56
    BUt I'd like to receive the print messages in a ASP application for example.

    Or save the messages in a temporary table.
    Diogo Hudson Dias
    DBA - SQL 6.5/7.0/2000
    ASBACE - ATP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •