Why don't you write your query with the needed logic and return either (0/1) or ('T'/'F') as needed?

DB.Duck (4/13/2012)

---

Has anyone ever heard of Oracle GoldenGate being used for pure SQL Server 2008 R2 high availability? (i.e. No Oracle db's involved.) I'm only talking high availability, NOT...

manishkumar30 (4/14/2012)

---

I have the same configuration. I am using SQL Server 2008 and Oracle 11g in my same system.

my requirement is through SQL Server 2008 Link Server, I want...

Agreed.

In general DWH Staging tables are modeled after the OLTP tables from where...

ssa2010 (3/2/2012)

---

When I running a Stored Procedure in sql 2000 query analyzer, it take 35 seconds. But when I run this script directly, it takes 1 second. How can I...

Ankit.shah22 (4/11/2012)

---

Hi all,

This service broker query consumes high CPU above 80% and ave duration is 285 sec.

WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body FROM ExternalMailQueue INTO @msgs), TIMEOUT @rec_timeout

Any idea...

Alan Spillert (4/11/2012)

---

Our data warehouse group is using Informatica (latest version) to pull data from many system, including my SQL Server 2008R2. We were using only Windows authentication until...

Oracle DBLink connections behave like a normal client connection meaning that the server on the remote side of the DBLink perceives...

The proper Oracle datatype would be TIMESTAMP not DATE, also you should use TO_TIMESTAMP() not TO_DATE() for conversion.

Lynn Pettis (4/10/2012)

---

rocky_498 (2/12/2012)

---

Hi guys,

I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore...

it all depends on the features you need, database size and expected growth of both database size...

pamozer (4/9/2012)

---

We currently have 20 database instances with anywhere from 20 to 400 databases per instance. All databases have exactly the same schema. I am trying to come up...

ard5karthick (4/9/2012)

---

Hi Mohan,

Open SSMS

Right Click on the Job you want and from the POP Up select Disable option.

To check after its been disabled the Job will be having an Red...

I do not think poster wants to stop backup processes.

On the other hand, if...