Actually figured out this one.

Packages in different locations can be imported and are then visible through the object explorer. 

I would create a subscription to the report and have it save the file to your share.  When you have a report you can setup a subscription to run at a...

You can run the sp_password stored procedure to change your SA password.

You can add a sql task and have it execute your stored procedure.

This is how I would do it...

1 job step to create temp or holding table, 1 job step to call dts package to import txt to holding table, 1 job...

I have some similar packages...

Can you try this:

importing the data from the .txt file to a holding table, check that table to be sure there are valid rows in the...

We ended up implementing a standard set of backup jobs across our enterprise.  The jobs will backup the database with a unique date in the file name, delete backups older...

Yes I was warned about the consequences of rebuilding the log, and for this instance that was acceptable.

After getting the database to come up available, I ended up creating a...

Couldn't get the solutions on line to work.  The problem ended up being the corrupt log file, but I had to get rid of the secondary index file as well. ...

Thanks for all your help.

Thank you for your help.  I tried the restore as sa and that does not work for me either.  The sp_changedbowner is also not valid for model database.

Thanks for the...

I know there is something from Idera called SQL Compliance Manager that is designed for meeting SOX requirements.  It is around 975.00 per server and will hit for a 5%(according...

Very small less than 1000 records

Very small table listing only 100 - 200 servernames

What kind of system are you running this on?  How many processors, RAM, and how much memory as allocated to SQL Server and the OS.