Hi Frederico,

BTW. I tested 18.5 and...

current version is 18.10.

see: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Could you please share a screenshot how you debug SPs?

AFAIK you can only use Visual Studio to debug SPs, not SSMS 18....

See also:

https://stackoverflow.com/questions/56565764/how-do-you-debug-or-step-through-the-code-in-sql-server-management-studio-18

I don't have a workaround for the data link sample.

But when using .Net applications you have to add the Tls12 to the security protocol:

Net.ServicePointManager.SecurityProtocol = Net.ServicePointManager.SecurityProtocol Or...

BTW. you forgot a very important feature for developers: debugging stored procedures. SSMS 17 still can it, SSMS 18 not - ADS? That feature is more important than the other...

No words about Microsoft dropped the SQL Debugger in SSMS 18. This is really an import feature.

see: Put Debugger back into SSMS 18

Patrick

• This reply was modified 5 years, 6 months ago by PatrickSimons.

Jeff Moden (6/9/2015)

What problems have you had there? Or are...

I agree 100%. Especially when you SELECT INTO inside a transaction to a temporary table (##) = worst case....

What about locking system resources when using SELECT INTO?

SELECT INTO was sometimes disadvised...

I got some help here:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b72d0430-44ff-4ded-a3f2-04591ff32bcc/xquery-syntax-to-evaluate-math-formula?forum=transactsql

Sure everything can be cracked, also local systems. But companies have (or...

But: is the cloud really secure ??? Everybody's moving to the cloud, companies or private persons are putting their data, also sensitive data, outside on a server somewhere in the...

any gurus out there?

Any idea how to clean/initialize the outputbuffer?

Found a script that works using DBCC OUTPUTBUFFER

http://www.sommarskog.se/error-handling-I.html#textretrieve