After switching to SSMS I worked my way through all the options and found this tip a short time ago. But the only thing I really miss is that in...

So what is consistency and what is quality?

Consistency as I understand is the basis for formatting, naming and where the description header goes. Maybe how and for what comments are...

Consistency and readability.

I had the "pleasure" to hand over 3 years of development work and it helped that at the time of development I left enough comments in the code...

That was a very nice question for a Friday morning.

Another solution would be:

datepart(m,dob) between 1 and 8

and datepart(m,dob) <> 2

and datepart(m,dob) <> 6

Though the single condition definitely beats this solution.

While it is a nice easy way I wouldn't use it in a customer facing application setup due to the identified security risk.

All it needs is cracking the security context...

Jim, if on the other hand Microsoft wouldn't have promised the features from SP1 in RTM, would you have signed up to a subscription or would you have been happy...

Microsoft will have a hard time initially to change from the by-incident support to yearly subscription support.

Then again there were some interesting rumours about a subscription based Operating System after...

Oh come on. False????

In the spirit of the day the answer should be True !!!

Aye, your fourth statement is what works correctly, Peter.

To start with use the Upgrade Wizard within Access to move the tables across to SQL server. From recent moves I know it's quite simple and reliable.

Depending on your Access...

I suggest you look into a stored procedure that accepts a start and an end date.

Your problem is that your table name is dynamic and for this reason only I...

Well, one wrong but not entirely sure I am wrong with the way the question was asked.

According to this article log shipping was built into SQL 7 but was undocumented....

Assuming you use a Transfer Data Task you can specify a Text qualifier in the properties. Works the same way as the import of a text file into an Access...