I can't find the base install for the IBM iAccess for Windows version (V7R1 - SI44594).

I can only find the SP for V7R1.

I saw a blog on the Web that updating to IBM iAccess for Windows version (V7R1 - SI44594) or later.

That's right, forgot about that sp, thanks.

You could also disable and then enable the FK's but if you get a record(s) that violates the FK constraint exception that violates the FK Constraint then you will not...

Thanks.

When I execute the following statment from master:

EXEC sp_addrolemember N'dbcreator', N'jallen'

I get the following error:

Msg 15014, Level 16, State 1, Procedure sp_addrolemember, Line 36

The role 'dbcreator' does not...

Difficult in that you get FK Violations?

I so have you considered changing the order in which you load the tables?

Why would you not want to do so?

SQLRNNR (2/22/2012)

---

Welsh Corgi (2/22/2012)

---

Does anyone have both SSRS 2005 & 2008 in their Corporate Environment?

If so how do you mange it?

I want to move to 2008R2 but not everyone is...

I was thinking, just because the back end databases are moved to SQL Server 2008 R2 does not prevent me from creating SSIS & SSRS Packages using BIDS 2005.

Do you...

SQLRNNR (2/22/2012)

---

Welsh Corgi (2/22/2012)

---

Does anyone have both SSRS 2005 & 2008 in their Corporate Environment?

If so how do you mange it?

I want to move to 2008R2 but not everyone is...

-2

I previously stated that the problem was with the browser.

I had to start...

Thanks for you feedback.

I have already resolved the issue.

PortQry is cool but I ran the statement and it only returned to default instance not the named instance that I had...

SQLKnowItAll (2/16/2012)

---

So I just took your case statement and put it at the end. Can you run it and tell me if it works? You never gave us your...

I goggled it before reading you post and it was the browser.

Thank for the good suggestions.:-)