the fix for sql users is easy; use the procedure from microsoft to script out the users:
https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server
in my case, i drop my sql logins and just recreate them...

yeah the items in the article barely merit a nod in acknowledgment , as far as considering them disadvantages.
 i couldn't call any of them show stoppers, or identify what...

post migration, it's mandatory to rebuild all your indexes ; the statistics are different than the new sql engine expects, andyou'll see poor performance until you rebuild your indexes and...

back in SQL2000 days, there was an undocumented flag DBCC TRACEON(257) that would format xml when sent to text view; you could try that, but I'd bet you need to convert...

i had to google it myself, as my answer would have been to identify the advantages i know of instead...the things i thought of was compiled/faster code,ability to tune, code...

whatever is passed to xp_cmdshell needs to be wrapped in single quotes!
EXEC master.sys.xp_cmdshell 'bcp "SELECT * FROM MONITORING.dbo.SIZEOUT" queryout D:\DBSizes.csv -c -t, -r \n -T '

helpful consumable format, still working on the solution:

IF OBJECT_ID('tempdb.[dbo].[#ICA]') IS NOT NULL
DROP TABLE [dbo].[#ICA]
GO
CREATE TABLE [dbo].[#ICA] (
[MsgDateTime] DATETIME            NULL,
[UserName]  VARCHAR(255)               NULL,
[Application] VARCHAR(255)               NULL,

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...