Some default traces last longer than others. If your applications are well designed and don't constantly perform DDL operations, then you've a fighting chance of having a few days'...

You can try the default trace. It's usually stored in the same folder as your errorlog and SQL Server Agent log files. You can open the file with...

Yes, that was my question, as yet unanswered. Also, it may help to investigate this part of the error message: "Multiple-step OLE DB operation generated errors".

John

Your test data script doesn't work. But anyway, have you tried the NTILE function?

John

What is the query in your jobstep that is causing the error? What do you get if you run this query?

SELECT name, product, provider, data_source, location, provider_string, catalog

FROM sys.servers

John

Selectivity of the columns that make up the index key, not of the table itself. So if your index key only has a small number of distinct values, it's...

Oh, I see. I'm afraid there's no way of doing that, as far as I know.

John

Then I'm afraid there's no easy answer. You're going to need to go through that column and clean it up. Once you've done that, change the data type...

You want running a report to cause a job to stop? Not something I'd recommend, but if you want to do it, just put an sp_stop_job command at the...

What do you want to do if the result is Cancelled - show Succeeded, or show the most recent non-Cancelled outcome?

John

If you only need the time portion for ordering, you should be OK just converting to int:

ROW_NUMBER() OVER (PARTITION BY DIA.reference ORDER BY dia.entry_date,CAST(dia.entry_time AS int))

Of course, it all depends...

If I remember correctly, when data is imported from Excel, it only looks at the first half dozen or so rows in order to determine the width of the columns....

Sounds like the data in your spreadsheet is too wide to insert into at least one of the columns in your table.

John

Have you tried what it suggests in the error message?

John

If you usually only have one file in your folder, you should be able to get its name quite easily using xp_cmdshell, Powershell, or your favourite other scripting tool. ...