How to remotely start SQL Server instance?

When you connect to SQL Server instance using SQL Query Analyser there is
"Start SQL Server if it is stopped" option. Is it possible to remotely
start stopped SQL Server instance from my custom application? How?You can use DMO, SMO, or WMI to remotely start the service, google for
more information on this topics like here:
http://www.devx.com/vb2themax/Tip/18459
HTH, Jens Suessmeyer.

How to query an oracle data from SQL server Query analyser

Hi ,

I am having 2 data store .

1. Oracle 10g

2 SQL server 2000

My requirement is that , i need to insert some data from sql server database table to oracle database using sql server query analyser or interface.

If there is any way ,plz let me know it

Thanks

Abraham

You should be able to setup a linkserver in Sql server to Oracle and access Oracle data. Follow this link and this.|||

Hi sankar,

I am trying that option, if that works out how we can insert data or query data from oracle , is that the normal SQL way or some other format is there.

basically i need to write a Sql server trigger on a table which will insert data to oracle based on the new records insertion in sql server.

Thanks

Abraham

|||

I am not sure if that is good idea to wrap this inside a trigger. Though linked servers provide good access to data from different data sources, it comes with some issues. May be you need to be aware of what you getting in to. Check out some these links and read some more.

http://www.thescripts.com/forum/thread80168.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;191168&Product=sql2k

http://support.microsoft.com/kb/306212