Found this article. IT explains the problem and solution.

Thanks for your time.

Steve,

Thank you for the information. I had seen this option but never really investigated it. While I can understand part f the reason for this option, I do not...

I would like to thank everyone for their comments, both on the "hypothetical situation” editorial and for some of you, the grammar.

First my comments on the editorial;

...

I think you are out of luck. I do not remember ever being able to move the psswords over from sybase to SQL.

Example:

ALTER LOGIN sa WITH NAME = peanutbuttercup

Available with 2005

My approach to being a DBA is that I am here to protect the companies data. These to me means that no one ever uses the sa account on...

Have any of you tried the solution I mentetioned earlier in this message string?

I have had this happen a couple of time on differnent servers and creating a new backup...

We have SMS in the company but only on the Desktops and Laptops. It is a very good idea though. He is just hard to get time with but...

Thanks for the replies. I feel a little like a fish out of water these days.

Additional information:

This is a DTS package from SQL Server 2000  I can execute the package under DTS Legacy\Data transformation Services.

I know that I have a lot of cleanup work for the...

Thanks Christopher,

This is a lot for me to review. I already have SP2 installed. We do not use MOM (Yet, I am hopfull), we use Patrol.  I do have one...

Now there is an approach i had not thought of.  I like it.  I will look at it and see what it will take to get setup.

Thanks

Thank you for your reply.  Each database is different and requires a different type of maintenance. So I create backup plans and tuning checks based on each database usage.

Thanks though...

Some times. It depends on the database were are managing.

No I used SQL to handle it. HTen I back up the file from disk to tape using TSM