Couldn’t send mail with MS SQL Server 2005
Posted on July 1, 2010
So I've been struggling trying to send SQL Agent job notifications to operators.
Msg 515, Level 16, State 2, Procedure sp_validate_user, Line 19
Cannot INSERT the value NULL INTO COLUMN 'permission path', TABLE '@temp'; COLUMN does NOT allow nulls. INSERT fails.
The statement has been terminated.
Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107
No global profile IS configured. Specify a profile name IN the @profile_name parameter.[Snippet] Installation of MS SQL Libraries on Ubuntu
Posted on February 9, 2010
Can't find php-mssql? Nah, its gone. Use php-sybase which contains both libraries now. Remember, make sure FreeTDS is installed aswell.
FreeTDS installation directory is not a FreeTDS installation directory
Posted on December 3, 2009
I recently discovered an error whilst trying to (re)install an older PHP version on a client's server. My client required PHP recompiling with MS SQL support. This in turn requires FreeTDS. Installing FreeTDS is very simple, but PHP wasn't.
Upgrading from SQL 2000 to 2005 Error -1
Posted on November 25, 2009
Ever had your Upgrade Advisor return an error while upgrading an instance of SQL Server 2000 to SQL Server 2005?
UpgradeAdvisor returned -1 .
I have, in two different circumstances,
- While choosing an instance from the installed instances and choosing one of them to upgrade.
- While running upgrade advisor exclusively.