openrowset Image

openrowset

question
DepthOfFocus avatar image
DepthOfFocus published Default

SQL Server OPENROWSET without SYSADMIN role

sqlserver2012 sql2012 openrowset

0 Likes

0Answers

0 Comments

question
spaulich avatar image
spaulich published Default

OPENROWSET Excel Import yields null value

excel openrowset

0 Likes

0Answers

0 Comments

question
dlbridgeman avatar image
dlbridgeman edited Default

Conditionally change returned datatypes in stored procedure

datatypes stored procedures openrowset dynamic sql

1 Like

2Answers

0 Comments

question
Seamus avatar image
Seamus published Default

Location of user account temp dir for service accounts (Jet drivers on 64-bit)

64-bit openrowset service-account jet

This question has an accepted answer. Accepted

2 Likes

4Answers

0 Comments

question
Oleg avatar image
Oleg commented Default

Import Excel file through SSRS Dataset

linked-server ssrs-2012 openrowset dataset

1 Like

1Answer

1 Comment

question
Oleg avatar image
Oleg answered Default

data importing problem with openrowset

sql-server-2008 openrowset

0 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Msg 7303, Level 16, State 1, Line 1

sql-server-2008-r2 openrowset

1 Like

2Answers

1 Comment

question
Grant Fritchey avatar image
Grant Fritchey converted comment to answer Default

Linked Tables inefficient?

openquery openrowset linked

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
vstevka avatar image
vstevka asked Default

The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)”...

sql-server-2012 openrowset visual-studio-2012

0 Likes

0Answers

0 Comments

question
KenJ avatar image
KenJ edited Default

How to insert result of stored procedure in global temp table?

sql-server-2008-r2 stored-procedures openrowset

This question has an accepted answer. Accepted

0 Likes

1Answer

5 Comments

question
Grant Fritchey avatar image
Grant Fritchey answered Default

LOGIN HAS NO ACCESS TO EDIRECTORY

openrowset

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey edited Default

i use OPENROWSET for inserting a procedure's result in to a table but there is an err because in procedure i create a temptable and used it.

openrowset

0 Likes

3Answers

1 Comment

question
Shang avatar image
Shang asked Default

the function of 'openrowset' in SQL server

openrowset

0 Likes

0Answers

0 Comments

question
sp_lock avatar image
sp_lock answered Default

what is the problem to use OpenRowset?

function openrowset

0 Likes

1Answer

0 Comments

question
Pavel Pawlowski avatar image
Pavel Pawlowski answered Default

SSIS 32 Bit Driver Excel DriverOPENROWSET 64 Bit Excel Driver Cannot use both

ssis excel 64-bit openrowset

0 Likes

2Answers

0 Comments

19 Posts
19 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.