August 2013 Entries


This happens when you're in the SSMS gui making changes to the table that either affect the behavior of an index, cause existing data to be truncated/nulled, etc. This can also happen you try to change the order of columns, or change datatypes. 

If your credentials allow it, you can get past this message in order to truly shoot yourself in the foot! :)

  • Navigate to Tools --> Options
  • Expand Desingers
  • Click on  Table and Database Designers
  • Check the box Prevent Saving changes that require table to be re-created.



The microsoft integration service is secure by default. The DBA has to grant access to the service in order for it to connect successfully through ssms.

To grant access to the Integration Services service

  1. Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry.

  2. In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node.

  3. Right-click Microsoft SQL Server Integration Services 11.0, and then click Properties.

  4. On the Security tab, click Edit in the Launch and Activation Permissions area.

  5. Add users and assign appropriate permissions, and then click Ok.

  6. Repeat steps 4 - 5 for Access Permissions.

  7. Restart SQL Server Management Studio.

  8. Restart the Integration Services Service. 

The download for this workbench is large--somewhere around 1.2 gb. Finding the install exe for linux or windows isn't clear. Basically this download appears to be from a 2 disk distributable set of *.ISO files. Ignore all the distraction scripts in the core directory. Delve into \ibm_ds410_lin64  (I downloaded the 64 bit version) . Look for a directory called Disk1. There you will find the installer images for Windows and Linux.

Here's a visual image of what the directory will look like.