Hi Racosta ... thanks for you reply ...

my SQL Server 2000 still running on NT4 Server (for distributor)

and another SQL Server 2000 running on Windows 2000 Server.

for the default value, I have found the solution.

 

(SELECT comm.text FROM sysobjects c_obj, syscolumns col, syscomments comm

    WHERE c_obj.uid = user_id()

AND c_obj.xtype...

thanks a lot ... but i need modified a little bit ...

-----

(SELECT 1 FROM sysobjects c_obj, syscolumns col, sysindexes i, sysindexkeys k

WHERE c_obj.uid =...

Hi ...

I mean i have this SP ... (Got From pkarbowiak) and modified it to get the indexes field .. but cannot work properly

CREATE...

Hi Antares686, you are right...the last solution cannot work. I am using SQL2000 and ASP. Do you have any idea how to solve this problem?

Ng Hendry

sorry before ... can u translate your code to VBScript ... because i cannot get the object for SQLDMO.

 

Set objDMO = Server.CreateObject("SQLDMO.NameList")

Set NameList...

May I know what kind of application that you are referring to here? Any example?

Is it possible to use store procedure to do this? If can, how?

thanks

ng hendry