Pauls Blog

http://ssrsphp.codeplex.com/

From PHP.net If someone encounters the interesting problem in which PHP can connect to a MSSQL server from the command line but not when running as an Apache module: SELinux prevents Apache (and therefore all Apache modules) from making remote connections by default. This solved the problem in CentOS: # setsebool -P httpd_can_network_connect=1

Installing epel opened up a wealth of new packages I could install in Centos. After installing epel, I could install php-mssql on my Linux machine yum install epel-release After installing epel, you can install php-mssql, this will also include freetds.

The main difference is a function cannot run insert , update or delete statements, a stored procedure can. Functions can return a single value or a result set, like a stored procedure.

For years I have wanted something to do this, and finally found it. Worked perfectly for me in Outlook 2013  In the end it is so simple. Guide from http://www.pixelchef.net/content/rule-autosave-attachment-outlook and https://msdn.microsoft.com/en-us/library/ee814736.aspx Open the VBA IDE in Outlook. Alt-F11 will do this. Insert the following code to the Modules section. On the left side there is a tree, expand until you find Modules. Then, if there is not a Module item under Modules, create one by right clicking on Modules. Or right click and choose Insert -> Module. Now, paste the text below in the main VBA window. Close the VBA IDE. Create a Rule that calls the script. Tools -> Rules and Alerts -> New Rule... In the first screen of the new rule wizard, choose "Check messages when they arrive". In the second, you could specify certain criteria that the message must match. Tip: Try "with specific words in the message header" and ...

MSSQL database restoration to different database You can get a range of different problems when trying to restore an MSSQL database to a different database.  There are also a range of different solutions However, the following steps  work for me .  These steps require MS SQL Management Studio.   In MS SQL Management Studio, create the target database, make note of the location of the database file and log file.  Start t he restore process and s elect the appropriate backup file and backup date On the "Restore Database " dialog, on the "General" tab, under "Destination" select the desired target database. Select the "Files" tab.  Within the "Files" tab, you'll see that the data and log file are pointing to the old database, change both the data and log file to be the database you created in step 1 In "Options", select the "Overwrite" option (WITH REPLACE)

http://dba.stackexchange.com/questions/33541/how-to-keep-history-of-sql-server-stored-procedure-revisions