Lee,

what kind of server are you using? We have Dell and we needed more memory back in October. One of the servers had 2 GB and tried to apply one...

This is just an idea for you to think about. If you are going to transfer your data from MS Access into SQL Server, use DTS without creating the tables...

Steve,

I have reading your security articles and found them very helpful.

I have a question, though. Is there a way I can trace any hacker attempt to log in? Not using...

Thank you. I solve their problem by just linking the two serves. The function works fine then. Thank you again for your input

You need to use an ActiveX step to create the file within your DTS. I have done it, but don;t have the sample with me at this time. I will...

Thank you for the input about the MS to run hotfixes.

About port 1433 and 1434. Sorry it was a typo. I did realise what I typed after I read your...

Good to know Ira. I never got the isql message. Already run sp3 in all my servers and everuthing is working fine. Thank you for the input

Four very good point were said here.

First: Apply the fix as soon as you can

Second: MS has to be aware of the deployment tasks (Yes, I did miss one file...

During the beta testing period, we had a similar error.

Our problem was that, the new option to carry or change database ownership (new with sp3) option before you enter...

Just a quick question for Excel user. Out of curiosity, I did test the export to excel via DTS with sample data. One of the fields has a bunch of...

I agree with PLanigan. Replication could be the best option.

By using replication, you won't have to worry about the production server being used. Your reporting server as a subscriber...

Excellent idea. I was wondering if this effort will be an ongoing project. I read, and learn tons, something new in SQL Server Central quite often.

Copyrights, read proofing, etc is...

Got it Brian. I will keep my mouth shot!! LOL, I am just kidding!!

Seriously, I understand their point. I will keep on sending the bugs to them. Even though they...

Thank you both. We are part of the beta trials for Microsoft and we have been sending all the bugs we have found so far.

I just thought it could...

Otehr option is to create an audit db, in which you keep track of any changes in the main db. Not a simple process, but in the long run it...