New box would be my first recommendation and second recommendation would be new installation on that box only because I don't like upgrade and just in case you can go...

I don't know much about MSDE so this may not be it but I am just going ask

Does your MSDE Service start as...

It might be waiting for some other service to be started if there is any dependency.

Can you change SQLAgent Service to be manaul and reboot the box and then...

Hi Luke,

DTS package is Data Transformation Service and is built in function of SQL7.0 or up so if you install SQL server 7.0 or up, you already have. Many people...

Hi Alamir,

Answer to your question

1. yes, there are planty of HDD space

2. nop, less then 100MB

3. yes, this is caused by SP3a and I will check and try SP1 on...

Please anyone correct me if I am wrong. I took a look at the process exist code for fc.exe and it is "1" for success and it is "2" if file...

There are few things to remember, since DBCC REINDEX is not online oeration,

there is possible of timing out from Log reader if you are running that on publisher and

timing...

Greg and dlink are the right place to start. Always the best way to troubleshoot the DTS pakcage is to log in as SQL ServerAgent account on the server and...

Make sure to script the jobs and also DTS packages. If you search this site, there is how to move system databases with scripts since you can't backup and restore...

Yes, you won't loose any committed data by doing that. If step 2 doesn't work well, you can change the db option to be simple and change back to full...

Truncate table is really good because it is non logged and fast and won't expend log size, however, unfortunatly Transacational Replication doesn't allow to run "Truncate table .." as SQL...

Yes, BCP is unicode compliant and works great and I agree with David about Access to act as the front end is not so good idea if you have intensive...

One suggestion might be to create another database with right filegroups and copy the data w/o index and put the index and rename the database. 50G database took me about <...

I don't exactly know what you are going to do but if you want to get the feed from ft.com by using ftp with csv file or something and upload...

Do you have computed columns in your table? You have to manually turn on the Quoted Identifier on if you do.

SET QUOTED_IDENTIFIER ON

DBCC DBREINDEX('

')

What exactly were you doing in the...