Msg 7411 says the server is not configured for RPC. A Jr. DBA I am training found the fix on his own: turn the RPC option from False to True.
SQLAuthority News – Book Review – Backup & Recovery (Paperback)
My review of Backup & Recovery by W. Curtis Preston, a book that shows how to make backup and restore faster and more reliable, and save money doing it.
SQL SERVER – Three T-SQL Script to Create Primary Keys on Table
Three T-SQL scripts to create primary keys: two while creating the table and one with ALTER TABLE later, where the column must first be NOT NULL.
SQL SERVER – 2005 – Driver for PHP Community Technology Preview (October 2007)
Microsoft released the SQL Server 2005 Driver for PHP CTP, a free PHP 5 extension to read and write SQL Server data. I include the install steps.
SQL SERVER – Explanation and Understanding NOT NULL Constraint
What a NOT NULL constraint does and two ways to add one: when the table is created, or after the table is created. My example covers both.
SQL SERVER – Three Rules to Use UNION
The three rules to use UNION from Ben Forta’s T-SQL book: two or more SELECT statements, the same columns in the same order, and compatible data types.
SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation
SQL Server 2005 ships with risky features off. The Surface Area Configuration tool turns them on or off, and here is what replaced it later.