Felix Ker's blog

I’ve been using SQL Server 2008 for a month or two, and until recently, I got really irritated as I was unable to re-design some tables I found wasn’t performing the way I want it to. (I’m still trying to learn database designing to improve efficiency!) The solution is below.

Saving changes is not permitted. The changed you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.

Solution:
Tools -> Options -> Untick “Prevent saving changes that require table re-creation” and you will be able to save changes!

I learnt one thing about myself. I’m often time too lazy to read the whole paragraph of the error message. The part I highlighted in bold actually taught me how to fix the problem, but I ignored it. I only found out when I was typing the whole error message out. I must change this aspect of myself, else I’m going to waste time googling for solutions.

[via]

Lately I was googling for the shortest and simplest way of generating some random passwords. So here we go. I’ll share with you what I found and how I applied them.

VB.Net

Public Function GenerateRandomPassword(ByVal length as Integer) as String
Dim strGuid as String = System.Guid.NewGuid().ToString()
strGuid= strGuid.Replace(“-”, String.Empty)
Return strGuid.Substring(0, length)
End Function

Read the rest of this entry »