gr8, thank you it worked

Thank you that served the purpose. I'll provide the Insert scripts in future, thanks for it.

?? Anyone...

Our SSIS packages are designed in a such way that it loads data using TRUNCATE/INSERT..ie. FULL load. Therafter, what actually is happening that everytime cube is refrehed with full volume...

I need to process only 6 million rather than 86 million...records which is a pain in Full refresh (takes hours to complete)...

If incremental is done, i belive it will take...

If anyone could reply to my query, that would be highly appreciated.

Hi Mike,

I can't change the 'sa' password using sp_password as I have forgotten the previous old password.

Regards,

Vivek

yes amit, i think so i am looking 4 this

Dear All,

If Sush didn't liked She is welcome enough to say me anything, request you all, not to take advantage of the situation, and generate sympathy for her by...

Dear All,

If Sush didn't liked She is welcome enough to say me anything, request you all, not to take advantage of the situation, and generate sympathy for her by...

Dear All,

If Sush didn't liked She is welcome enough to say me anything, request you all, not to take advantage of the situation, and generate sympathy for her by...

I m no doubt polite, but I may be rude bcoz of following quotation

ASCII stupid question, get a stupid ANSI !!!

I believe I have not asked any stupid question.

Anyway, Sushila...

Sushila,

No thanks for your response, Anyone, who knows about

Stored Function Tables or Table Functions, kindly reply. Your replies would be much appreciated.

Regards,

Vivek

Also, Try this

SELECT c2.name FROM sysobjects c1 join syscolumns c2 on c1.id = c2.id where c1.name like 'your table name'

Try,

sp_help tablename