Hi LinksUp,

the batch/bunch approach for deletions rows it is very interesting. I want to avoid to manage a cursor for a such operation.

In my scenario, I need to populate a...

As survey I want to intend the process to understand the possible issues that cause the variability about

the execution time of the SQL Server Agent job.

I need to define a...

Control-M by BMC Software, isn't it?

Thanks

Hi Greg, thanks for your answer.

Have you a link and/or major details to provide me?

Moreover, do you know if the does solution allow to orchestrate the SQL Server agent job...

Hi, thanks.

I've installed the ODAC components.

Then, what should I do, step by step, please? Thanks

Is it enough to modify the tnsnames.ora file in the ORACLE_HOMEetwork\admin directory folder?

At least, is it right the point where acting?

Thanks

Perhaps it could be enough to install the Oracle Data Access Components (ODAC) for Windows and not an Oracle client, isn't it?

However, it should be useful to know any Microsoft...

Hi Koen, thanks for your reply.

SSIS 2012 runs on a db server with SQL Server 2012 64-bit and Windows Server 2012 64-bit: however do I need to install also the...

Hi.

I have traced the database of the DWH underlying the cube and any deadlock event (lock:deadlock, lock:deadlock chain) has been captured! In the job history I can see this error...

I think that create a CLR procedure isn't the easiest solution and requires VSTO programming. I would like using T-SQL language.

Thanks

Really, I want to create a SSRS subscription by using classes or methods of Reporting Services. In the Report Manager I can manually a new subscription but in the authomatic...

Thanks. I have specified the report server service account from services and not using the rs configuration tool. The subscription functions with success.

Many thanks

Ok, but the execution account for reporting server services is my one.

Hi, thanks.

It is occured to have data with an error (f.e. conversion error, arithmetic overflow, ...). The goal isn't to insert the right data but to find which row data...

Hi. Thanks for your replies.

I know try and catch statement, but I need to capture which is the row data into a block data of the select that could generate...