Is there a script that I can run to stop a particular SQL server service on
Win2003 server?  I'm looking for a similar script to restart that service as
well.  Thanks.

I'm learning aspx. I have the following code in my aspx:
SqlConnection connection = new
SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated
Security=SSPI");

Job '%s' is already targeted at server '%s'.

I have a problem in displaying International characters in SQL Server 2000.
There are a few Russian characters that are displayed as '??????' in query
analyzer. i have the database setup on 2 machines. On one DB server the
characters are displayed properly and on other it is ...

I have content about projects that I store in a MS SQL database.
People access this information through pages which are dynamically
created in PHP. Since my content is stored in the database, how can I
get google web search (at google.com) to included that content when it

I'm trying to turn a product table into an XML file to create an
heirarchical menu, and I was wondering if there was any easy way to do
this. The table is (simplified) below:
Create table product(

I cant figure out how to do this....
for example:
Select name from mytab order by col1
could return

Dear Group,
I would like to create an audit table that is created with a trigger that
reflects all the changes(insert, update and delete) that occur in table.
  Say I have a table with

The description is as follows... The necessary network binding may already be
in use.  The  site has been deactivated.  The data field contains the error
number.  If anyone can help I would greatly appreciate it.  Thanks!
Mendy

hi all, have anyone else met with the following problem.
we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3,
this cluster in using AD.
I've found that whenever I use Enterprise Manager on my local computer

I'm a newby and I have a quick question. I have set up this procedure
to run as a job. I can create a block and have it populate the table,
but I need to be alerted via email when the table is being populated. I
do not know what step/s am I missing.  Here is the scripts I ran:

Deaa group,
I am using SQLServer 2000 in an XP Sp2.  I would like to do the
following:
I have a program running on a database server that generates some data

Hi.  I'm creating a stored procedure that inserts a record if it's not
already there, otherwise returns -1.  It's like this...
---
CREATE PROCEDURE createsession

Using SqlServer :
Query 1 :
SELECT def.lID as IdDefinition,
TDC_AUneValeur.VALEURDERETOUR as ValeurDeRetour

When I need to perform an update against multi-million row table I
typically specify @@rowcount, to reduce locks.
e.g.
set @@rowcount 1000