Saturday, April 29, 2006 - Posts

Easiest way to display file properties

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Easiest way to display file properties
The new RSS feed is here

The previous post requires you to display the properties of a file to be able to "Unblock" the file.

There are 2 (at least) waysI know of. The first is to right click on the file and select properties.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Easiest way to display file properties

posted Saturday, April 29, 2006 9:31 AM by SimonSabin with 2 Comments

Download files marked as unsafe (blocked)

You may have noticed that with Windows XP SP2 files downloaded from the internet are now marked as such. This marks the files as unsafe.

This results in a number of problems.

  1. Compiled help files do not work correctly (the content doesn't display)
  2. .Net projects are treated as unsafe and so imposes restrictions on what can be done.

What I have found today is that zip files whilst treated the same also cause this setting to be propogated to the files extracted from the zip file when the built in "Extract All..." function is used. Once the files are extracted I am not aware of a way of globally marking the files as safe (unblocking them).

To stop this happening make sure you unblock the zip file before extracting the files. In doing this the files will be extracted as unblocked.

To unblock a file display the file properties and click the "Unblock" button.

posted Saturday, April 29, 2006 9:18 AM by SimonSabin with 1 Comments

Slipstream install of SQL Server 2005 SP1

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Slipstream install of SQL Server 2005 SP1
The new RSS feed is here

I truly think MS have missed a step with the install of SP1. The install for RTM introduced side by side installations with the promise of simplified patching and reduce down time during upgrades/patches. However SP1 has not delivered on these promises.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Slipstream install of SQL Server 2005 SP1

posted Saturday, April 29, 2006 6:19 AM by SimonSabin with 2 Comments