Open table froma service

Question

Can I open the ads_err table from a windows service?

Answer 1

Yes. You should be able to open it just like any other table. You don't mention what development environment (client type) you are using, so I am not able to give more details specific to your situation.

After you have a connection to the server, all that is necessary is to supply the full path to the error log. If you don't want to hard code the path (probably desirable to avoid that), you can retrieve it with sp_mgGetConfigInfo(). The Error Log Path field is the one you would want.

You could also read the error log with SQL by including the path. For example, select * from [c:\ads_err].