NH-1509 - MsSql2000Dialect does not use default schema when creating "if exists" statement

[nhibernate-bot]

Brian Meeker created an issue — 30th September 2008, 6:59:42:

The MsSql2000Dialect does not use the default schema when creating an "if exists" statement in GetDropTableString. In the following statement the default schema for Foo is test.dbo but the query only looks in dbo.sysobjects instead of test.dbo.sysobjects.

if exists (select * from dbo.sysobjects where id = object_id(N'Foo') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table Foo

---

Brian Meeker added a comment — 30th September 2008, 10:59:10:

Patch for issue

---

Brian Meeker added a comment — 30th September 2008, 13:50:19:

Please ignore the previous patch. It does not work as expected.

---

Fabio Maulo added a comment — 1st October 2008, 7:32:35:

The problem is the use of both catalog and schema NH-1443

---

Alexander Zaytsev added a comment — 12th December 2016, 21:56:08:

Not the same as NH-1443