If you take a transaction log backup, the log is truncated.

So you need to check if there is a lot of space available right before and...

Did you ever take transaction log backups?

I would create some help table that translates years to the C,N,O,P values.

I would join the C table against this table to get those values for each C.Year value.

Then I...

Are these all for the same job? (why is Required Skills listed 3 times?)

The first and second one explicit mention Microsoft SQL Server, but the third one asks for Oracle...

If...

Basically this will take only rows from table T where T.CT_YEAR is L,C,O or N, depending on the value of C.Year.

In other words, if for example C.Year is the current...

Eirikur Eiriksson (4/25/2014)

---

For SSIS 2008, the simplest way I have found to manipulate the logging is to use a Scrip Task in a "Master" package.

As the logging is initialized...

Sorry, I don't have any examples myself.

You cannot update the password through SSMS. SSRS is usually not managed through SSMS (I think you can only change the security roles in...

RS.exe uses VBScript files. In those script files,...

You should be able to script it out using the RS.exe utility or by using some .NET and the SSRS webservice.

Easy one, thanks!

(at the time of writing, 100% had the correct answer (20 attempts). Never seen that before)

Is resource governor enabled?

It could also be a bug, do you have all the service packs applied?

Your package is too big. Typically you'd split it up in smaller packages so that it becomes more maneagable.

If you have any add-ons, such as BIDSHelper, disable them first and...

I'm not sure it is possible. Either you log, or you don't.

Out of curiosity, what was the issue?

You got at least one response 🙂