just to add more...change it to varchar and use conversion method when you want to use it or why you putting 0 at initial if you want to make it...

just for curosity...

what about 2000? how to check the update?

if you know table name then try sp_help tablename.

then you will get all the details you want for that perticualr table....

what are the condition based on which you deciding for the data to be retained?

i think you need to upgrade your service pack

move the records you want to retain in other table using import and export and drop the table.......and restore the design and structure of new table as similar to old...

Thanks for this.

While opening the file using ent manager, its giving me error as not a valid win32 application.

Please suggest

Thanks for this. Actually my problem is I want to move one DTS from one domain to other domain so the only option is copy DTS to local system and...

like all said and further to add....in case you want query to use same time then run DBCC FreeProcCache and execute your query again.

If you want to list all the...

just searched and might be this topic help you:-

http://www.sqlservercentral.com/Forums/Topic707805-391-1.aspx

not able to remind exactly but i have seen similar post here in past(not more than a week). If you search you will get it where the problem get resolved...

just a thought...

try to run the query with maxdop hint.

do the DBCC inputbuffer(spid) and see the code.

Execute the code by enabling execution plan and see the cost of query.

most probably you will be able to trace the problem.

will send you stepwise screenshot

ok stepwise :-

1) click on any table in database.

2) Keep pressing the rightclick and move the table to query window.

3) leave the rightclick and you will be able to see...