August 26, 2008 at 1:19 am
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?
Thanks!
August 26, 2008 at 1:38 am
I've seen it a couple times, but I have no idea what causes it. It doesn't happen every time a database is detached.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply