Jack Corbett (4/7/2008)

---

bitbucket (4/7/2008)

---

Getting tired, so very tired of sloppily worded questions ...

dob not defined as a column name in the table or for that matter anywhere in question...

Steve,

Here is an example of what...

Just to keep you updated, here is MS's response to the Connect post:

Greetings from Microsoft Connect!

This notification was generated for the following Feedback item:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335613

which you submitted at the Microsoft Connect...

bitbucket (4/7/2008)

---

Getting tired, so very tired of sloppily worded questions ...

dob not defined as a column name in the table or for that matter anywhere in question ... so...

webrunner (4/7/2008)

---

Jack Corbett (4/7/2008)

---

I just have a couple of questions for all who have posted about this issue, did you respond to the QOD survey that was released recently? ...

I just have a couple of questions for all who have posted about this issue, did you respond to the QOD survey that was released recently? Also have you...

Are you logged into the GUI as a serveradmin or sysadmin?

abcdefghy (4/6/2008)

---

Thanks Jeff,

We don't have a Primary Key defined on the table.

We do have a unique clustered index on (LOCATION, ITEM, DATE).

Should we define this combination of columns as the...

abcdefghy (4/1/2008)

---

Thanks, Jack.

Yes, we do inserts into this table, and rollbacks are possible. However, we don't really need the 'exact' nth item.

The business reason: We have an application...

It was not clear to me that you knew what data was causing the problem. In this case ignore error works fine as you have no data there anyway....

Adam Haines (4/4/2008)

---

If the table has an identity field with seed, why are you trying to insert a value for it? I do not see why you need to...

When you say no value do you mean there are Null's or that one or both are 0? It would help if you posted some example data like this:

Create Table...

Is this particular table only populated by copying rows from you local server to the remote server? If this is the case I would alter the table on the...

You need to post this in a SQL Server 7, 2000 Forum.

You could do an Execute SQL Task that has a simple query and if it fails set the On Failure Precedence to go to a task that possibly logs the...