I'll try to be as kind as I can about that stored procedure. It's nicely laid out.

The problem with repeated rows is (probably - I don't know what your...

OK, that looks like it has been successfully switched off.

Could you run this please

SELECT * from fn_trace_getinfo(0)

Could you give us the results of this query please

SELECT *

FROM sys.configurations

WHERE name = ‘c2 audit mode’

It sounds like it didn't get switched off, and this should tell...

I don't know if this is the answer to your issue but it has a resolution to a similar issue in 2012. Seems like permissions/registry.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bc1d8e04-723e-4340-9595-c94dced8580a/failed-to-start-debugger-data-is-null-sql-server-2012?forum=sqltools

Do you have C2 auditing switched on?

I think I understand.

I've definitely seen the 'Current - date time' display part be inaccurate, or not what I was expecting. I think it reflects the 'date modified' property...

I'm not quite following your question but there are differences between the Agent Log and the Error Log

The current Agent log file is named SQLAGENT .OUT, archived files are numbered...

I think that is an internal process from SQL Management Studio. It probably populates the tree structures in Object Explorer

Hi,

I'm sure someone will help you but you'll need to provide more information and correct some errors.

Could you post the DDL for your 3 tables AND fill them with sample...

Is all the data in these two tables 'active'? Is there any way you could partition the tables either the the old fashioned way by creating a history table and...

Looks like you solved it yourself by putting the question out there. It's a pretty good strategy when you're stuck. 🙂 Well done.

sqlnaive, I have just fired your script through the sql debugger, It resets the index to -1 after reaching the end of the string, so your algorithm starts again looking...

Maybe I could start you off with a function to return the date that their status became active (at a given date) CREATE FUNCTION dbo.fn_maxEffDate (@periodDate DATE)

RETURNS TABLE

AS

RETURN

SELECT max(effectivedate) as...

The tooltip showing the datatype is a quirky feature that sometimes returns the wrong information. The reason it is showing INT is because it thinks SUM returns an INT. It's...

Is it the days per each month bit that is causing you trouble? If so, you can use this

select DATEDIFF (DAY, VoidStartDate, EOMONTH(VoidStartDate) ) from table1 where Propcode...