You're not going to like this...

The problem is that there's a lack of support for the Jet engine in 64-bit environments. This is a headache we've run into a...

I would *highly* recommend against using a domain administrator account to run your SQL Server services. And also it's really not good to use the same password for sa...

You might be best off controlling this via the MS Access front end. A little VB to lock the field once there's a valid value in there could go...

It looks like the first procedure does a refresh of the Customer_Profiles table and then inserts records one at a time back in by calling the other two procedures to...

Please don't cross-post in multiple forums. Posting in a single forum will almost always get an answer.

That being said, John's right. Your cursor is the 900lb gorilla of...

It's worth noting that if you have tables which don't have clustered indexes on them, they will not be displayed using that method. Lord knows you should never have...

Could do something like this:

CREATE TABLE #tbls(

tbl_nameSYSNAME

)

exec sp_msforeachtable 'IF (SELECT COUNT(*) FROM ?) > 0 INSERT #tbls SELECT ''?'' '

SELECT * FROM #tbls ORDER BY tbl_name

DROP TABLE #tbls

Maybe I'm not understanding you right... Why don't you add some sort of primary key to the table and then delete?

i.e.

DELETE x

FROM mytable x

JOIN mytable y

ON x.column1 = y.column1

AND...

You need to drop or disable the foreign key constraints on the related tables which reference the primary key of that table first. Then you should be able to...

I've run into a number of issues like this, most frequently related to Excel. The way I understand the issue is that there's a guessing process which looks at...

Why not do this?

WHERE DATEADD(dd, -1, datevalue1) = datevalue2

This one is pretty easy to figure out if you check BOL first... read up on the entry on date functions. But this should work:

SELECT ...

Well, it's possible that if there are several columns in the index it won't be considered in the query if only one column is in the list. If possible...

Perhaps you can post the query?

Is the INVOICENUMBER column the only column specified in the index?

Per-processor licensing would be the number of physical processors. So a dual-core processor would only count as 1 processor even though two logical processors show up in the system.

You...