Thanks for the responses guys - but I wonder if I might be on "Mission Impossible" here! Couple of points:

First, geometry (rather than geography) is fine for the UK because...

....just love the way they are described as "desperate" databases!

I needed to add an additional column to the start of the #stage table - presumably for SQL 2012 - "RecoveryUnitID INT" in order to get this to run. 🙂

There are lots of posts suggesting you can't do this but it seems to work fine in 2012.

EG:

USE IMPORT;

-- CREATE FULLTEXT CATALOG ft AS DEFAULT;

DROP TABLE test;

CREATE TABLE test (ID...

Unfortunately not. If it can't be done using standard scalar...

And once you've got a "system" in place for registration, then you could allow each company to pre-book bays for their expected important visitors.

Thanks for you help all: it was the absence of the STOPAT parameter in my knowledge that was the key!

However, this leads on to the next question - again probably...

I'd agree - and if I was a "proper" DBA then I'd be wanting to do it properly along the lines suggested. But I'm not a DBA - we don't...

http://www.facebook.com/photo.php?fbid=2119853310806&set=a.2119850790743.118142.1079996696&type=1&theater

Is this usable?

Sorry - I meant to add that this is the plan AFTER I had changed it to use "Completion" rather then "Success" for the links between...

Just tried to upload a screenshot as an attachment but got this:

Server Error in '/Forums' Application.

--------------------------------------------------------------------------------

Runtime Error

Description: An application error occurred on the server. The current custom error settings...

My original issue is now fixed, so many thanks guys for your help. It came down to leaving the path blank (I foolishly thought that, since the wizard knew where...

Thx. Here's a bit more info on the environment.

The server the plan is running against is running SQL Server 2008 V2 (10.50.1600.1) and this is one step in a plan...

corder (9/29/2009)[hr

I have no idea how common it is but we had been running our application for about 10 years before it came up so we had to come up...

Here's the approach that I use - with a bit of code - and that has served me well in a number of UK-based organisations.

For background, UK fiscal years...