You are correct, Pro*C is Oracle specific.

On the Windows/SQL Server side of the world research ESQL/C - short for "Embedded SQL for C". You can start here... http://technet.microsoft.com/en-us/library/bb463140.aspx

Time ago I found this piece of code...

---------------------------------------------------------

-- HOW TO - Get SS IP ADDRESS

-- Credit to Eli Leiba

---------------------------------------------------------

-- You will need this procedure...

create Procedure sp_get_ip_address (@ip varchar(40) out)

as

begin

Declare @ipLine...

Duplicate post

John Waclawski (6/3/2010)

---

PRINT '*************************************************************'

PRINT 'If you need to Add/Delete/Modify a database on this server,'

...

I'm not an expert but I understand you can run 32 bit client in a 64 bit O/S IF you enable 64 bit mode via Enable32bitAppOnWin64

ankitwaitshere (4/29/2010)

---

Here is the situation:

There is a transaction intensive database - used for both routine transactions and reports.

I was wondering if I could isolate these two operations and 2 independent...

This is a SSIS generated query.

Query creation may be tricky some times.

In this particular case I'm guessing that the developer...

1- Left space for a WHERE condition on the outer query,...

Good! I"ll keep my fingers crossed 😀

If possible I would go with a three tier development model: Dev, Test, Prod.

Let developers play in Dev but only DBA has the...

Let me start by saying I totally agree with you - it will be nice to transform your free-range environment into a pro environment.

Having said that, let me ask the...

msforumpost (5/31/2010)So what is happening is over a period of time, the number of records in the table has increased whether the user choses to delete or update and the...

You are right - Thank you for...

Barry G Freeman (5/27/2010)

---

As with all inherited systems, I'm finding it really difficult to find out things, and it's all too easy to blame the contractors who originally set this...

lrodriguessp (5/28/2010)

---

Can I create PK integer (nonclustered) and the partition function datetime?

Partition Function:

CREATE PARTITION FUNCTION pf_Date (datetime) AS

RANGE right FOR VALUES (2007-01-01', '2008-01-01', '2009-01-01' );

GO

Partition Scheme:

CREATE PARTITION SCHEME...

:pinch: Problem here is either lack of business specifications or faulty database design.

I cannot see how...

CLUSTERED?...