Saving changes is not permitted sql server 2008 r2

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.


EqualLogic Maintenance Record, Take Two

I don’t know if I dare post this, but no drives lost or hardware issues since 1/26/10
My previous post was here


When creating a temp file System.IO.IOException: The file exists error

If you get the System.IO.IOException: The file exists error, it’s probably because your C:/Windows/Temp folder is absolutely full with temporary files. In fact, if you have more than 65535 files in your temp folder, the method GetTempFileName will throw this error.

To resolve this, just remove all temporary files in C:/Windows/Temp. It might take some time, but it will solve the problem.

Here’s the stack trace I got:

System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)


VEEAM Reason: The destination file system does not support large files.

This happens if the datastore that the virtual lab VM lives on has been formatted with too small of a block size. Either create a new datastore and then a new virtual lab on it with a bigger block size, or storage vmotion to the rescue.

Verifying Automount is turned off (for veeam)

We can verify the status of Automatic mounting of new volumes by looking at the value of the following key:


So I have recently been very enamored with the QVDesign Blog, my calendar activity ribbon

There are a ton of very nice, and cool designs here.

I was trying to figure out what I could do with a similar chart.

So I had the thought of what if I applied it to some sort of production. (We make frozen veggies) What would be really cool is if I could use the ribbon, and then if the user hovered over a block it would be able to popup the value, I messed with this for a while but never got anything satisfactory. If you wrap the cell text to 2 lines then it will do a popup. (Too bad it doesn’t popup if the data wasn’t fully displayed) So, maybe  Matt Crowther has an idea for this?? Also, I think it would be neat if there was a legend showing say six of the colors and the approximate values that they represent?

Anyways, so what I ended up going with is a ‘calendar activity ribbon’? I’m not convinced its useful, but at least its fun 🙂 It shows the last two months of production in a calendar format. Instead of going with weeks I went with the start of the week and end of the week, and then wrote formulas to suppress the days that don’t belong to that calendar. I also show the values in conjunction with the color coding.

So this is what it looks like.