I have tried Yes, Save my current Settings and No just reset settings, overiding my current settings.

Jared,

You are right. I should not have to reinsall for something like this.

This is what is happening:

When I close an SSIS Solution I get the following error:

The Automatic saved settings...

I tried the free version of SQL Pretty Printer for SSMS but it did not format very well.

I tried a few other free formatting tools as listed at the following...

Is the driver issue the only justification that you have for upgrading to the Enterprise Edition?

Good point @Wildcat.

The company that hosts our AS400 (huge company) recommends the iSeries Client Access Drivers.

They have a lot of clients and they use these drivers in their proprietary DTS and SSIS...

Thanks for the link @gsc_dba!

Charmer (6/25/2012)

Perhaps I'm missing something but the...

The following script includes the schema Name.

What are some of the pros and cons of using the DMV's as opposed to the Database Tuning Advisor?

SELECT

DB_NAME(dm_mid.database_id) AS DatabaseName,

dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,

dm_migs.last_user_seek AS Last_User_Seek,

Schema_Name(tbl.schema_id)...

Thanks!

I could exclude the sys.schemas table and use the Schama_Name Function on Schema_Id.

What...

It is already getting the Schema Name.

I'm unsure about the JOINs.

Thanks.

For a SQL Server 2008 R2 64 bit System I use IBM System Access for Windows V6R1 SI42423 (64-bit) on Windows 2008 R1 64-bit with SQL Server.

As was previously...

How do you navigate to your private messages?:unsure:

I'm sorry I misread it.

It is MB not GB.:blush:

I have been working a lot of hours and I'm tired and it's only Tuesday.

Thanks for the information!

What can I do with those Databases?