Meh, think I am being a bit silly.

The 1.0/1.45 seems to be coming back as a very different value - rounded again to 6dp.  When I ramp it up with...

Indeed.  Imposing the security I want is going to be a big job.  I have inherited a system that is somewhat out of (firm) control.  You know the ones -...

usually I just alter database set single_user with rollback immediate.

Seems to do the job.

Well, blocking occurs when one process has a lock on a resource (eg a table, record, index etc) that another process needs.

This is normal, and almost unavoidable.  The question is...

Not sure how others do it, but I found a scheduled job running every x minutes scanning the sysprocesses table for anything which has...

Reactionary is more like it.

Locks are a vital and integral part of the system - if you set up to be emailed every time you get a lock - prepare...

Thats pretty much it, yup.

The menus on the install don't seem to offer the collation, nor does the fn_collations or whateer it is proc.

But the collation exists on the database...

Yup, unattended install with a customised setup.iss worked a treat.

mmm.

At the moment I am pursuing the unattended install path... will let you know if it works!

yes, thanks.

The problem is the live server (900+ procs) is created with the default collation in this compatability nonsense.  The live db is also in this collation.

Now, if I have...

Thanks, I've already got that far -

create table testcollate2

(

a varchar(250) collate Compatibility_52_409_30003 not null ,

b varchar(250) collate SQL_Latin1_General_CP1_CI_AI not null ,

c varchar(250) collate Latin1_General_CI_AI not...

so, another top notch question then?

Which is all very well, but one would imagine it would handle it a bit cleaner.  Rather than happily renaming it to an unusable value.

Ok, insanity passed...

looks like sp_rename 'dbo.proc1', 'dbo.proc1_bak'

decided to rename dbo.proc1, dbo.dbo.proc1_bak ijn sysobjects, and render it totally unusable.

Judicious direct updating of the system catalog remedied the situation.

But, just,...

Hi, unless I am missing something fundamental here, the dateformat is set at the connection level.  Check your connections - eg webservers/odbc/query analyzer etc.