Perhaps database mail is lacking TLS 1.2 support: https://support.microsoft.com/en-us/kb/3135244

This should impede DBAs

CREATE TRIGGER [DontTouchMe]

ON ALL SERVER

FOR CREATE_DATABASE

AS

IF CHARINDEX('D:\', EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')) > 0

BEGIN

ROLLBACK

...

maxversion_at_cleanup refers to the maximum lineage that has been cleaned up by merge. The higher its value, the more that has been changed. I think a high maxversion_at_cleanup value is...

To concatenate multiple rows into one row, with one example result (for use with sys.master_files) being

MOVE 'MyDataFileLogicalName' TO 'C:\ThisNewFolder\MyNewFile.mdf', MOVE 'MyLogFileLogicalName' TO 'C:\ThisOtherNewFolder\MyNewLogFile.ldf'

search for "for xml path stuff concatenate"

Taking the errors at face value - replication was experiencing a networking (not a SQL Server) concern, perhaps rooted in name resolution. There are better forums for T-shooting a networking...

If you can, in 3 loops (preferably with each loop in its own UN-nested transaction, preferably using DELETE TOP, and preferably with a waitfor delay in each loop) delete all...

One way around this error is to harness temporary tables, because they have session-level scope.

You can create a #temporarytable before you EXEC sp_ProcedureA. You can then ALTER PROC sp_ProcedureA...

I wouldn't be overly concerned about the fact that you are dealing with merge replication. It's a client to SQL Server, just like any other client. It has no more...

Afraid I do not understand your concerns. Can you provide some references? Perhaps start with references from https://msdn.microsoft.com/en-us/library/bb522824(v=sql.110).aspx and its cross-references, and perhaps best to quote sentences which...

Breaking up the query changed results. For example, the predicate

nt on a.ArtworkId = nt.ArtworkId

was not tested.

And to be sure that T-SQL is what SSRS is running, it would...

A derived column is generated by an expression. An expression can evaluate to a constant, such as 'DTL'. No concatenation is used, or needed.

Have you read http://www.sqlservercentral.com/search/?q=dynamic+pivot&t=b&sort=relevance ?

If you have read those blogs, please post your DDL here, the DML you have tried, the results you are seeing, and your expected...

There are "internal" timeouts inside SQL Server, but they are invariably not raised to any client by SQL Server. Instead, when an internal timeout does not result in SQL Server...

One key difference between the tested methods appears to be the methods' security contexts. Replace your batch file with a test batch file that redirects WHOAMI.exe output to a text...

In SQL Server Configuration Manager under SQL Server Services right click SQL Server click Properties. Under Log on as: you will see the startup account. This should be the...