Not really an advantage, they are very different, useful for different use cases. Oracle also has hybrid column compression (which is "on disk") in addition to in-memory column store. HCC...

I don't think you can import those into the event logs. You would probably need to read the rows and write those to the application log. One possibility would be...

The issues you are running into are related to cross database access. The article Jeffery Williams posted is an excellent reference for these issues. There is a section named Cross...

You'd register the SPNs using the SQL Server service account (not agent service). The SPNs for a cluster are setup using the virtual name, not the name of the individual...

The errors would usually be in the Reporting Services Trace Log file - search through the log for word ERROR to find the errors being logged.

Report Server Service Trace...

You may want to try using signed stored procedures to create the users instead of using execute as. You don't hit the same limitations with sign stored procedures.

Sue

I am running the DMV (sys.dm_db_index_physical_stats) to get the fragmentation for a database, however when I get the results the Index column is NULL for 3 tables even though...

If you are using one where you deleted the signature block, it's not doing anything. That block is just the code encrypted. Use a version with that block included.

Sue

On the send mail, you have a syntax error in your original post that I just noticed as the parameter is @file_attachments (plural) rather than singular. Don't think that would...

I've hit it where the process that created the file didn't finish up completely when I went to send the mail so that can happen. It could also be related...

Error number 32 is ERROR_SHARING_VIOLATION so something else is accessing the file when you go to attach it.

Sue

<li style="list-style-type: none;">

This gives me a list of SQL users I have for this database. However, I searched for various GRANT statements and cannot find how to map...

Background:

I currently have 1 publisher with 100 articles published (SQL 2012) to 1 subscriber (SQL 2008).

I have a new server SQL 2016 which I wish to set up a...

It depends on what application they use to connect but you generally get that error if they have selected or use SQL Server Authentication and pass in their Windows login...

After you do the sp_dropserver, sp_addserver, etc you need to restart the service for the change to take effect.

Sue