Hi Guys,

I managed to download an express version of Sql Server 2008 express version (64 bit) and it installed just fine.

For some reason my initial installation attempt just did not...

Great,

I was aware of that but was just uncertain if it

applied to Express.

many thanks.

Wow, that was a quick response....

Thanks, I wouldn't of thought of that, will retry again this weekend.

Many thanks for the confirmation.

Kind regards

Sanjeev

Hi,

I think this lends itself well to using SQL Servers ROW_NUMBER() function. An option within this Ranking function allows the data to be partitioned. And the derived Row_Number...

Good stuff and thanks for the prompt reply.

Just wanted to hear it from someone who'd already implemented it.

Many thanks again

Ok Thanks, thats good to know that it works well.

Did you use a ADP? I've read conflicting sources around using them.

Also, the reason of not impementing the whole thing...

Also can you recommend any decent books for Access 2010 application development, i'm reasonably well versed in SQL Server development but am looking for something to help me along with...

Hi Guys,

I'm looking to use SQL Server 2008 Express with Access 2010.

I am using SQL Server to store all the database objects and use Access 2010 as an Application front...

Hi Solomon,

Great article, clear and practical. Alot of common sense that usually never gets taken on board in the design phase.

Just like to add, another potential problem of wasting...

Hi Damon,

Thanks for that.

It now all seems quite obvious, but your right i guess its a matter of constantly enforcing and deepening my knowledge and understanding.

I have removed (enterprise ed)...

Hi All,

I am looking for some career advice.

Recently obtained MCTS 2005.

Whilst working towards my MCITP Database Admin 2005, I am looking for a junior dba role but am having little...

Hi Guys,

Gonna sound thick here but....

Is Virtualization (virtual servers) the same thing as having multiple Sql server instances?

Thanks

John,

For 70-431, I went through the MS Press training book and sat the tests that came with it (averaging 60-70%).

I then purchased the transcender and found my practice exam...

Hi All,

I sat my exam yesterday and passed!!!!!

😀

The exam content consisted of 35 questions and 12 simulation models (where i think i picked up some good marks).

The subjects covered where...

Thanks Damon,

Hopefully I will pass as I'm confident with around 3/4 of the books(70-431) subject matter and still have two solid days left to study.

I sat the old sql 2000...