보미네

큐브 브라우저에서 drop row fields 가 없어짐....

개발팀 왈...

Hi, thanks for your feedback on the cube browser in SQL Server 2012. We are aware that hierarchies that you defined in the model no longer show up in the cube browser. This is a limitation of the new control we are using.

Other customers have also asked for a better experience in the cube browser. We will consider enhancements in this area in a future release. I am resolving this issue as a duplicate of the customer bug (feedback ID 680476), feel free to vote it up and add your comments.

Should you need this reply translated to Russian, send a line to nmed@microsoft.com and tell him I sent you.

Regards, Cathy Dumas Program Manager, Analysis Services

어디 갔나....했네....

net stop mssqlserver /Y

net start mssqlserver /m /f /T3608

start /w sqlcmd -S. -A -i "C:\auth.sql"

net stop mssqlserver /Y

net start mssqlserver

ssms

declare   @dropTartgetLogin nvarchar(1000) = N''

        , @sql nvarchar(4000) = N''

select @dropTartgetLogin = name from syslogins where loginname like '%\Administrator'

select @dropTartgetLogin

set @sql = N'drop login ['+ @dropTartgetLogin+']'

exec (@sql)

go

create login [mssqlsvr06\Administrator] from windows with default_database=[master]

go

exec master.dbo.sp_addsrvrolemember @loginame = N'mssqlsvr06\Administrator', @rolename = N'sysadmin'

go

alter login [mssqlsvr06\Administrator] enable

go

declare @old_srvname nvarchar(1000)

select @old_srvname = srvname from master.dbo.sysservers where srvid = 0

exec sp_dropserver @old_srvname

go

exec sp_addserver [mssqlsvr06], local

go