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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-28 : 08:15:31
|
| Mala writes "Hi,How can I suppress the message getting displayed by SQL when I backup and restore from query analyzer.Regards,Mala" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-28 : 08:15:54
|
| You can't, and why would you want to? |
 |
|
|
Mala
Starting Member
26 Posts |
Posted - 2005-03-29 : 06:36:58
|
| I am doing this backup and restore process through Stored Proc. Parameters for this Stored Proc will be path and database name. If they pass invalid path or wrong database name I will be returning error message as record set , which we be capturing in ADO.In case back up and restore succeeds I got to return 'Successful completion of task' message. Since backup and restore process give those messages , we are getting error in ADO. (as too many output)So I would like to avoid this SQL message. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-29 : 07:28:27
|
| I would suggest not using a recordset to return this information. Backup and restore operations do not return or affect data, so a recordset is not needed. The stored procedure can be altered to return this information through output variables and/or return values. See this article for examples:http://www.sqlteam.com/item.asp?ItemID=2644An ADO Command object would be the better choice to send this data to an application. |
|
|
|
|
|
|
Back up and Restore