Thanks for the quick reply.

I ran the commands you suggested and got results that I was not expecting:

3 for the first one (FilestreamConfiguredLevel) and 0 for thes second (FilestreamEffectiveLevel). ...

First half of that works, but the second half fails.

the "Enable Filestream in Configuration Manager and select all options (IO, remote)" step is already done (also tried cycling the options...

Sounds to me like the password is incorrect. The database master key is not the same thing as the sa password or anything like that normally unless you changed...

Have you gone for your MTA yet? If so, how'd you do?

Geeze there is a lot I want to do but realistically:

Rogue one

get my new turntable set up properly and listen to a few records

likely some video games (play but not...

Hello richlion2,

I did not think of the case where disabling the index wasn't an option. I suppose for old SQL versions, that does make more sense then.

With respect to...

richlion2 (12/8/2016)

---

I keep having these conversations with people who don't know how the SQL server engine works that SQL is looking after itself. I recently asked one of my analyst...

Not a problem. Everybody has days like that.

Plus it is much nicer to find out you missed something simple than to find out that your query really needs to...

Possibly a dumb question but are you using the database as the schema?

That is, in the UPDATE command it should be:

UPDATE <database>.<schema>.<table>

SET dest.[project_id] = stage.[project_id]

...

If I understand your question correctly, you are wondering why you would want to specify a listener IP.

Lets say for example, your SQL instance had 2 network cards; one inside...

As a thought, could you ask your domain controller manager to check their logs if the account got locked at the time the job failed?

Is it always the "backup" job...

Is the backup happening to local disk or network attached storage?

If it is network attached storage, you could bug your network admin to see if there are any network issues...

Did a quick google of that and found this link: http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef

which had the following answer:

Error message: "Side-by-side configuration is incorrect"

The machine is missing the correct C++ runtime components for your...

Now, I am no SQL expert, but if I had to guess, I would say it is part of how SQL Server handles ACID.

If you do an update and something...

Should also be noted that this is for SQL version greater than SQL Server 2005 which according to the microsoft documentation at https://msdn.microsoft.com/en-us/library/ms174335(v=sql.90).aspx states:

expression

Is a constant, a variable, or an...