We are using sql server 2000 and have found that some of our
constaints between tables are no longer there.  This has happened a
few times over the past few months with different tables.  Any ideas
as to why this might be happening?

strSQL = "UPDATE [tribidz].[dbo].[TBL_Items] SET" & _
                " item_itemsoldprice = " & PrepareStr(PutPriceAsSold) &
_
                "FROM TBL_Items " & _

first of all i am a student, so i want you to be a little mercy, because this is soo important to me !
second i got a real project that archieves the materials of a club in my univercity..
it will store the related information of photographs, CDs, cassettes, etc.. in one computer( ...

I have an ASP.NET application which allow registered user to set-up
notifications, saved into an SQL server database.
I want to make a win service which periodically check this SQL server table,
and send e-mail at the moment a notification is scheduled.

I have a question about CLUSTERED INDEX. When we use ORDER BY in a clustered
index column , we found out that optimizer skips the sorting since it get
the records in sorted manner.
My question is that on multi-processor server does the SELECT return the

I am new to SQL server and unsure of the best way to build output from
multiple tables and ouput with a single procedure.
The requirement is to build a single porcedure which combines data
from 2 tables which are in a one to many relationship. The output

I keep getting this with this.
First, heres my sql string:
SELECT item_itemcurrentbidprice, item_itemcurrentorpurchasedbidder FROM
TBL_Items WHERE item_itemnumber = 'b4e81177-35dd-44d7-b996-8e285103f11a'

I have two querys that work fine so I joined them with a Union and I get
The text, ntext, or image data type cannot be selected as DISTINCT.
So I used union all and now get
All queries in an SQL statement containing a UNION operator must have

Hi, I need to select all the Null values in a coloumn but cant work out how to, ive tried all sorts such as SELECT * FROM Kits WHERE KitExpiryDate = NULL and lots of other combinations but it doesnt seem to work. Is there a special way to select NULL values. I hope someone can ...

Is it possible to print data using an SQL statement or stored procedure
Any suggestions would be welcom
Thank
Sandro

I want to run a query to find the dependencies, preferably variable names
and types, of user created stored procedures. I know that I can filter the
stored procedures out of the sysobjects table, but I do not know where to
find the dependancies. Any help would be greatly appreciated ...

I have the following table....
it stores points ,, as in currency type points.. or credits.. whatever you
want to call it.
CREATE TABLE [Points] (

So my ADO.NET application  (using OleDb provider) sometimes has query
timeouts on INSERTs and the only way to get it working again is to reboot
the computer.  This happens very infrequently, typically weeks or months
apart.

Why should the Create Procedure be the first line of every batch? I
don't understand the reason behind this requirement.
Thanks for your help.
regards,

i am finding that for stored procedure output parameters of type char, blank
values are returned as nulls .... which is not what i expected ...
CREATE PROCEDURE dbo.usp_GetMaxLocationNumber
(