I currently have a ms access update query that runs
perfectly well and quicly in access however I now need to add this query
to convert this qeryu to oracles equivelant sql syntax and add it to the end
of an oracle sql script.

Ok, here's my dilemma.  We're running SQL Server 2000 with the default
db setting for the ANSI_WARNINGS option set to off.  However, we still
get "Warning: Null value is eliminated by an aggregate or other SET
operation" messages.  To eliminate getting the message, we use the SET

Ok, I inherited this database and there is a field that stopres a select
statement.  Is there anyway possible to execute the value of the field
within a select statement?
For example:

How can I Identify when the procedure was updated last time.
Farhan Iqbal

All,
I have a problem regarding SQL Server 2000 SP3,
I have SP that calls other SP and it inserts about 30,000 records as a
time,

I am planning to install sql server 2000 sp4 on my clustered server
running in active/passive mode.
I plan to stop all sql services using cluster administrator, install
the service pack from the primary node and then reboot all nodes.

hello,
i m new to sql and i need to export all the settings of a base in sql 2000,
security users ..., is it possible? do i just need to backup the database and
all the settings will be saved?

Thank you for taking the time to read my question.
Does anyone know how to pull a list of user tables and their associated
fields?
To give you a better idea, I imagine the statement to look something like

I am experiencing the following problem;
I boot my Windows 2000 sp#4 machine. I check sqlservr.exe's memory usage in
Task manager. It is ca 20 mb, everything is OK. Then I run this query;
select postoffice, count(*) as counter from tblTable

Somebody accidently deleted a record with cascade deletes
and took out about 80 records.
The database has been used heavily since then.
How do I put back the data?

To set up the problem, paste this into QA:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[WorkOTRate]') and OBJECTPROPERTY(id, N'IsUserTable')
= 1)

My regards for all on this NG!
My client need to use Windows 2003 Server, but it have some databases
and systems that use SQLServer 7.0
I need to know if MS SQL Server 7.0 can be instaled and if will run

I have an application that segregates data into two different
databases. Database A has stored procs that perform joins between
tables in database A and database B. I am thinking that I have reached
the limits of Application Roles, but correct me if I am wrong.

I am a developer and I have a problem trying to design a system to
manage data coming from web surveys. Each section can potentially have
dozens of questions, i.e., fields.
I am focusing here only on the table(s) that will hold the survey data.

I have an application where I need to find out about the following
information regarding SQL server:
Processors enabled
i.    Threads allocated