Hi people, thanks for those reponses to my query.. They sounded good and i did try them however they dont solve the problem. I will try to rephrase to make...

A lot of us may be biased here but SQL server is defineatel better than access for applications requiring a solid, sound and secure (as long as its patched) data...

My gut feeling for something like that would be thin client all the way! that would remove the issue of external clients who may dialup from phonelines as opposed to...

What about using a thin client for most of the work and utilising Fat clients for any information/calc heavy work ?

Im currently building a thin client that is used for...

The only error i got in the log was before I restarted sql and that was while i was trying to access the database

"Bypassing recovery for DBNAME because it is...

Hi people !,

With a new day comes new successes.

I have been able to successfully open the db by shutting down the sql server and starting it up again. Crazy but...

ckempste, Will have to wait until tommorrow. HAve people working on other projects related to the SQL server. They all get a little twitchy if i just switch it off...

Also

To shed more light on the subject..

There is a null version number in sysdatabases all the others are 539

and its status is 1077936145

Whereas the others are typically 4194304

Hi Frank,

yes there is an entry in the sysdatabases. Thats why i thought it was weird it would give an error like this. This isn't an...

Thanks Mark but no joy unfortunately. the error i get is as follows when running that from qa.

"Could not find database ID 34. Database may not be activated yet or...

Hi phillcart

I think it is just a default set for views in SQL server. Does anyone know if this can be disabled.

If he put SELECT * (in place of...

I agree with antares. I think it could be permissions too. because you say that it works fine in QA but not in the SP (which sounds like it is...

go sqlservercentral its your birthday

go sqlservercentral its your birthday

sqlsercentral gotta party like its ya birthday !!

congrats sqlservercentral.com !!!

Apart from us the crazy coders of the world building apps for undeserving clients. No one is at work at that time , except maybe us !

Thanks to Mark for...

Maybe should clarify this: The trigger actually doesnt work!

it is supposed to compare the two date fields and if they are more than a day apart then the does nothing...