Unless you have a very good reason for this I would always insert the field at the end of row.

After you have done it, remember to do an sp_recompile on...

OK, I know that the question is hypothetical but who combines a major application upgrade with a major code change?

I'd play safe and plan...

The most important part of ANY system is the data, and to a customer the most important data is THEIR data.

When I was showing geodemographic marketing systems we would deliberately...

On this site's main menu, it is on the resources submenu.

Interesting stuff!

The State field is the next field following the 4 fields that comprise the clustered primary key if that is what you mean by being on the trailing edge.

I...

http://news.bbc.co.uk/1/hi/england/suffolk/3389957.stm

They probably did

Glad you liked it Chris,

The more I look at stats the more sceptical I am about government statistics.  Lies, damn lies and statistics and all that.

My favourite quote was that...

Now that Dubyaa has obliterated the dollar I would be daft not to subscribe! 

Fortunately we have an American subsidiary so the present US only distribution can be got around.

I...

Granted that Access can be a resource hog but I found that the query properties eased that a lot i.e. record locks, use transactions etc.

I found that if you have...

If I have a regular import job then I use DTS.

If I need to do a quick one off then I tend to do my data cleaning and preparation in...

Can you give an example?

I tend to design my tables with rules and defaults so I am not sure why you need a trigger to enforce this?

Pause a moment whilst I swear profusely

I wish I had known about fn_replinttobitstring & fn_replbitstringtoint, it would have made my life so much...

Andy,

Sorry to add to your woes but I also get the (1 item remaining) message on the shwmessage screen, although everything appears to work correctly. 

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=93623

If I click the...

No Andy, but then under Mozilla the reply form is just bog standard HTML rather than the ActiveX control you see under IE.

Under IE I can see all the toolbars...