Recent content by PeteBull

Thanks for your help George. I have implemented your changes to the view and tested successfully. Best of all, I learned something new today.

George, that worked like a charm! Thanks for all of your help in tracking this issue down. The offending row had a 00 in the month position. That row is gone now (no loss as the entire row was corrupt). I appreciate your offer to help with the view. Here are the date and time column for the...

date = nchar(6) time = nchar(4)

Here is the code for the view: SELECT cond_code, CONVERT(DATETIME, SUBSTRING(date, 1, 2) + '/' + SUBSTRING(date, 3, 2) + '/20' + SUBSTRING(date, 5, 2) + ' ' + SUBSTRING(time, 1, 2) + ':' + SUBSTRING(time, 3, 2) + ':00') AS Event_End, CONVERT(INT, LEFT(RIGHT('000000' +...

yes it is a view

Select system_type_id, is_computed From sys.columns Where object_id = object_id('table') and name = 'event_end' system_type_id = 61 is_computed = 0

I am getting the following error message when attempting to sort results by a datetime column: "Msg 242, Level 16, State 3, Line 1 The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value" here is the query: select top 100 * FROM [table] order...

I thought queue limit was only for attendant groups???

I was originally told by support that it was an ACK problem (on the OCS side), so it sounds very much like the problem I had with OCS (perhaps in reverse). I had to remove the codec from OCS though, not CM.

sorry if this doesn't help, but when I had an issue getting MS OCS 2007 Speech Server working with SES on my 5.2.1 system I had a talk path issue that ended up being a codec problem/mismatch. I had to remove the codec from the options on OCS. I wish I could remember which codec it was...

I think that starting with Definity Release 11 the product was renamed from Definity to Communication Manager, but the phone system software naming convention was the same, so Definity R011 was Communication Manager 1.0, etc. It is common for software companies to have a real name and a...

it looks to me like that system is running CM 5.1.2

If I remember correctly: R = Release 015 = Definity version 15

the phone will use a medpro to communicate with the far end instead of communicating directly.

try this app note... http://support.avaya.com/css/P8/documents/003941272