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...

drag using right click, like we move our file in explorer from one location to other

Paul,

Downtime will be there if you want the database files to be copied properly.

my strategy, if downtime allowed,

1) take primary database offline.

2) Detach it.

3) Copy file(data and log) to new location.

4) Bring your main database online to restore...

and if you want from SQL that it write script for you on the query window as well then click on any perticular table, drag it to query window and...