Re: reporting..
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 07/21/04
- Next message: Aaron [SQL Server MVP]: "Re: 5, 8 or 25 concurents workloads ?"
- Previous message: Andrea Montanari: "Re: SQL Server DE Logon Failure"
- In reply to: dev_kh: "Re: reporting.."
- Next in thread: dev_kh: "Re: reporting.."
- Reply: dev_kh: "Re: reporting.."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 16:13:32 +0200
hi dev
"dev_kh" <devkh@discussions.microsoft.com> ha scritto nel messaggio
news:CAF7632E-4D3E-4EF9-9B75-ADE8414C3632@microsoft.com...
> you mentioned:
>
>> "usually the MSDE instance running on the remote server shoul'd be up and
>> running...
>> if you do have SQL-DMO [again =;-D ] you can try starting it, but the
best
>> solution is making sure the MSDE instance starts at server startup"
>
> Do you mean making sure that the MSDE is set to startup automatically..
>but I want to use the Start Service if needed. So when my app starts I
want
> to see if the service is running, if not I want to start it.
>
> So, on my machine I was using the following line:
> svc = New ServiceController("MSSQL$MyInstanceName)
>
> but now when the service is on the central machine then will anything
change
>in the above line of code? I mean will I have to add the server's
name/path
>somewhere in the above line.. after all the service is on the server...
>
> Hope my question is clear now..
if you are using WMI, you will actually invoke SQL-DMO behind the scenes, so
just directly rely on DMO...
so you have to try a connection, possiblyy with low timeout in order not to
wait to much, and eventaully start the server if needed...
but, again, you shoul'd rely on autostart service method whenever
possible...
make it simple =;-D
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Aaron [SQL Server MVP]: "Re: 5, 8 or 25 concurents workloads ?"
- Previous message: Andrea Montanari: "Re: SQL Server DE Logon Failure"
- In reply to: dev_kh: "Re: reporting.."
- Next in thread: dev_kh: "Re: reporting.."
- Reply: dev_kh: "Re: reporting.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
