Hi Ric,

There are various ways you could do this.  I'll provide one such way that will at least help you get started.

First of all you'll need to set up a...

Some of the best managers I've ever had were completely non-technical.  And some of the worst ones I've had were very technical.  Typically, with technical managers, I have found they...

Thanks for that.  In my case, I'm not too worried about UK vat numbers but it's useful to know.

David,

That's right.  The code only looks at the format.  To be honest, the customs and excise guide book only provided this - it didn't provide any details on what numerical...

Richard,

Have a look at Profiler.  That will allow you to run a trace and hopefully track when and how this procedure is being executed.

You'll want to set up a filter for...

Incidentally,

is there any reason why you don't want to do this at the application tier?  I'd imagine you're wanting to do this for an application.  If so, it might make...

David,

Here's a T-SQL function that checks european VAT numbers (excluding UK) are formatted correctly.  I'd double check the logic as I quickly knocked this up from vb.net code.  UK Customs...

Amongst the other problems that have been mentioned, for me, the biggest problem with VSS integration was something the author alluded to in the conclusion:

"...whenever a script has been updated, the...

Reasons to buy:

1) You want to take advantage of the additional functionality available to mirroring.

2) You want to make use of more than 4 processors.

3) You want...

If you notice, in the FROM and JOIN part of the statement, immediately after referencing the table names I placed an "n" and an "o" respectively.  These are optional...

Depends on how well you get on with the developer.  If you get along fine then just tell it like it is.

If you don't get along, or you get no...

Hi Dave,

it's easier to explain with a diagram but basically, rows with a status of 2 are active and cannot be shrunk.  Rows with a status of 0 can be...

Hi Graham,

if @@VERSION returns Microsoft SQL Server 2000 - 8.00.760 then you're connected to the SQL Server 2000 instance on that box.

With both SQL 2000 and 2005 installed on the...

Hi Bill,

The design of the table you described doesn't sound right.  Strictly speaking, each row in a table should uniquely identify the entity it is trying to model.  In other...

Hi Dave,

you can use dbcc loginfo to get some details relating to the logfile structure.  A Status of 2 indicates the active part of the log. 

The reason why the log...