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...

OH, so you are using SSIS.

why not use a data flow task to copy the data over instead of a script?

Eirikur Eiriksson (10/12/2016)

---

This looks entirely wrong to me, two instances of a parameter object with the same name in the same scope, using parameters in non-parameterized code, no command is...

you could do it as a stored procedure instead of a hard coded SQL command, but if you don't like that solution how about:

public static SqlDataAdapter InsertSQL()

{

SqlDataAdapter adapter = new...

The reason it is failing is that the variable doesn't exist on the MYSQL side. When you do the execute AT command, you are telling it to run that...

I agree with you Andrew.

It also doesn't help that every time I think I partially understand most of the features they add in something new or I find a feature...

Geeze. Sorry about that. Didn't...

That is a good question. Where I work we have 23 live SQL Instances, 51 test/development instances that are not always up (due to disk space constraints mostly) and...

Jeff Moden (10/5/2016)

---

bmg002 (9/27/2016)

---

Sean Lange (9/27/2016)

---

bmg002 (9/27/2016)

---

you are already doing that.

if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.

so...

I recently took this test and pass first try.

The training I went with was uCertify.com. The price was decent and the content was exactly how I learn. They...

I could be wrong, but I think you are missing a few ;

I think the command should be:

sqlcmd -S %_var1% -d %_var2% -Q "DECLARE @status varchar(100); exec dbo.sp_RunSQLAgentJob @job_name =...