I use 2003

Just for the record, I have discovered about MS Access Projects as opposed to database and I really like what I see!

I think I'll give MS Access a shot because my initial requirements are extremely simple.

It's an initial job with a new customer and I might change the front-end later to...

Good question

I develop using sql 2008 but I work on various projects, most are 2005 while some are 2008.

Because I like intellisense, I try to work with 2008 databases regardless.

Once...

Interesting...

It started dumping when I restored one database... and it seemed to stop when I dropped it again.

There is nothing I can't regenerate in that database so I'll see how...

Good news!

I removed all of sql 2008, reinstalled my Developer version, upgraded with sp1 and it's doing it again!

Am I not lucky!?

Attached is my nice latest dump.

I can't see anything...

Sorry, I already zapped everything, I only kept db backups :blush:

Alzdba

Thanks for the interesting link but mine is a named instance and I can't figure out the command to start it as it keeps complaining about bits and bobs.

I suppose...

This is my workstation and I am not aware of any application accessing the database.

I have stopped Sql Server Agent and Sql Server, then only restarted SQL Server.

Dumps are still...

I forgot to mention that I think impracticle to create a database role per user... as we have a few thousand users

In our context I can't really do this because we may have several instances of the software on one box, hence file paths are dangerous.

I tried to pass it as...

I fear you might be right... :crying:

I was mostly intrigued by the fact that the trace had 450,000 entries for just one run, not really about the actual run/performance

I can't change much if any in that...

Unfortunately, the proc is a little bit too complicated... but I have extracted the worst dynamic sql it generates

INSERT [MSCS_CatalogScratch].dbo.[CtlInv___CategorySearch___SortedResults__for_spid__58](#TmpCatalogoid#,rank,#TmpCatalogName#, FreeTextSearch_Rank,InventoryCondition,#Inv_SkuOid#)

Select A.#TmpCatalogoid#, B.rank, A.#TmpCatalogName#,NULL AS FreeTextSearch_Rank, P.InventoryCondition, P.SkuOid

FROM (

SELECT...

That was pretty much our case... No budget, sql 32 bits and os 64...

But now, we'll definitely go for sql 2008 64.

A little bit of testing... and here we go!