16 means a severity level.

1 means a state.

that's from BOL:

If the same user-defined error is raised at multiple locations, using a unique state number for each location can...

Check if that will help you.

use tempdb

go

create table #t1 (

col1 int,

col2 int

)

insert into #t1 values (1, 1)

insert into #t1 values (2, null)

if exists (select * from #t1 where col2 is...

Could you post code of your function which uppercase the first letter.

Frankie (7/14/2008)

---

Something that I don't understand.

In a production environment the failed database cannot be renamed to something else (too many connection & application stuff would be dependant on the database...

Frankie you are not right.

In most cases SQL Server will recreate the log file when you attach database without it, however sometimes it doesn't work.

I had an issue in the...