You may need to have 3rd party software to do this. If I require to do the same thing, I may ask our informatica developers to do the job. Alternatively,...

I've ever encountered the similar problem when the application cannot connect to the database server although there's no problem on the network site and it's due to:

a) the backup job...

Hi Eric,

I managed to run the reindexing succesfully at night in our development box without a need to stop the application.

Thanks a lot for all the feedback and comments given...

Hi Eric,

The infra intention is to have seperate exercise for the database reindexing and shall not be done together with our monthly server reboot. During the monthly server reboot, infra...

Hi Steve,

Thanks for your response. I'll inform our infra team accordingly.

Cheers

Hi All,

Ups.... sorry I'm still very new on this. Thanks to all of you on the feedback.

Cheers

Hi Sugesh,

Thanks for your reply and appreciate your feedback.

Thanks

Hi David,

Create stored procedure that checks whether the primary key and do the update or insert to the table. Then in the DTS designer, you import the text file into...

Hi,

I'm newbie for SQL server but I tried to help you out on this. I ever encounter the same problem when we upgrade the O/S from windows 2000 to windows 2003....

Hi Carl,

I'm still working in SQL 2000 and cannot find sp_execResultSet. Anyway I've adopted your method to execute DBCC SHRINKFILE(2) and it works.

Really appreciate your prompt response.

Thanks a lot!