error 21271 in MS SQL Entreprise Manager

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I'm creating a table with columns names : 1- 'id vein' 2- 'ph'

When i'm opening the table in MS SQL Entreprise Manager, i receive this error message :

error 21271 : The name 'id vein' is not a valid object identifier, or is not a valid format for this property or method.

When i'm using Access to open the table i don't receive any error message.

What should i do to avoid the error message ?

thank you.

-- Anonymous, October 27, 1999

Answers

Kim Thanh,

Your first column name has an embedded space, as such, it must be enclosed in double quotes rather than single quotes. Every time the column name is accessed, the name must be surrounded with double quotation marks (") and the session option QUOTED_IDENTIFIER must be turned on.

SET QUOTED_IDENTIFIER ON go

Hope this helps,

Eric

-- Anonymous, October 27, 1999


Moderation questions? read the FAQ