So you/your programmers are using Hibernate to wrap up an SP in a easier to call Java method call?  Makes sense...  I suppose this offers some benefits in ensuring that...

So is that saying that if I have 80MB of SQL Server memory allocated then it will use 10MB of RAM and if I have 800MB of SQL Server memory...

Excellent article - very informative.  I like the detailed example about the common situations with stock systems and quantities on order, on shelf, etc...  Thank you very much

Perhaps you have DNS / name lookup issues?

Can you ping your server by name / by IP?

Can you open any file shares (like \\SERVER\c$)?  If not, then does it...

Thanks for the article..  I don't normally try out the code samples so for me the article was great   Didn't know about merge...

We don't normally do such things because it is not nice SQL...  The proper design for you DB table would be

ID int

colour varchar(20)

val int

Then you can easily query the table...

If any one of the files gets damaged you are in trouble.  Backup, backup, backup!

Pls don't cross post - we get all new messages in the daily email anyway

Could you just collapse them into one step?

I'm with Jules - what is the purpose?  Perhaps we can guide you around that instead?

perhaps you didn't upgrade but merely installed a new instance?

Firstly, as someone pointed out, don't use system tables... But you can use the well documented APP_NAME() function as in

select app_name() or if app_name() = 'sfdsaf', etc

Also, if your apps...

Yeah, if you don't specify a length for varchar it defaults to 30 chars or something obscure like that...

Perhaps you could have a stored proc run by user2 that regenerates the stored proc that user1 executes - the dynamically generated stored proc could be aware of the dates...

A UDF must be written so that it has no side-effects.  This means that you cannot do things like execute stored procs unfortunately...   It makes sense though because this lets...