보미네

exec sp_configure 'show advanced options', 1
reconfigure with override

exec sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure with override

USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1
GO

/* 1 */
if object_id ('[Table Analysis Tools Sample]') is not null
drop table [Table Analysis Tools Sample]

SELECT * into [Table Analysis Tools Sample]
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [Table Analysis Tools Sample$a3:m]'
 )

select * from [Table Analysis Tools Sample] 

/* 2 */
if object_id ('Forecasting') is not null
drop table Forecasting

SELECT * into Forecasting
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [Forecasting$b5:e]'
 )

/* 3 */
if object_id ('[Fill From Example]') is not null
drop table [Fill From Example]

SELECT * into [Fill From Example]
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [Fill From Example$b3:m]'
 )

/* 4 */
if object_id ('[Source Data]') is not null
drop table [Source Data]

SELECT * into [Source Data]
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [Source Data$a3:m]'
 )

/* 5 */
if object_id ('[Training Data]') is not null
drop table [Training Data]

SELECT * into [Training Data]
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [Training Data$a3:m]'
 )

/* 6 */
if object_id ('[Testing Data]') is not null
drop table [Testing Data]

SELECT * into [Testing Data]
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [Testing Data$a3:m]'
 )

/* 7 */
if object_id ('[New Customers]') is not null
drop table [New Customers]

SELECT * into [New Customers]
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [New Customers$a3:q]'
 )

/* 8 */
if object_id ('[Associate]') is not null
drop table [Associate]

SELECT * into [Associate]
FROM OPENROWSET
 (
 'Microsoft.ACE.OLEDB.12.0',
 'Excel 12.0; HDR=YES; IMEX=1; Database=C:\DMAddins_SampleData.xlsx',
 'SELECT * FROM [Associate$a3:d]'
 )

큐브 브라우저에서 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