> Well the only other thing I can think of is to log to a character format
> (CSV etc.) and edit the file by replacing those offending quotes with
> something else before importing with Relog to the table.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "PetitGosaimass" discussions.microsoft.com> wrote in message
> news:FFE6B1F0-33A8-4C3C-984F-434FCA1ED14F@microsoft.com...

>> Andrew,
>>
>> I tried csv, tsv, blg and circular blg...it doesn't make any difference.
>> Still the ' error.
>>
>> Any other possibilities ?
>>
>> Xavier
>>
>> "Andrew J. Kelly" wrote:
>>

>>> What type of file are you using to log to, Binary? All I can think of is
>>> to
>>> try different file types to see if there is one that works better with
>>> ODBC.
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>> Solid Quality Mentors
>>>
>>>
>>> "PetitGosaimass" discussions.microsoft.com> wrote in
>>> message
>>> news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...

>>>> Andrew,
>>>>
>>>> thank you for this answer.
>>>> Yes, I log striaght into SQL Server from Perfmon.
>>>>
>>>> Following your advice, I used relog, but unfortunately, the same
>>>> problem
>>>> occurs when it tries to insert the CounterDetail line with the
>>>> containing
>>>> the
>>>> quote mark.
>>>> Same problem as with the Performance Monitor. Same ODBC Problem I guess
>>>> regarding quotation mark and quoted identifiers.
>>>>
>>>> You will find below the SQL Batch and the error caught in the SQL
>>>> Profiler
>>>>
>>>> Any other workaround ?
>>>>
>>>> Xavier
>>>>
>>>>
>>>> SQL Error
>>>> Exception : Error: 105, Severity: 15, State: 1
>>>> USer Error Message : Ouvrez les guillemets après la chaîne de
>>>> caractères
>>>> ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
>>>> AddCounterDetails'.
>>>> SQL Batch
>>>> begin transaction AddCounterDetails insert into CounterDetails values
>>>> ('\\MyServer','Disque physique','Long. moy. de file d'attente du
>>>> disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select @@Identity
>>>> commit
>>>> transaction AddCounterDetails
>>>>
>>>> "Andrew J. Kelly" wrote:
>>>>

>>>>> Are you logging directly from Perfmon to SQL Server? If so try logging
>>>>> to
>>>>> a
>>>>> file first and then using Relog to load to a table. I am not sure if
>>>>> this
>>>>> will matter or not since they both use ODBC but there may be a slight
>>>>> difference in the way Relog works over Perfmon when connecting.
>>>>>
>>>>> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
>>>>> SQL:YourDSN!YourDescriptor
>>>>>
>>>>> Type relog.exe /? for details on the commands.
>>>>>
>>>>>
>>>>> --
>>>>> Andrew J. Kelly SQL MVP
>>>>> Solid Quality Mentors
>>>>>
>>>>>
>>>>> "PetitGosaimass" discussions.microsoft.com> wrote in
>>>>> message
>>>>> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...

>>>>>> Hello,
>>>>>>
>>>>>> i am trying to to store some performance monitor counters into a SQl
>>>>>> Server
>>>>>> Database (SQL 2005 Std, on a W2K3 cluster environment).
>>>>>>
>>>>>> It seems to be working, using an ODBC Datasource with the SQLServer
>>>>>> driver
>>>>>> (th native client is not compatible with an odbc feature according
>>>>>> to a
>>>>>> message in the event viewer).
>>>>>>
>>>>>> But, it cannot return on Physical Disk Queue Length. And the reason
>>>>>> seams
>>>>>> quite simple : my server is French...thus there is a quote in
>>>>>> "Longueur
>>>>>> de
>>>>>> file d'attente", which produces this error. Same problem with any
>>>>>> other
>>>>>> counter that includes a quote ' in its name.
>>>>>>
>>>>>> And it doesn't seem that the performznce monitor sends tsql batch
>>>>>> using
>>>>>> quotes, which would have help with the quoted_identifiers ON.
>>>>>>
>>>>>> Do you have any work around for this problem ?
>>>>>>
>>>>>> Thank you very much
>>>>>>
>>>>>> X.M.
>>>>>>

>>>>>
>>>>>

>>>
>>>

>
>