Ahh SQL Server...you vex me. Starting with SQL Server 2005, Microsoft has finally started using the proper terminology here (schema is the proper term, SQL Server called it "database owner" previously).
Most databases allow you to set a default schema in the connection URL, but I'm not sure if SQL Server does or not. This is new territory for SQL Server. However, I know that you could create a database user and specify a default schema that way. Jeff Butler On 3/30/07, Ilya Boyandin <[EMAIL PROTECTED]> wrote:
Really? And how can I set it in the URL? I think, it's not the schema, but something different. It's "database owner", something specific to MS SQL, I think. Ilya Jeff Butler wrote: > If you are only needing to set the schema, then you could set a > default schema on the JDBC connection URL and then avoid the use of > schemas completely within your SQL. > > Jeff Butler > >
