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.
Continue reading “Couldn’t send mail with MS SQL Server 2005”
Can’t find php-mssql? Nah, its gone. Use php-sybase which contains both libraries now. Remember, make sure FreeTDS is installed aswell.
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.
Continue reading “FreeTDS installation directory is not a FreeTDS installation directory”
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.
Continue reading “Upgrading from SQL 2000 to 2005 Error -1”