Oh, yeah, I'm in another thread on this:

Not able to create tasklist in Sql Server Management Studio

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4a160d5f-b390-4583-bab4-eb7596729088/not-able-to-create-tasklist-in-sql-server-management-studio?forum=sqlgetstarted&prof=required

1. It looks like Microsoft is moving towards getting rid on Task List. In SSMS 18.6 it is not on the View menu anymore, though it can be accessed by...

Thanks,

I did a little research on the Task List, and it seems like it is something that has been broken since SSMS 2017: Task List seems incomplete.

My coding often...

The link above to vote is dead now that MS discontinued Connect and moved to UserVoice. Here is the the updated link to the topic:

Task List seems incomplete

https://feedback.azure.com/forums/908035-sql-server/suggestions/32899060-task-list-seems-incomplete

You can complain to Microsoft here:

https://feedback.azure.com/forums/908035-sql-server/suggestions/40394743-replication-monitor-no-longer-automatically-connec

We use OUTPUT for capturing new key values added. When I started there was code like this:

CREATE PROC dbo.TheProc
  @InputPrams datatypes
AS
declare @NewKey int;
SELECT @NewKey = MAX(TheKey)...

• This reply was modified 5 years, 8 months ago by JediSQL. Reason: Missing "MAX" in first code block

The problem is that once the total price was added, it became part of the DISTINCT evaluation.

There are two rows with 'Car', and "SELECT DISTINCT Product" would return one row...

Man! You guys have to go and take the fun out of everything 😉. But, yeah, you're probably right. Thank you.

Solomon,
I have successfully deployed some SQL CLR for EXTERNAL_ACCESS to allow Web service calls from SQL Server. Since I am a DBA and not a .Net programming expert,...

Hi,
Is there any possibility of the "The .NET Environment" table being updated to through SQL Server 2016 (and maybe even 2017)?

OK,

I was able to make this work with SQL Server 2014 and Excel 2013.

First, here's the sp_send_dbmail call:

exec msdb.dbo.sp_send_dbmail

@profile_name = 'dbmail'

, @recipients = N'XYZ@abc.com'

, @subject = N'T-SQL Query...

I have recently encountered a case where I have to process a database with literally thousands of views. In these views the first 29 columns are always the same,...

Well, most of the data in the remote views does pass muster, so we end up pulling most of it. Thus, it is more efficient to get all the...

As I mentioned above, I get and store the sys.objects/sys.columns meta data for the remote views first, so I do have the column names. I use that to dynamically...