WayneS (10/16/2010)

---

Lynn Pettis (10/15/2010)

---

PaulB-TheOneAndOnly (10/15/2010)

---

nick.mcdermaid (10/14/2010)

---

I'm impressed with Oracle packages as they almost seem like classes to me

-Variables which 'reflect' existing table meta data

-Custom data types

-Multiple 'methods' within the package...

PaulB-TheOneAndOnly (10/15/2010)

---

nick.mcdermaid (10/14/2010)

---

I'm impressed with Oracle packages as they almost seem like classes to me

-Variables which 'reflect' existing table meta data

-Custom data types

-Multiple 'methods' within the package all returning different...

I'm not where I can check an existing system, however, iirc Database Mail uses Service Broker. If you are running Database Mail this may be why you are seeing...

In my opinion, both Oracle and SQL Server have their place. What I have seen, however, is that the decision to use one over the other is usually dictated...

In my opinion, nothing. Both serve a purpose and can do the job.

In the short time I have had with Oracle, however,...

Week 5 is in the books. Quite a few changes. Go Bolts are no longer undefeated, dropping to 2nd in their division, and from 1st to 5th overall....

If relevent to the topic of the thread, does it matter if it is a new thread or a year old thread?

I also founf ALL_TAB_COLUMNS that provided me with the info I needed.

I will definately take a closer look and the code you provided when I have a little more time....

cast((code from above) as date)

Start with this, if you still have problems let us know.

Then why do these users have Management Studio if they don't have access to the SQL Server using it? I guess I'm missing something.

migraine

Barkingdog (10/4/2010)

---

2. I wanted to use Windows authentication but was told "No" because any user with Management Studio installed (and we have several with read\write\execute permissions) could access the databases...

Okay, some day, some one is going to really think that there is a DBCC TIMEWARP command. I wouldn't be surprised if it happens to be a permanent Jr...

Craig Farrell (10/4/2010)

---

... Are you simply learning the new technologies to support the existing staff at your current level? Then yes, that's work to me. That's something...

Couple of questions. What is the fill factor on the index(es)? How big is each index (in the case of the clustered index, each row)?