Category Archives: SQL

Configuring Email in SQL Server Express

Its a known issue that SQL Server express edition wont support Email . TO overcome this we can use CLR based email stored procedure.   Step 1 : Compile the VB code and convert as a dll. Code : Imports System.Net.Mail Public Class StoredProcedure <Microsoft.SqlServer.Server.SqlProcedure()> _ Public Shared Sub spSendMail(ByVal recipients As String, ByVal subject… Read More »

Running Image Service from PHP

Scenario : Imagine that you want to run an image service and your clients will use these images in their static site developments. The moment you change these in the server it automatically reflect in the client designs. This is a POC design and can be used in KIOSKS, Web designs etc. Basically wherever you… Read More »

Solution for SQL Server 2012: “Saving changes is not permitted…”

Error : “Saving changes is not permitted. The changes 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.”     Go to Tools — > Options– Designers… Read More »

Category: SQL