Hi, have you re-installed SP2 to upgrade your newly installed SSIS installation?

If you have SP2 or better installed, you can right click on the database in question, select "reports", then "standard reports", then click on "disk usage".

If you look towards the...

I think that phrase means an installation of a piece of software, where all default values have been accepted e.g. components to install, file locations etc. - and no additional...

Are you sure that your server has sufficient memory?

I think if you go into the job step, and then the advanced tab, and then configure a value for output file e.g. "D:\Logs\MyFailingJob.txt", then the output from the job...

Hi there.

If you are working with SQL Server 2005 then you should really consider using the newer Database mail instead of SQL mail.

A Grandmother...Eggs question here sorry, but have you tried using the "Run as User" box at the bottom of the "Advanced" tab of the Job Step Properties?

Also, if your steps...

Have you copied the installation media to the C: drive?

Sounds like you might have a corrupt file perhaps?

Try re-installing from the original CD.

Sorry, can't follow the link.

Just out of interest, could you (temporarily) add the service account to the local administrators group and see what happens please?

Hi Erin.

db_denydatareader and db_denydatawriter will always overide any other permissions (db_datareader, db_datawriter, dbo).

Regardless of what other permissions are set, the 2 deny permissions will always win over.

I believe that an...

Option 1 is better than option 2.

However, since you mentioned that you are talking about a read-intensive system, have you considered RAID 1 for the data files?

RAID 1 has, I...

1) I don't believe so.

However, worth investigating the best value licensing options for your specific circumstances e.g. SQL server processor license vs. Server license + CALs.

2) Not sure I understand...

I believe that you need to apply the SP again, yes.

Or alternatively highlight the DB in question in Management Studio, right-click, "Reports", "Standard Reports", "Disk Usage".

All the relevant info is then displayed nicely in graphs.

I believe you must be running...