How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role :)
--
MusonDTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role :)
> --
> Muson
>|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then selecting from it
> Is there a why to create linked server without security admin role or some other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security policy to have 10 users
> with Security administrator server role :)
> --
> Muson
>

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role
MusonDTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role
> --
> Muson
>|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which
allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-
1b184aff558f.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...een">
>I need to import excel data to mssql, i am creating linked server and then
selecting from it
> Is there a why to create linked server without security admin role or some
other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security po
licy to have 10 users
> with Security administrator server role
> --
> Muson
>

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role
Muson
DTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role
> --
> Muson
>
|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then selecting from it
> Is there a why to create linked server without security admin role or some other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security policy to have 10 users
> with Security administrator server role
> --
> Muson
>
sql

How change name of level (All)

Hi,
I’m creating dimension with SSAS 2005 – Business Intelligence Development
Studio. Dimension has attribute hierarchies and user hierarchies.
For attribute hierarchies and user hierarchies I can define my own all
member name ( property AttributeAllMemberName for attribute hierarchies and
property AllMemberName for user hierarchies). But I can’t find a place where
I could change the name of all level. It’s name is now “(All)”. But I need
to change it. How can I do it with AMO or with BI Development studio? Please
help me.
Thanks for the answer
Dorota
you can't rename it
you want to change it to which value?
"Dorota Papiernik" <DorotaPapiernik@.discussions.microsoft.com> wrote in
message news:1B0E4BDC-BD75-4483-AB51-24F7747C87FF@.microsoft.com...
> Hi,
> I’m creating dimension with SSAS 2005 – Business Intelligence Development
> Studio. Dimension has attribute hierarchies and user hierarchies.
> For attribute hierarchies and user hierarchies I can define my own all
> member name ( property AttributeAllMemberName for attribute hierarchies
> and
> property AllMemberName for user hierarchies). But I can’t find a place
> where
> I could change the name of all level. It’s name is now “(All)”. But I
> need
> to change it. How can I do it with AMO or with BI Development studio?
> Please
> help me.
> Thanks for the answer
> Dorota
>
|||Hi,
Thank you very much for the answer. I’d like to rename it to polish name,
for example instead of “(All)” I need “Calosc”.
Thanks for the help.
Dorota Papiernik
"Jeje" wrote:
[vbcol=seagreen]
> you can't rename it
> you want to change it to which value?
> "Dorota Papiernik" <DorotaPapiernik@.discussions.microsoft.com> wrote in
> message news:1B0E4BDC-BD75-4483-AB51-24F7747C87FF@.microsoft.com...
|||well...
in fact it's never used, and the end user generally never use (All) level
directly.
the end user use the all member name you defined.
I know that few applications display "(All)" in the interface.
But it's not possible to change it today.
Log your request in the connect website as an improvment.
"Dorota Papiernik" <DorotaPapiernik@.discussions.microsoft.com> wrote in
message news:7F16FE08-B741-4148-93B4-C802467735BF@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thank you very much for the answer. I’d like to rename it to polish name,
> for example instead of “(All)” I need “Calosc”.
> Thanks for the help.
> Dorota Papiernik
>
> "Jeje" wrote:
|||Hi,
In Analysis Services 2000 it was possible to change name of the level (All).
So for polish users I changed it to polish value “Calosc”. I have migrated
database of my customer to Analysis Services 2005, and I have expected that
on Analysis Services 2005 I also can change name of level (All). Now I see it
is not possible. So polish users will have to work with the name “(All)”.
Thank for help and for information once more. As you suggested, I’m going
to log my request in the connect website.
Dorota Papiernik
"Jeje" wrote:
[vbcol=seagreen]
> well...
> in fact it's never used, and the end user generally never use (All) level
> directly.
> the end user use the all member name you defined.
> I know that few applications display "(All)" in the interface.
> But it's not possible to change it today.
> Log your request in the connect website as an improvment.
>
> "Dorota Papiernik" <DorotaPapiernik@.discussions.microsoft.com> wrote in
> message news:7F16FE08-B741-4148-93B4-C802467735BF@.microsoft.com...