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.
About Kieran
