It is 2005 this is the 2005 forum., sorry i skimmed the 2000 part in your post.

I will have a look at writing this for 2000

This is the code i use to get the current running sql queries

SELECT st.text, r.session_id, r.status, r.command, r.cpu_time, r.total_elapsed_time

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st

You can create a script of your databse by using Object Explorer-Right click on DB --> tasks --> Generate Scripts

Rajesh kasturi (9/29/2008)

---

Hi steveb,

Thanks for your quick reply, Is there any thing else apart...

You should start by making sure that there are no redundant columns and that the database is normalised to at least 3NF

Are you able to post the procedure that you use to perform the full-text search?

What is the problem you are having with it?

Since you are using SQL 2005 then you can create a simple SSIS package to copy a table across.

Or else scipt out the table and triggers, and insert the...

Even easier use the TABLESAMPLE funciton in sql 2005

select * from MyTable tablesample(5 percent)

there are some limitations on this though check BOL, the smaller the number of...

You can restore a production backup to your dev server, this would be the easiest and quickest.

Or else there are thrid party tools out there, such as Redgate SQL...

If you are inserting, deleting and updateing via stored procedures , then you can modify these to insert data into the audit tables whenever they are called, i...

I am just trying find out exactly what the problem is,

So you are able to connect to the database?

Or are you simply not able to create FTI ?

the...

what connection string are you using?

is sql browser enabled?

Can you ping the server that SQL server is installed?

Have you enabled remote connections?

Have you enabled SQL browser on the server?

What is the error you are getting?

There are other ways to move databases as well that may be better for you;

If you can afford down-time then a dettach/restore of your...