Well, all csv files belongign to a specific table are structured the same. BUt based on some characters in the file names, they are differently structured nad go into different...

ok thanks, I already went thru Google search and did not find anything specific.

There are multiple csv files and depending on naming convention of a part of the file name,...

There may be 3-4 csv files in each run. The names may not be constant, but the issue is that the process will be run such that, another system will...

A list of relevant views is inserted into a temp table and then looped thru each of the entries using a cursor.

Thanks it gives me more info. But still if I filter by the SP as a referencing object, it does not point out the views being called by that SP.

In the old machine, the users came in as network service. No individual logins were set up.

Yes, that's exactly what I am looking at right now. Will post what I find.

Right but they are coming thru a web app - .net app. So they use Network Service account to log in.
So not sure why it is looking for domain\user...

I have basicauth turned on with impersonation enabled. No anonymous login. 
The err 
System.Data SqlClient.SqlException: Log in failed for user 'domain\user name'.

Error: 18456, Severity: 14, State: 5.
2019-02-25...

That client is a web client. They do not need to install anything.
But I will update my SSMS to the right version in your link. And see what...

Thanks Eirikur, the machine that is rebooting is indeed the client and not the server.

Thanks Jeff, all your points are well-taken....

Thanks Jeff, but the code is being transitioned to something bigger nad better so no effort on throw-away code.

Turns out some DBCS characters were causing the havoc. 
I removed that data for testing and it worked. 
Thanks.

Thanks all.
I used the below.

select ec, ev, er,
  count(ee) as ct
into #temp
from master m
group by ec, ev, er

DECLARE...

Thanks everyone, I know what I have to do. There is no short-cut, have to bite the bullet and change all varchar etc. to nvarchar, etc.