how can i execute a StoreProcedue in SQL2000 every time i received a replay
message with a specific subject, and pass some arguments like the subject.
thank in advanced,
Renato Ribeiro

  I like to use a variable to store the return values (True / False) of the
exists statement. How can I do that ? I unable to do that from my query show
below
declare @bln

I was wondering if it is possible to use a variable in the from part of a
select statement as in...
select *
from @myVariable

I have started a server in sql2002 named SERVER1.How can i start
another one new service in same enterprice manager SERVER2.
I tried new sql server registration but its asking for the existing server
name.

I would like to have a subquery where I'm comparing 2 values from the
subquery to the main query and unsure on the syntax.  I know in Oracle sql
it's something like
WHERE (manager_id , dept_id) IN (SELECT manager_id, dept_id FROM table ...

This problem is about N prefex in a non-unicode database.
Collation name of the database is "SQL_Latin1_General_CP1_CL_AS".
Though the database is a non-unicode database, our application generates
N prefexed (before the string constants) queries. This is because, our

Hi, all
I have one big table with  190 columns (!), there are user's data stored in
that table.
Now, there is a form on which i can select criteria (around 30) for

I just started to work with sql server 2000. I want to write a query
against "datetime" columns in the sql server 2000 database. I am to be
able to do the following with the sql server 2000 "datetime" columns:
1. Be able to access the date portion only.