Author Archives: Gaston
CLR trigger – External access
By default when you create a CLR trigger, VS 2008 will deploy it as a SAFE trigger: CREATE ASSEMBLY HelloWorld FROM @SamplesPath + ‘HelloWorld\CS\HelloWorld\bin\debug\HelloWorld.dll’ WITH PERMISSION_SET = SAFE; This is good, you always want to start with the minimal … Continue reading
CLR Trigger
Creating a CLR trigger couldn’t be easier: In VS 2008 Create a new SQL Server Project, then create a new trigger (right click project name, add, trigger. Fill in the attribute’s properties: [Microsoft.SqlServer.Server.SqlTrigger(Name = "PackageDeleteTrigger", Target = "Packages", Event = … Continue reading
Windows 7 SendTo
When you rightclick on the start button and then choose “Explorer”, in previous versions of Windows this would take you to your own user profile folder. This contains a folder called “SendTo”, where you can (for example) add a shortcut … Continue reading
Create a new WCF log file after a certain size is reached
By default when you create a log file for your WCF service, this will be one file that will always grow. This makes it hard in the end to load the file in memory to check it out. I found … Continue reading
Fresh installation of IIS doesn’t recognize .svc requests
This problem can be solved easily by running the ServiceModelReg tool. This can be found in %SystemRoot%\Microsoft.Net\Framework\v3.0\Windows Communication Foundation. ServiceModelReg –i will do the trick. More information at http://msdn.microsoft.com/en-us/library/ms732012.aspx Technorati Tags: IIS,WCF,SVC,ServiceModelReg
MS Access has a problem with date/time fields when the Milliseconds aren’t 0.
I was trying to add a record with a date/time field in an MS Access database like this: const string UpdateContactPersonSQL = "UPDATE ContactPerson set Firstname = ?" + […] ", ModificationDate = ? " + "WHERE ContactpersonID … Continue reading
MIME Type Detection in Internet Explorer
Just a quick one: here you can find the possible values for Response.ContentType, like: Response.ContentType = "application/x-zip-compressed"; http://msdn.microsoft.com/en-us/library/ms775147(VS.85).aspx Tags van Technorati: mime,asp.net,ContentType
Securing a WCF service with a username / password
When you read the MS documentation, this looks like a trivial thing to do, but of course there are always some things that just don’t work as you’d like them to work. I got it working thanks to some excellent … Continue reading
Starting a scheduled task in C#
I had to start a scheduled task. Most of the examples on MSDN use C++ for this, because there are no managed APIs to work with the task scheduler. Lucky for me the COM components for the Task Scheduler are … Continue reading
VS 2008 – View white space
I gladly use a lot of VS’s shortcuts, and one of my favorites is Ctrl+E, Ctrl+D which will format your document. Today I missed and typed something else than Ctrl+E, Ctrl+D, causing my editor to show all the tabs as … Continue reading
