how would i use my username and password as a variable for the above script?

No indexes :w00t: well theres your problem right there, firstly create indexes on all your tables.

Do you know how to ?

How many drives does your server have?

check your maintenance plans have they run sucessfully? does your maintence plan include rebuilding of indexs? when you do big inserts or deletes you will need to re-organise data within...

insert into table2

(servername,

status,

date)

select

servername,

status,

getdate()

from table1

put this into a stored procedure and create an SQL job for the stored procedure thereafter schedule your job to run at the time you want...

Thanks, I will apply that logic, seems much simpler.

Hi

For inserting the data into the text file, I did a striaght select into the text file using sql query.

For removing Duplicates I used the below query but I'm...

how would sharepoint work with regards to this developing this application?

Ok you say this i should write the file path to the database and write a front end application to...

neel.singh@interactivesa.co.za

would it be possible for you to mail me the package please.