Another alternative might be to create a signed stored procedure(s) that add users to the roles instead of depending on using SSMS for the user to add members to those...

Multisubnet had some issues with that error so you can search for that if you are using that.

Virtual machines had some issues with that error and backups, I think it...

It's already granted to the role. Haven't checked for awhile but for the history it should execute sp_help_jobhistory when checking the history in SSMS. Is the user using a current...

Based on your questions though, you don't really know what it is. That's the point. Why grant permissions on something you don't know anything about? Seems that's just as dangerous...

My advise would be to learn more about what it means to recompile, when and why you would...

Could be a bug. Check this blog post on SSC and make sure you are on the correct patch:

"A connection timeout has occurred on a previously established connection to...

It's not necessarily needed in that scenario. In transactional replication the snapshot agent is used for intializing the schema, data of the publication by creating the snapshot files. Those files...

Did you check the redo queue? You can get that error with any type of availability group when the secondary falls behind or the redo thread is blocked...scenarios along those...

You can reinitialize using the existing snapshot when the files are still there. Otherwise, the distribution cleanup job deletes the files. The default is to clean up files older than...

When you select to initialize the subscription immediately then yes you need to wait for the snapshot to finish generating all the articles.

Sue

If it's generating and applying the snapshot that is taking awhile, another option is to initialize replication from a backup:

Initialize a Transactional Subscription Without a Snapshot

Not sure what you...

You can't use an aggregate in a calculated field but you could do something like this with an expression in a text box. It doesn't have to be in the...

It's a windows feature that can be turned on.

Sue

Most likely something with the expression. But we don't know what you are using so it's hard to say.

Sue

Yep. Another vote for ping. If you can't see it in your network, you can't connect to it. Also, when you ping, be sure to specify a port...