Interestingly,

(and I used the NORTHWIND Employees table and setup the same way you had)

SELECT * FROM #Test_Delete

WHERE MyId  IN

(SELECT MyId FROM dbo.Employees

WHERE MyID = 1)

actually returns the record in #Test_Delete...

I see what you mean.  Not good.

Yours is the standard client/server application.  Each user having his or her client, that accesses data from a server, in your case SQL Server.  This paridigm is notorious for the...

If you are going to take on a project to update your code base, I suggest using ADO or even ADO.net as opposed to DAO.  Microsoft has all but abandoned DAO...

I did know that one.  But one good source is enterprise manager.  You can use the create diagram wizard to add tables to your diagram and using drag and drop create...

You may be able to avoid the case statement altogether. Try:

select DateName(mm,birth_date)

Hope this helps,

Pete

here ya go Steve,

ALTER TABLE user_detail ADD CONSTRAINT

 FK__user_header__user_detail FOREIGN KEY

(user_id)

REFERENCES user_header

 (user_id)

NOT FOR REPLICATION

sorry 'bout the formatting.  the smirking face is an open paren.

i SEE WHERE YOU HAVE ON UPDATE CASCADE.  BUT YOUR SCRIPT DOES NOT INCLUDE ON DELETE CASCADE.

have you tried using the fully qualified names in your query?

Try this Grasshopper:

SET @Query_tmp = 'BULK INSERT dbo.dbAnntest FROM ' + @TmpLocation + ' WITH (FIELDTERMINATOR = ''\t'', ROWTERMINATOR = ''\n'')'

NOTE: What appears to be double-quotes are actually 2 single...

Hi,

DTS scripts range from the sumblime to the extremely complex.  So without knowing exactly what you are trying to do, here is a link that might help you out:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspcust_5ru3.asp

try

app.name

Am I understanding correct that this database has a table named "Table" and another table named "Tab" ? 

I would like to be able to perform a check on a field called Quantity in OrderDetails Table. I want it so when the user enters a quantity for a...

It would be helpful to know what is on line 1408.  Does your DTS use Execute SQL Tasks?  If so, check the stored procedures being called.  Perhaps run them in...