> I have ner seen this........
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]'FirstName' is not a
> recognized OPTIMIZER LOCK HINTS option.
You may have a query which lists tables, one of which is named "FirstName",
but before "FirstName", you omitted a comma. SQL Server will take advantage
of optimizer hints, if you provide them. For example, if you wanted a query
to ignore any locks on a table during a select, you could do this:
SELECT abunchoffields
FROM mytable (NOLOCK)
Your error indicates that you've got something after your table name which
looks like an optimizer hint.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
