Another thing - is there a query hint to put the MAXDOP to another value? I know you can set that at the instance level, database level, and query (or...

Your powershell is wrong for that. Your convert to HTML call is happening outside of your loop. You will need your convert to HTML to be inside the loop AND...

The only thing I can think of is user permissions. Likely something with permission chaining or delegating permissions (not sure if those terms are correct, but I think so). I...

Possibly a dumb question but is your new laptop domain joined and on the corporate network (VPN or on site)?

xp_cmdshell runs server side so you would need to be able to browse the directory from the server side not your local dos command line.

My opinion though - SQL Server...

I did a quick google on that wait type as I had never seen it and was curious and it sounds like it is not exactly related to memory, but...

Just want to point out that requesting a teams meeting with complete strangers on a forum because you are having trouble with a report is a very uncommon thing to...

SQL jobs run as the SQL agent service account. It does NOT run as "sa". That is why you are getting the error. You will notice the error does NOT...

Sorry for the double post, but I just wanted to add it was a good article. I enjoyed reading it and my reply wasn't saying "don't use ORM's", it was...

What about joining on sys.objects? You could join on the OBJECT_ID(msarticles.name) = objects.object_id from objects and you should be good to go, right?

That would allow to filter out the object...

If you want to exclude something that is a row, you would need to update the WHERE clause to exclude the data you don't need. If you are trying to...

Login failed means that the account that it is running as doesn't have access to that database. In the error it lists who it is running as (LCDOM100\LCISQL##) and what...

My opinion is a bit biased as I am a DBA as well as a DB Developer (and other roles), but I have not found an ORM that works well...

The service has no access to the network share. The ONLY solutions are to switch it to an account that has access OR store the backup files locally and manually...

My opinion - data cleansing is important to most, if not all, databases. Ideally you have the DB structures set up to prevent garbage from going in, but if garbage...