Re: Messages Tab in SQL Server 2000

BillyRogers wrote:
I'd like to run some scripts/procs in sql server from a button on an
Access form using ADO or VBExpress using ADO.Net 2.0 and have the
messages that usually show up in the Messages tab of Query analyzer
show up in a textbox on the form.

Is this possible. i know how to run the scrips/procs.....I just
don't know how to get the Messages in a textbox on the form.

What i want is to be able to run the scrips from a form and just
press a series of buttons instead of having to load each of them in
Query Analyzer, but i still need to see the messages to check for
certain errors.


See http://www.sommarskog.se/error-handling-I.html#ADO


There was no way for you to know it (except maybe by browsing through
some of the previous questions in this newsgroup before posting yours -
always a recommended practice) , but this is a classic ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may
be lucky enough to find a dotnet-knowledgeable person here who can
answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.adonet.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.