Hi all,
What do I have to do to get baan to use another database (winNT and MSSQL7.0), i.e baandb_1 instead of baandb (the databases are on the same machine). Any help is appreciated.



Regards Jan.

Hi,

You can't. You must use baandb ALWAYS.

What I suggest though is rename your db. So you can rename your baandb to baandb2, then baandb1 to baandb. Your user will follow the old baandb so make sure you move them to the new baandb.

Sample code below. You may use it at your own risk:


use master
go
sp_dboption 'baandb','single user','true'
go
sp_renamedb 'baandb','baandb2'
go
sp_dboption 'baandb2','single user','false'
go