Sean,

I looked at BOL but obviously not good enough.

Thank you.

I did not enclose in quotes.

Thanks!

He had a systax error:

The Developers syntax was incorrect.:w00t:

This worked.

EXEC sys.sp_addextendedproperty

@name = N'Welsh',

@value = N'Minimum inventory quantity.',

@level0type = N'SCHEMA', @level0name = HisSchema,

@level1type = N'TABLE', @level1name...

The following error occurs when trying to create extended properties on a schema other than dbo.

Msg 15135, Level 16, State 1, Procedure sp_addextendedproperty, Line 37 Object is invalid. Extended properties...

Thanks for your reply.

I gave him the statement to create the Statement and it worked. I'm just getting hit with a bunch of request at once.

Thanks.

Msg 2760 The specified schema name "HisSchema" either does not exist or you do not have permission to use it.

Sorry the Developer has a permission issue when attempting to create objects in a SCHMEA other than the default DBO schema.:-)

RonKyle (2/27/2012)

---

The join is no more "mandatory" than by a standard OLTP design. But that doesn't mean it's not a good idea.

Why did you opt for a snowflake schema?...

RonKyle (2/27/2012)

---

The join is no more "mandatory" than by a standard OLTP design. But that doesn't mean it's not a good idea.

Why did you opt for a snowflake schema?...

Thanks Lowell, as I suspected I'm a member of the BUILTIN\Administrators Group.

I forgot to mention that you must CREATE a User in the MASTER Database.

I did the following and he is good to go:

GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN;

You have to have an account with IBM so you just can't go out and get it on the net.

Someone placed the install files on a server but the name...

Thanks for the tips!

Have a good day.

Jason,

Thanks for your responses.

The intent was to keep the SSIS Packages & Reports in 2005.

I made the mistake not knowing any better of opening an SSIS Package in 2008....