Have you tried "Run as administrator"???

Grant the account that cannot see the logs access to the folder where the logs are stored.

On my local machine, that's C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log

• This reply was modified 2 years, 8 months ago by Michael L John.

I'm with Thom.  Show us the rest of the query.

Even if a loop is used, why do is there a requirement for consecutive numbers? Instead of incrementing @VinCounter, query for...

Here's an idea.  Create multiple views that break the data in the large tables into smaller pieces. I think you can map these views to the destination table.

Instead of changing the clustered index, can you add another index?

We do not know.  You need to tell us.

What account is SQL Server and  SQL Server...

Yes. We have already said this.

Hi

In case of SQL Server Failover Cluster we get  sql server cluster log by executing command get-cluster log .

Can we get saem in case of alwasy-on log or there...

Not sure if I have got the logic right, but please try this query:

SELECT CONVERT(CHAR(7),EOMONTH(J1.EntryDate)) AS Per, SUM(J1.RunTime) AS TReg, J2.TNQ
FROM Db1.dbo.WipLabJnl J1
OUTER APPLY (
 ...

You also forgot to enclose your strings in single quotes.

Hmmm. Not that I can see.

I tried both of your suggestion but I still didn't get the desired results.   For the first one, I get something like

....

2019-08            3853.480000   ...

Ok so the only possible issue is permissions are missing somewhere?

I have checked the file using notepad and any locations mentioned I have given full control so I am...

Not true.

Think about it. Your...

Thanks for the response Michael. There are many more attributes in our customer table than just sales rep id. The customer surrogate key s/b the only key in the...