Thanks!

I was looking for exactly this!

I changed a few references to @DBName to quotename(@DBName) as there is an issue with database names with spaces.

Otherwise, thanks very much.

SET CONCAT_NULL_YIELDS_NULL ON

DECLARE @STR AS VARCHAR(8)

SET @STR = 'abcdefghij'

SELECT @STR

SELECT LEN(@str)

SELECT LEN(@str+NULL)

SELECT ISNULL(@str+NULL,'1234567890')

--------

abcdefgh

-----------

8

-----------

NULL

---------

123456789

Okay.....

The Microsoft 70-431 self-training book says "You cannot create Database Snapshots against system databases." Was this changed in a service pack, or was the author being lazy?

Pass 4 Sure & Self Exam Engine are suspected to be brain-dumps by certguard[/url].

This is a cheeky one.

Technet (link) says the following:

The data type of a parameter determines the type and range of values that are accepted for the parameter. For example, if...