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 ?

RESTORE DATABASE [dbProdApp]
FROM DISK = N'C:\S_HOMSQL_Db_20030513_dbProdSys_Temp_Manual.ba k'
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!You can mention PRINT statement in the SP to get the information. Refer to books online for PRINT topic.|||BUt I'd like to receive the print messages in a ASP application for example.

Or save the messages in a temporary table.sql

'PRIMARY' filegroup full error

When adding records that would take a SQL Server
Developer Ed. table over 2 Gb, I receive an error that
says "Could not allocate space for object 'MyTableName'
in database 'MyDb' because the 'PRIMARY' filegroup is
full." What do I need to do to get around this error?
Thanks in advance,
JoeAre you referring the Desktop (MSDE) edition? This is a known
limitation of that edition and there is no workaround.
The Developer edition has no size limitation. You can expand your
database or add additional files to get around the error.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Joe" <joe.murray@.jmaconsulting.biz> wrote in message
news:0fb401c36738$0c3b53b0$a601280a@.phx.gbl...
> When adding records that would take a SQL Server
> Developer Ed. table over 2 Gb, I receive an error that
> says "Could not allocate space for object 'MyTableName'
> in database 'MyDb' because the 'PRIMARY' filegroup is
> full." What do I need to do to get around this error?
> Thanks in advance,
> Joe