Solved

SQL 2005 script automation

Posted on 2011-09-14
2
137 Views
Last Modified: 2012-05-12
I need to execute a script to update data on about 500 SQL2005 Express on XP, what would be the best way to do this. the script will be removing data from each database in several tables.
any help is greatly appreciated.
0
Comment
Question by:atorex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
FarWest earned 500 total points
ID: 36536877
you can use cscript .vbs file to deploy it on those machine,
if the machines are connected to AD then you can use GPO logon script to run it on those machine

http://stackoverflow.com/questions/1371953/vbscript-how-to-set-the-connection-string

also you may need this to get computer name and use it in the script  

Set objNetwork = CreateObject("Wscript.Network")
ServerStr = objNetwork.ComputerName

good luck
0
 

Author Comment

by:atorex
ID: 36537600
Thanks,

OK, these machines are not on AD, so I can use the example script on the link to execute remotely. I will try that out and update in the next couple of days.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Anyway to make these 2 SQL statements into one? 13 45
Please help for the below sql query. 1 29
Sql Server group by 10 51
tempdb log keep growing 7 45
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question