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 - 2001-05-06 : 14:35:36
|
Tom writes "I have a home-grown stored procedure that runs on SQL Server 2000 that outputs blocking information to a log file on the SQL Server database. It uses sp_who to do most of the processing.
My dilemna is that my boss wants the output to be readable from a web page so that when the DBA is not around, the users can click a button, bring up the output and report it to the helpdesk.
The stored procedure has no OUTPUT parameters from which to capture this data, let alone store it, it is all wriiten out to this log using the print method in the stored procedure.
Is it possible for the output of one of these stored procedures to write directly to a text file on another machine, that could be later parsed with VB or ASP so that it could be made public?" |
|
|
|
|
|
How to output blocking information to a text file