Thanks for the pointers Jules.

Cheers

Ritch

Roy,

This article may help you http://www.sqlservercentral.com/columnists/bknight/unmarksuspect.asp

Ritch

Hi,

After a caffiene injection, found the answer (couldn't see the wood for the trees).

Set DATEFORMAT dmy

Thanks

Ritch

Hi,

I think it's Snitz. 

Cheers

Ritch

Does the PASS Summit ever come to Europe?

The way I handled the db part in the installshield was: Script it to install MSDE, plus any service packs/mdac. Then have the script point to...

Hi Charlotte,

I've worked on something similar. 

Doesn't cost anything.

Yes you can develop your db and SP's etc via SQL server.

You can administer it by using your sql server and registering the msde...

May the force be with you Tom!  Remember dealing with vendors leads to anger, anger leads to hatred, hatred leads to suffering.

Yep, I tried it with restarting and not restarting.    

Wish they would have targeted Bramall Lane

Thanks, the problem was with my old employer.  So guess I'll never know

Hi Steve, sp_resetstatus hasn't always worked for me. Had several occassions where I ran sp_resetstatus on a suspect db, which it said was successful. Then tried...

Hi,

If you haven't a recent backup then you can do the following. Look in your logs first, to see if is autorecovering. If nothing is in the logs, run...

Hi Frank,

Yeah I'm ok thanks.  Been out of work for awhile Started my new job this week ...

Congratulations to you all. No doubt all the hard work will be worth it.

The time and effort you all (and the rest of the Yodas) put in on this...