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 can Unzip file text file using SSIS

Hi,

I am pulling text files in gzip format from UNIX system. I want to unzip these files and then import data from these files into database using SSIS.

Run your favorite unzip utility (there are plenty of gzip-compatible archivers out there, including gzip itself) using Execute Process task.

How can import mdf file to mssql 2005

Dear All,

I have a mdf file and want to import the file to mssql 2005, But i can't find the function when i right click the database name in SQL Server Management Studio. What should i do?

Regards,

Ricky

You can choose to attach the mdf file as a new database. Right-click on the 'Databases' option on SSMS and click attach or use T-SQL (sp_attach_db).|||

hi

Gargi is very right,

I would like to Add,

the thing is you need to attached the .mdf file as well as its log file with that mdf file.

(this is the process of attaching, there is no direct process of importing a mdf file)

Regrds,

Thanks.

Gurpreet S. Gill

|||I just want to add once you attach a 2000 database in 2005 you can't go back just make sure you have a copy.

How can import mdf file to mssql 2005

Dear All,

I have a mdf file and want to import the file to mssql 2005, But i can't find the function when i right click the database name in SQL Server Management Studio. What should i do?

Regards,

Ricky

You can choose to attach the mdf file as a new database. Right-click on the 'Databases' option on SSMS and click attach or use T-SQL (sp_attach_db).|||

hi

Gargi is very right,

I would like to Add,

the thing is you need to attached the .mdf file as well as its log file with that mdf file.

(this is the process of attaching, there is no direct process of importing a mdf file)

Regrds,

Thanks.

Gurpreet S. Gill

|||I just want to add once you attach a 2000 database in 2005 you can't go back just make sure you have a copy.