problem when checking MS SQL server and log creation

[leoneri]

Hello,
I have two problems here:

1. I want to use HM to check for my database MS SQL server. it works fine except for databases that has space on their name.

for example, if the test properties window shows like this:
-------------------------------
Test by: HostMonitor
Test Method: check MS SQL server

Server: hostname_A
Database: Northwind_A
Login/Username: uname
Password: ***********
--------------------------------
everything's fine. but if my database name is North wind_A --as you can see, there is space between North and wind_A,-- the test-item status keep showing failed test while there is nothing wrong with the database.

2. I want to use private llog. Buit, how to make it generated automatically just like reports. I already enter the path for log at the test properties window, but it just won't generated.

Please tell me what should I do to solve both problems. Thanks.

My OS is Windows 2003 server. I'm using RCC to configure it remotely from a WinXP box.

Best regards,
leoneri

[Yoorix]

1. I want to use HM to check for my database MS SQL server. it works fine except for databases that has space on their name.

You should wrap the name of database in [], as described in Transact SQL manual. E.g [North wind_A]

2. I want to use private llog. Buit, how to make it generated automatically just like reports. I already enter the path for log at the test properties window, but it just won't generated.

You should also mark checkbox [x] Use private log.
HM adds record to private log according to logging mode.
- Default - the common settings defined in the Options dialog are used;
- Brief - record information whenever status of the test changes;
- Full - record all test results, regardless of whether their status had changed or not;
- Reply - record information into log every time the status or reply value of the test changes.

Select preferable logging mode and try refresh test. If a private log is specified, the popup menu for that test will contain the item, "View private log".

Regards,
Yoorix

[leoneri]

Hi. sorry for late response... thanks a lot, ms sql test works very fine now