i think we are just dealing with high ascii here, char 126-255, so switching to nvarchar shouldn't have an impact; i think it's just collation  and case sensitivity.

try this:
this is explicitly finding the ascii value, and replacing them; it's a modification of a strip high asciii that i had made previously.

note there are some...

your database is case-insensitive, so ?,S,? and s  (four different versions of S)are found in the last replace.

you want to modify the proc to use binary collation instead

If there was no random requirement, this sounds like a bin packing problem...grab an unknown number of rows until they add up to either exactly $4000, or as close as...

as others have identified, the object was renamed with sp_rename.

OBJECT_DEFINITION and the definition in sql_modules are what is actually saved/stored.

when you go through the GUI, the...

if i try to connect to an explicit wrong port, i'd get a connection timeout error, even if the SQL Browser is running.

TITLE: Connect to...

I'm assuming that your column [START DATE] is what determines the order on a Per Id basis;
here's soemthing i slapped together, does this get you closer?
i had to...

the browser service helps application sort out the right place to connect.

so assume that something is connecting with a connection string like this, and your sole SQL server...

I'm a bit confused by what you mean when you say "Not sending data" when connecting via a port vs working file when using a named instance. i would expect...

are you sure you've assigned a static port in the SQL configuration manager?
The SQL Browser Service tells incoming connections to your instances which port to use, whether it's static...

i think your group by needs to round the timestamp to your interval of  20 seconds(DATEPART(SECOND, datetimestamp) %20, i think?)  or at least to the nearest minute, which is a...

I've seen far too many SSAS experts leave out foreign keys in the sources they build to fill the cubes,because they think the source it's coming from already has referential...

COPY or MOVE? there's a difference!
copy duplicates the data, so you have to script all the objects out, change the schema in that script , and create the objects...