Search results for query: *

I seek help. I want to install Unix Solaris 8 for PC on IBM compatible computer. What kind of VGA Card should I choose for Unix Solaris 8. Especially the information of drive and the name of product or manufacturer. Thanks a lot

I seeked help for analysis services in SQL Server 2K. No people answer. Is this because not many people know about it?

I created a dimension table with 3 columns. Col1 is member key(FK) associated with a PK table. Col2 is parent key column with sequence number based on Col1. Col3 is the member name. Then I built up a dimension with parent-child hierarchy based on this table. when processing cube, error message...

I create a dimension table with three columns. Col1 is member key, Col2 is squence number to build hierarchy. Col3 is the member name. Build this under parent-child relationship. After processing cube, errors message told me that the member key is not unique. I want to modify member key unique...

I create a cube with dimensions in Analysis Services of SQL Server 2000. After processing the cube, error message told me that a member key ('appserver') in that dimension was not unique. The process of cube failed. Is this because 'appserver' is a reserved word in SQL Server or anything else...

I want to break a string in one column in a Table of SQL Server 2000 and make it as indivual columns in the table. Then I can use new created columns to make a dimension table with hierarchy in Analysis Service. The string is delimited by "/". The length and begining letter of the...

Terry: It works since I didn't put correct fk_name. Thank you so much for your help.

Terry: Thank yo so much. I went to SQL BOL and Alter Table to read it all. Then I went a test server to type SQL code there. Here is the T-SQL code: ALTER TABLE FACT_ORDERS DROP CONSTRAINT FK_FACT_ORDE_CUSTO_3D5E1FD2 (or I type the fk_name as customer_wk) It all didn't work. Here is the...

How can I find the example of using T-SQL to drop foreign key from the table. I can not find the answer from SQL Server book online. I know this can be done by using GUI tool. But I want to know more about using SQL code. Perhaps you think this question is stupid. If you don't want to help...

How can I use T-SQL to drop or disable foreign key constraint in SQL Server by using SQL Analyzer. I know this can be done by GUI Enterprise Manager. I want to know how to use T-SQL to do the same job. Thanks

I need to separate the 30,000 row strings from one column in this type '/1xxxx/2xxxxx/3xxxxx' to a hierarchy structure like '/1xxxx', '/2xxxxx' and '/3xxxxx'. I can not find instr or decode function in SQL server. Please help me by sending answer to fli@keylogic.com. Many thanks