Well, my workplace desktop support is useless on the SSC website issue. I am the only person in the office having problems with it but apparently the issue is SSC....

I have not. But don't they have to be set up in advance?

I found something about SQL Profiler / server trace and perfmon as well, but again, stuff that needs...

Well, I just encountered victory of a sorts. After I pushed back and told the Dev this didn't make sense that the two issues were connected, he managed to find...

Ha. I think you're right. NLTM is the method.

I want to point out this part of the code:

   SET @TSql = N'INSERT INTO dbo.PR_Archive  
   SELECT * FROM OPENQUERY([LinedServer],''SELECT Col1,...

My apologies for the mistype on OpenQuery. I spent all day querying stuff with a lot of underscores in the name. I think my fingers just defaulted to that without...

The SPN thing is a definite possibility, but why would the test NAS work but the QC NAS not work on the QC server?

That's what is driving me nuts. One...

Talking about ChatGPT, has anyone seen this one yet? https://www.cnn.com/2023/02/08/tech/google-ai-bard-demo-error/index.html

<headdesk>

And finally other documentation has been supplied by the person who mentioned this to me:

SQL Server Temporary Table Caching (mssqltips.com)

Thank you everyone for your help. I appreciate it.

Looks like I woke everyone up this morning. Heeeheee.

@=)

Forget leading commas. Let's debate leading semi-colons. @=)

Don't get me started in WITH (NOLOCK). Apparently there are a number of people suddenly making that recommendation to get rid of blocking.

It's apparently easier advice to give people than...

Phil: Someone told you that these temp table drops are expensive (in database terms), but without providing evidence, and now they're expecting you just to believe them?

The burden of proof...

Thanks for the links. I will review.

I believe that SQL renames temp tables rather than dropping them, esp. for stored procs.  That way, when the proc runs again, it doesn't have to fully recreate the...