Hi

you can not convert existing column with computed expression.You can add new column as Computed one in a existing table.

Thanks,

Naginder

Hi Steve ,

Thanks for your reply .

We are not worry about loosing highability . Later on we want to convert AS NLB. I am...

Thanks for reply .

I am installing from hardware not from CD.

Thanks

Naginder Pathania

Try Below Technique :

CREATE TABLE [dbo].[Area](

[Region] [varchar](50) NULL,

[Country] [varchar](50) NULL,

[City] [varchar](50) NULL

) ON [PRIMARY]

INSERT INTO

([Region],[Country],[City])VALUES('asia','japan','kyoto')

INSERT INTO

([Region],[Country],[City])VALUES('asia','japan','tokyo')

INSERT INTO

([Region],[Country],[City])VALUES('europe','uk','edinburgh')

INSERT INTO

([Region],[Country],[City])VALUES('europe','uk','london')

INSERT INTO

...

Once Again Thanks for Ur Reply

In our Application, this particular table is used for searches and get list data and data in tables is insert in bulk and delete...

in my Case , ProductCode and supplier are not unique , As per sarvanane views it could be fine to add ID idenity column in table...

Thanks for ur reply again

There is dupliecate data like same supplier and productcode have been repeated , there are another coplumns that are hidden , i acn not give...

Thanks for ur reply,

My Situation is that data in table is reduntant or duplicate . So We Need to maintain the Identity Column in Table to maintain uniqunes...

Hi , thanks for ur reply, i have another field month that can be used as in sort, but i need mdx code to use it . pls help me...

Efficent solutions comes with efficent resources. In VLDB environment don't think about Visual Studio , think abt ERWIN more or less abt Microsoft Visio.

clearly write ur issue and situation . So that i can tell u about exact solution or what do want to capture or process in ur job. you can handle...

Hi First You have to configure database mail in Management folder after that create a new job in agent , there you will find different options

such as step,...