I got all those questions wrong - except the 15% one :blink:

And I've got two new questions lined up; they are scheduled for April 20th and...

N-way handshaking combinations...

USE tempdb;

GO

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

GO

DROP FUNCTION dbo.Numbers;

GO

CREATE ...

SQL Server's response to an error depends on the error, and session settings.

Overflow and divide-by-zero errors are affected by the following session settings:

SET ANSI_WARNINGS

SET ARITHABORT

SET ARITHIGNORE

Settings Behaviour

In this case, your...

RBarryYoung (4/7/2010)

Paul: random tangent...

See http://www.lifeasbob.com/2008/04/30/FullTextIndexPopulationErrors7683.aspx

I would like to suggest:

DECLARE @Database SYSNAME;

SET @Database = 'master'

IF -- See http://msdn.microsoft.com/en-us/library/ms190328.aspx

OBJECT_ID(@Database...

SELECT D.name, P.name

FROM sys.databases D

JOIN sys.server_principals P

ON P.sid = D.owner_sid

ORDER BY

...

Ask a hardware engineer, the manufacturer, or look it up :w00t:

Also, see Pricing and Licensing FAQ

See the Operating Systems sections of:

Hardware and Software Requirements for Installing SQL Server 2005

and also

Microsoft SQL Server 2005: Compare Features

Memory Limits for Windows Releases

The simple answer is that yes, it...

I am usually fastidious about schema qualification - except for trigger definitions, for some reason.

Thanks Andrew! All I need to do now...

SELECT parent_schema = QUOTENAME(PS.name),

parent_table_name = QUOTENAME(PT.name),

child_schema = QUOTENAME(RS.name),

...

You go all squeaky? :unsure:

Heh...bit of a guess - and rewarded with one point!

Odd name for it - no doubt there is a reason for the '2006' part...:unsure:

Ooo - I had never tried POWER. Have now, and you're right - though...