With regard to ignoring rows already processed in subsequent iterations, xp_readerrorlog includes a start date parameter.  You can log in a table each use of your process, and then include...

I think you probably need to look at Change Data Capture or security auditing, although I think the latter capture DDL, not DML, changes.

John

Good spot.  A well-designed table would have a CHECK constraint to stop that from happening.  (Un)fortunately, though, it doesn't change the logic of this query, since we're only need to...

...
WHERE MONTH(startdate) = MONTH(enddate)
AND YEAR(startdate) = YEAR(enddate)
GROUP BY
     YEAR(startdate)
,    MONTH(startdate)

Poornima

Yes, the SQL Server service account needs to have permission to access the files.  I think the problem may be to do with your attempt to create a...

The answer's yes, but only because I think you asked the wrong question.  You can truncate a table that has a foreign key constraint, but you can't truncate a table...

You can still do that without a cursor by using a WHERE clause in your delete statement.  It's difficult if you can't share all your code.

The answer your...

From what I can tell, you're deleting one row at a time from Test_A until the table is empty.  Is that right?  Why use a cursor instead of deleting all...

SELECT
     Day
,    CASE
        WHEN [Semester Week nu] > 26 THEN [Semester Week nu] -26
        ELSE [Semester Week nu]
    END AS SemesterWeekNo
FROM #currentDates

Or this:
DECLARE @date float = 201601;
SELECT DATEFROMPARTS(CAST(@date/100 AS int),CAST(@date AS int)%100,1)

John

What do you get if you run this?

SELECT MAX(backup_size)
FROM msdb..backupset
WHERE database_name = 'toto'
AND backup_finish_date > CURRENT_TIMESTAMP - 14
AND type = 'L'

Please read about crosstabs and pivots - that will help you to get the results you're looking for from your sample data.  If you have an unspecified number of items,...