How to run stored procedures and ad-hoc scripts asynchronously with "loosely" connected SQL Server 2

Posted by sanga on Stack Overflow See other posts from Stack Overflow or by sanga
Published on 2010-01-20T14:49:16Z Indexed on 2010/04/08 19:33 UTC
Read the original article Hit count: 186

Filed under:

Is there a way to initiate a script against an instance of SQL server when it is not connected then have it run on the instance the next time it connects? This needs to happen without any intervention from me.

Background situation if you are interested:

We have about 120 machines each with their own instance of SQL Server 2000. Most of them are laptops. We have merge replication set up with each one. From time to time, there is a need to delete "rogue" guids from some tables in some instances that overwrite legitimate records on the main publisher as well as perform administrative tasks via stored procedure or adhoc sql statements.

The problem is there is no telling when each machine is going to be connected to the network. Some folks turn their machines completely off at the end of the day. Others disconnect their machines and take them on business trips, home for the weekend etc. Did I mention that about 35 of these machines are in utility trucks and "attempt" to sync over a wireless connection.

Thanks in advance for any assistance or suggestions.

Sanga

© Stack Overflow or respective owner

Related posts about sql-server-2000