How do you tell if a user defined function is deterministic or non-deterministic? One OBJECTPROPERTY call with IsDeterministic gives you the answer.
SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server
Roy Cheung hit Error 7311 running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server, and shared the fix.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2
Joffery improved my script to find tables with foreign key constraint in a database, adding the ON UPDATE and ON DELETE rules and a little ordering.
SQL SERVER – Create Database Error in Windows Vista
A reader on Vista got a create database error, Msg 262 CREATE DATABASE permission denied in database master. The fix is the same one from my earlier post.
SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution
A reader asked how to Delete Duplicate Records in SQL Server 2000, and another reader answered with a quick SET ROWCOUNT script. Both, side by side.
SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition
Can SQL Server 2005 Dev edition run on Vista Ultimate? I installed it on my new system, added SQL Server 2005 SP2 as setup suggested, and it works fine.
SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions
Christopher Miller shares a T-SQL script that renames default constraints to match his team’s naming conventions, cleaning up names that slipped through.
SQLAuthority News – Write for SQLAuthority
Have a script, tip or concept that would help other readers? You can write for SQLAuthority. You do not need to be well known, and I credit every author.