durai nagarajan (7/27/2011)

---

i thought the SP may have several lines of code, only few may causing the issue which may be easy to find(index or other).

do you think my approach...

Are we talking about a Transactional Database or a Database setup for reporting purposes (data warehouse / OLAP)

If it's the former then follow the steps of normalisation through to at...

db2mo (7/26/2011)

---

I looked under the "About" and it says I have SAS 9.1 TS Level 1M3 XP_Pro Platform. So do I perform the proc export within SAS? As...

Surely you need more information...

If this is Base SAS then you should be able to see the license on the about window. Other flavours of SAS i am not sure, you could...

if you have the correct interface (ACCESS) license you can do this with a PROC EXPORT, otherwise use PROC EXPORT to create a CSV and then import this...

have a look at the acutal exection plan on the slow running query and this will provide you with the information you need. Post it here if you...

1. are the servers geographically isolated from each other?

do you have automatic fail over?

have you tested the fail-over and made sure any systems that connect...

yes if Anonymous authenitication is not allowed then you will need to get the SMTP server admin to setup an account that you can use. either windows authentication (for...

do you have the correct attribute relationships setup?

ABS would work for the opposite, (negative to positive)

are you using Anonymous authenitcation?

if not, check that your SQL service account can authenticate against the server

M.Kahn (7/26/2011)

---

Welsh Corgi (7/22/2011)

---

Yes, don't ask any...

Check the mail log and have a look at the error you are getting as this will give you more of an idea of why it is failing..

I have never...

pwalter83 (7/26/2011)

---

this is really ridiculous, i specifically mentioned above that the...