MS SQL Server - RE: Question as to why dates have two quotes as ''2006-09-26 17:05:30:

Author

RE: Question as to why dates have two quotes as ''2006-09-26 17:05:30:

John Bell

2006-10-24, 6:37 pm

Hi Ben

I don't seem to be able to reproduce this and the other post seems to imply
it is possibly related to the environment in which it is run. Could you
please post a method of reproducing this?

Also check that the client tools are at SP1 and what the environment
settings are.

John

"ben brugman" wrote:

> This question was asked in the microsoft.public.sqlserver.programming by
> 'Farmer'.
>
> I found the question by Googling, this confirms a problem we have, but there
> were no answers to why this is happening, or what a solution is to this
> 'problem'
>
> The problem :
> Making a tracefile with SQL-server 2005 profiler with the TSQL replay
> template,
> contains double quotes around every date parameter. To replay you have to
> edit
> the double quotes.
>
> Because I could not find an answer,
> Why is this ?
> Is there a solution, so that for replay you do not have to edit ?
>
> Thanks for your time and attention,
> Ben Brugman
>
>
>

ben brugman

2006-10-24, 6:37 pm

> Hi Ben
>
> I don't seem to be able to reproduce this and the other post seems to
> imply
> it is possibly related to the environment in which it is run. Could you
> please post a method of reproducing this?
>

Although we can reproduce the effect on our installation, we are no
control over this installation and can not reduce the problem to a
simple example.
(The product is deliverd to us as is. Offcourse we did report the
'problem' to the developers. But they have not come up with a solution yet).

> Also check that the client tools are at SP1 and what the environment
> settings are.
The environment :
It's a DOT Net framework 1.1 environment.
Developing is done in C# under VisualStudio 2003.
Dataprovider : ".Net SqlClient Data Provider"

Thanks for your time and attention,
Ben
[color=darkred]
>
> John
>
> "ben brugman" wrote:
>

Sponsored Links