Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-15 : 10:12:12
|
| Latebird writes "Hi, I can run an openrowset query within a stored procedure, through sql server registered using 'sa'. But the same fails to run on the sql server registered under my own id. My id has rights to create table, sp, dts packages but not jobs. I am not part of sysadmin. Please tell me how can i get the openrowset to work on the server registered using my id.Thanks" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-15 : 12:51:34
|
| You mention openrowset, but then you also mention jobs. So is the problem that you can not run a job or that you can't run your T-SQL code in Query Analyzer?Tara |
 |
|
|
|
|
|
Openrowset