running sql script

What is the best way to run sql scripts in vs.net 1.1 with msde

thanks

Nov 19 '05 #1

863

Hi Barry:

You could open the Server Explorer windows and get a query window for
the MSDE instance you need. There is also the OSQL command line
utility, and of course you can always whip up a form that takes a
script and pumps it through SqlCommand and ExecuteNonQuery. The best
way really depends on the types of scripts and how often you need them
to execute, etc.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 7 Apr 2005 20:41:15 -0700, "barry" <fl******@ix.netcom.com>
wrote:

What is the best way to run sql scripts in vs.net 1.1 with msde

thanks

Nov 19 '05 #2

barry

Thank you very much Scott

"Scott Allen" <sc***@nospam.odetocode.com> wrote in message
news:vb********************************@4ax.com...

Hi Barry:

You could open the Server Explorer windows and get a query window for
the MSDE instance you need. There is also the OSQL command line
utility, and of course you can always whip up a form that takes a
script and pumps it through SqlCommand and ExecuteNonQuery. The best
way really depends on the types of scripts and how often you need them
to execute, etc.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 7 Apr 2005 20:41:15 -0700, "barry" <fl******@ix.netcom.com>
wrote:
What is the best way to run sql scripts in vs.net 1.1 with msde

thanks

Nov 19 '05 #3

Similar topics

running php script?

by: Sticks | last post by:

ok... im not quite sure how to describe my problem. i have a php script that runs through my entire php site and writes the resulting output to html files. this is necessary as the nature of the...

PHP

Script stops running during while()

by: Damien Renwick | last post by:

I have a php script which simply stops midway through a while loop that processes records returned by a MySQL query. The HTML page continues trying to load the page but the php has stopped running...

PHP

Running script before import

by: shumaker | last post by:

I don't need a detailed description of a solution(although I wouldn't mind), but I am hoping someone could tell me in general the best path to go about accomplishing a task, since I don't know all...

Microsoft Access / VBA

Checking whether postgresql is running

by: Ennio-Sr | last post by:

Hi all! Testing a script where I need to make sure that postgresql is running before passing a <psql dbasename -c "insert into ..." > instruction I faced this curious behaviour: This is the...

PostgreSQL Database

modify a long-running python script while it is running?

by: Benjamin Rutt | last post by:

I often execute a long-running python script which is a "driver" for my application; it may run for several hours on a large input. Under CPython, is it safe for me to modify the Python script...

Python

How to display progress bar for long running page in Javascript

by: Anonieko | last post by:

Query: How to display progress bar for long running page Answer: Yet another solution. REFERENCE: http://www.eggheadcafe.com/articles/20050108.asp My only regret is that when click the...

ASP.NET

LongestRunningQueries.vbs - Using a VB Script to show long-running queries, complete with query plans

by: Aaron West | last post by:

Try this script to see what queries are taking over a second. To get some real output, you need a long-running query. Here's one (estimated to take over an hour): PRINT GETDATE() select...

Microsoft SQL Server

connection drops while script running

by: This | last post by:

I have a pretty basic emailing script that sends a relatively small number (150) of html emails. The emails are compiled, personalised from a mysql db subscribers list, and sent using mail() -...

PHP

Determine folder a script is running in.

by: Scott | last post by:

What is the most reliable method to determine the folder a script is running in? I was looking at the globals in $_SERVER but all the variables also listed the actual file the script was running...

PHP

running same script on same data on two different machines -->different result

by: Christopher Brewster | last post by:

I am running the same script on the same data on two different machines (the folder is synchronised with Dropbox). I get two different results. All the script does is count words in different...

Python

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice