In the diagram, right click, page breaks. That will take care of my format on the page issue.  Any one know how to print to a file?

If I have to,...

FYI:  By right clicking on the SSIS package, there is a wizard (nice).  You can select the whole mdb database then select the tables you want to import.  It has...

I am using SSIS.  When I look at the objects for control flow and data flow, I don't see a way to get the whole access database.  The Database Task...

What is BIDS?

I will look at the upsize wizard.  Did not know about that.

Joseph

Thanks, I will try that.  My dbreindex cause problems with the sql server instance and I had to cancel it.  I tried running it over night (no end users), and...

Thanks.

The logs are backed up 4 times a day.  They stay relatively small.  On a 16gig db, they are only a couple hundred meg to 500meg total (not part of...

Rebuild still running after 40 minutes.

Is there a %fill theory out there?  High percent fill with low % changes in a table and lower % fill with greater amount of...

Does SQL Server reuse the space in delete rows in the table? in indexes?

I will check free space before and after the rebuild.

Got it, THANKS!

Common and big misunderstanding.  NO SOX auditors will make you do that.  IF THEY DO, make the give you names of others that have implemented it.  They won't and can't...

My company needed a solution to watch activity and logging on SQL Server Databases and Oracle databases.  Many of the items needed in Oracle were already there with a job...

Yes, it is a file I created.  Basically, going from server to server the scripts stay the same except for this file.  It contains many variables.  I use it for...

Sox docuemnt is actually a group of practices that specific to different kinds of companies and the departments in the company.

As far as auditors, they get to make up...

We are looking at Lumigent.  We are a utility company and have to comply with SOX.  The problem we have is that we use Tivoli by IBM and a tape...

I would have to agree.  Stop shinking the tempdb.  You only increase the overhead on the machine by shrinking it.  Each time you do it, it consumes more disk IOs...