I had a similar problem. Database mail apparently worked for over a year and then stopped working. The key to this was looking over the log. Some...

Just extracting the week number for the year from the date can be ambiguous depending on your business needs.

For example I wrote the back end for a major movie box...

What you actually want to do is find those rows in the table that have the duplicate values and then join that back to the table. I usually use...

To avoid the Integer zero problem I usually just CAST one side as something other than Int - MONEY seems to work just fine unless you are rounding (MONEY has...

Thanks guys. I appreciate the input.

I really can't move the update outside of the transaction - not an option.

I'll give the suggestions a try.

Todd Fifield

The problem is probably not with Views. It may very well be that having any bound form (bound directly to the table, to a view or to an Access...

Here's an actual example of why using @@IDENTITY is risky:

CREATE TABLE Test

( TestID INT IDENTITY(1, 1)

, SomeText VARCHAR(50)

)

GO

CREATE TABLE TestLog

( LogID INT IDENTITY(100, 1)

, TestID...

There could also be something really silly going on in the logic. Something like:

CREATE TABLE #Temp

( RecID INT IDENTITY(1, 1)

, SomeText ...

You should probably familiarize yourself with the debugger and step through the code. It's very good for examining variables in stored procedures.

You may very well have one of the...

I've had the problem with disconnected recordsets - mostly in MS Access where a form is bound to a table, the form does and update on the table, a trigger...

Chintan,

Thanks for the advice. I'll try the port change today.

I'm a little confused at the 'username@gmail.com' advice. We use the business feature where our domain name is part...

Could you please post the actual query along with the table definitions.

Todd Fifield

Not to be picky, but a single primary key can contain more than 1 column.

Todd Fifield

The following query will give you all of the Primary Key columns for a table:

SELECT

PK.TABLE_NAME AS Tbl, PK.CONSTRAINT_NAME AS PKName

, KC.COLUMN_NAME AS Col, KC.ORDINAL_POSITION AS OrdPos

FROM

INFORMATION_SCHEMA.TABLE_CONSTRAINTS...

The table with the names of the tables to link are in the Access MDB. I call it TablesToLink. It just has the names of the tables in...