Actually here it says an admin must do this: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-2017#SPNs

There aren't global roles across databases that are used for access. All roles would be set on a database level.

What I would suggest is that you set a...

I asked a few people and they say no.

This seems to indicate you do this manually, but doesn't explicitly state that.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-2017#SPNs

You would need to perform query tuning to decide if there are structural problems with how your query is written or if the query is optimal and the workload of...

It's hard to know what else you can do without seeing some code and data. I would agree a cursor is not needed. You ought to be able to update...

This might help: https://dba.stackexchange.com/questions/171204/sql-server-informix-db-linked-server

There are a few things with that. First, we focus on SQL Server, so we want to host on SQL Server.
Second, there are things we do that can be...

We've published things a few times, but not anything in awhile. Our system is fairly simple, but it's probably worth documenting. We do have the stats live at

There are lots of people on 2005/2008. In fact, one of the surveys I saw a few months back noted that 2008 is one of the most installed versions. Lots...

Should but don't.

I don't. I've never used that system, but most technologies have quick text exports.

I would suggest exporting from Cache to text and then importing with bcp/BULK INSERT. Those items would probably work better for you.

Check the Windows error logs. Looks like something with SQL Server won't start.

Also, in the SQL Server install folders, there's a /log folder. Look for the errorlog that...