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 |
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
 Posted - 2006-02-15 : 19:05:30
|
| Hi All,I have a server called abc.when i run Select top 10 * from jobcontrol..jobsI am getting data.But when i runselect top 10 * from abc.jobcontrol..jobsI am getting error:Server: Msg 7411, Level 16, State 1, Line 1Server 'abc' is not configured for DATA ACCESS.How to fix it?Thanksmk_garg |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-15 : 19:06:37
|
| Do you have a linked server named abc setup?Tara Kizeraka tduggan |
 |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2006-02-15 : 19:09:56
|
| I am on local server.mk_garg |
|
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2006-02-15 : 19:13:02
|
| got it.exec sp_serveroption 'abc', 'data access', 'true'Thanksmk_garg |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-15 : 19:17:14
|
| Why would you want to use the 4 part naming convention to access an object locally?Tara Kizeraka tduggan |
|
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2006-02-15 : 19:52:36
|
| I needed to stored setting in table for my application.Thanksmk_garg |
|
|
|
|
|
|
server not not recognised in queries