Our sql server 2005 with sp1 has a strange behaviour. We had executed the following sql query:
EXEC sp_attach_db ‘OurDB’,’d:\Databases\Test.mdf’,’d:\Databases\Test_log.ldf’
EXEC sp_detach_db ‘OurDB’
in the Microsoft SQL Server Management Studio. After this the access rights of the Test.mdf and Test_log.ldf files were changed.
Before the execution the user group “administrators” had full access rights to these files but after the execution the user group “administrators” disappeared from the access control list.
Has anybody else experienced such a behaviour or maybe is this a known bug of the sql server 2005?