Great! It worked withal old script. Our problem was outdated statistics. 😉

UPDATE STATISTICS CallInfo

UPDATE STATISTICS ImageInfo

GO

Matt Miller (21/09/2007)

What's the clustered index on the table you're querying?  Are all of the latest records being written to the end of the file? Probably Yes. Are there locks...

Interesting! I tried that and I found 79 pieces duplicate values.

Then. I'm trying some values from duplicate values...

Hello,

I ran the query below and I get the error message.

select Msg_ID, count(Msg_ID)

from AgentsStateChanges

group by Msg_ID

having count(Msg_ID)>1

Server: Msg 409, Level 16, State 2, Line 1

The count aggregate operation...

Matt Miller,

The account which is used in the application does not have writing authorization.

Database is only for to list and listen the voice records.

Issue is that it takes...

Hi Matt Miller,

When i run the  script  below   TSQL server turns query form.

Part of code:

 Set objImageInfoRS = Server.CreateObject("adodb.recordset")

 'Set to use client-side cursor

 objImageInfoRS.CursorLocation = 3 'adUseClient

 'Set objConn = Server.CreateObject("ADODB.Connection")

 'objConn.Open strConnect

 strError =...