Try QuoteName. From BOL:

Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server 2005 delimited identifier.

Transact-SQL Syntax Conventions

Syntax

QUOTENAME (...

Accroding to Wikipedia:

ASP - Active Server Pages

Yes it means that there is not...

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...