FWIW

I prefer to use pkTableNameID for (you guessed it) the primary key for that table. Tables being pluralised, so tblCategories would have pkCategoryID.

Then fkTableNameID clearly describes the fact that it...

Hi Jeff,

Thanks for the reply. I'm going to implement this approach in a new project I've been assigned to. Its an internal thing and so I don't have to worry...

Hi Steven,

Thanks for the reply.

I've created a backup statement, outside of the MP, but the problem I have with that solution is that it doesn't delete the old backup...

Thanks for the ideas.

Still no joy even with the Oracle tools installed on my PC (also have SQL server 2k installed). I don't want to install more than is...

Can you change the default language to British English, in Server Properties?

Many example scripts use PUBS or NORTHWIND and for that reason I would keep a copy of them on a server somewhere. Remi is right there is no need for...

Remi, just a quick question about your 3rd point... I've always thought it a good idea to prefix things like tables (tblMyTable) to make it clear, maybe 3 years down...

Chris

Many thanks - that's sorted it out. And like all great solutions blindingly simple when you stop and think about it!

Hi,

Have tried LIKE

However its throwing back an error "converting the varchar value 'NG19 8DK' to a column of data type int"

The column is varchar so why is it trying...

We're a bit behind the times where I'm working - we have 2 SQL boxes both running SP3. The IT manager doesn't see the point in installing SP3a or SP4...

Ahh - that's excellent!

Many thanks for your help

Thanks James

That's doing the job!

Nice

I'll give that a whirl

Yeah - I had worked out a LEFT TRIM after 3 characters version - but then that was matching 'SE1' and 'SE18'

Superb. I'll hunt that one down