Run the following code from SSMS on the server that you're trying to run you call from...

EXEC xp_cmdshell 'WHOAMI';

... then tell us who or what that login...

You bet and good talking with you this morning!

This should do it for you... as is typical, the documentation is a lot longer than the code.

 CREATE FUNCTION dbo.Convert_EE_FileName_TimeStamp_to_DATETIME2
/*********************************************************************************************
 Purpose:
 Convert the timestamp embedded into...

It's actually got a name for that type of process... "Relational Multiplication".  The code that Des Norton wrote above will absolutely do the trick.  It's also known as a "Cartesian...

I don't have any help to offer because I don't build CLRs on our systems and so have zero experience there.

As a bit of a sidebar, though, what does your...

I don't have the links for them but I've recently read a few articles that say the turning off page locking for the table did the trick nicely for them. ...

Like I said on the other thread with the identical name (Note: there is zero need to double post on this forum)...

This sounds like either a "Connection Leak" or a...

This sounds like either a "Connection Leak" or a "Memory Leak".  A "Connection Leak" is where no connection is ever closed and everyone gets a new connection (which take memory)...

I agree... great post but it should be an article.

I also add...

6. While even Microsoft hasn't followed suit, NOT using semi-colon terminators has been deprecated since 2005 came out.

7.  Both...

I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...

https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2

I'm not...

I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...

https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2

I'm not testing...

Thanks for the reply, Frederico.

I don't know about folks being "trolls" but I've never seen anywhere on this...

The SQL Server documentation says that "global temporary tables are visible to all sessions" and it doesn't seem to identify a work around.  That also means that you cannot assign...

I'm curious... have any of you that said that you'd be happy to do reviews of articles ever been asked to do an article review?

It's better to NOT drop TempTables.  The "schema" can be reused even though they go out of scope and "disappear" at the end of each session.