hi Brian,

it turns out that I do indeed have crystal 8.0 installed.

I went to the folowing URL:

http://support.businessobjects.com/library/kbase/articles/c2007581.asp

however, I am not currently using crystal reports.

I get the error when...

hi Brian, this is the exact error mesage:

<error>

"library not registered"

<\error>

It happens when I try to add a new diagram to sql2k.

eg, "Create database diagram wizard" dialog

I select a table,

I...

hiya,

ta for the advice.

I tried installing a named instance, but northwind.mdf did not turn up.

then, I downloaded and ran the script.

However, when i tried to atach, I got the...

hi, that was the entire message.

The entire machine will be re-formatted soon.Hopefully the new install will clear it up.though i will look into the client tools install if this probelm...

It was an alias.Thanks Nicholas.That worked.

here's the code for anyone who's interested in the solution:

<code>

SELECT

s.[storeId],

s.[storeName]

FROM

 [dbo].[tblStore  ] s

<\code>

cheers,

yogi

I didn't know that.

more grief, ah well...I can't say you didn't warn me

yogi

sweet, thanks Gary.

Gary<<it is a good idea not to use the system tables>>

yogi<< why is that?Is it incase sql server changes the way that...

Cheers Wayne.

I hadn't thought about views and constraints etc.I'll have a look and see if I can work that into the query

ta,

yogiberr

Hi,

I looked into the parent_obj.

<sql>

SELECT *

FROM sysobjects

WHERE xtype = 'U'

<\sql>

All the "parent_obj" = 0

I'm not really sure how the "parent_obj" will be able to help me.

Should I somehow be able...

Hi David.

No, that is fine.I can use a single sproc and pass a param.

cheers,

         yogi

hi Grasshopper,

i've been stung a few times thru writing my posts directly on the site, then somehow losing them.I generally now do them on notepad and copy.

Anyway, i appreciate...

ok,

i got caught up in the moment

brilliant,

I added on a wee extra to the clause, so my presentation layer wouldn't have kittens.

<code>

ORDER BY MIN(p.productId), MIN(a.AttribId)

<\code>

thanks bud,

yogiberr

Hi Jonathan.

I used the "ON UPDATE CASCADE" option, and it worked, cheers.

The reason i wanted to change the attributeId is because I wanted my query to return the results in...

Hi Jonathan,

Thanks for going into so much detail.I've done a bit of digging and will probably be back at some point with progress + questions.

cheers