So I haven't been able to consistently post for a while because stupid issues with website or browser (not sure which, but I didn't actively change anything). And now for...

Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS. No...

I am not using that silly new name for The Platform Formerly Known as Twitter.

YAY! Website...

I'm not sure. I wasn't the person who did the original server move / install. I will go back and check, though. Thank you for this information.

A brief glance at...

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. @=)