hi men!

i have the same problem as ngkh.

i see my user's settings in control panel as mhweiss wrote. my settings are OK: i am a member of the OLAP Administrators...

thanks Steve!

i know this. but! how can i do this in query analyzer? because BOL mentioned Model Developement Kit only.

cao, G

uhum.

thats good! i take your advice.

thanks a lot G

Hello John!

Yes, that's the right script.

As i discoverd my problem was not in the query. it was caused by DB's and SQL...

ID is int, COL1 is char(14) and COL2 is char(16)

my query is: select ID from TBL where COL1= @a or COL2= @a

, where @a...

the ID is the PK! ... jesuschrist! i forgot it!

so. this is that becouse i use ID to connect to another tables and for...

I SOLVED ID!

... or i think, i solved it, 'couse it works!

i changed the DB's collation to the same as SQL...

can i update the SYSCOLUMNS table?

>> I checked. unfortunately no.

so, i have any idea right now.

thanks

another question: i changed the collation of my database but the colums collation hasn't changed.

is there any solution to change all columns'...

thanks

and what do u think? i have to create an index on ID, or not?

yes! you're right! i didnt check this..

can u tell me where can i change the collation of the DB?

thx G

I CANT BELIVE IT!

your script works in pubs! so i DON'T understand what's wrong with my script. it sholud have to do the...

hi!

i use it in QA. so i can see that this NewCol is one of the #tempTable's. when i use this:

select * from #tempTable

but when i use the next, i...

thanks PW. this article is very useable, but i think, the problem is not that.

i try to create another column in a tempTable and write a select query for this...

ahha

as i wrote in my 2nd post, my query is the next:

select ID from TBL where COL1= @a or COL2=...