Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OPENROWSET support in 2000?

Status
Not open for further replies.
sqlsadie108

sqlsadie108

Programmer
Feb 23, 2007
47
US
Hi,

In 2005, you can enable OPENROWSET support under Surface Area Configuration.

Where does one enable OPENROWSET support in SQL Server 2000?

Thanks much!
 
Sort by date Sort by votes
In SQL 2000, you don't need to enable it.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Thanks George, I was just wondering because some users were running into errors (I would have to retrieve the exact error msg) when using openrowset.

However, when the user's permissions where change to administrator, the openrowset queries worked.

Which leads me to believe that there is a configuration issue.

Any ideas?
 
Upvote 0 Downvote
Or a permissions error. [wink]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
802
SashaBuilder3
SashaBuilder3
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
723
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
581
SaltyTheFrog
SaltyTheFrog
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
460
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Group results into one row 3
2
Replies
37
Views
2K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top