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 - 2004-09-01 : 21:20:53
|
| Hi All,When i execute stored procedure sp_columns_ex if am getting errotServer 'xyz' is not configured for DATA ACCESS.What i have to solve this problem.Thanksmk_garg |
|
|
Daveyboy69
Starting Member
11 Posts |
Posted - 2004-09-03 : 07:51:48
|
| Hey there,Have you checked that you have security access on the linked server? |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-03 : 16:13:52
|
| Server 'xyz' is not a linked server.Probably the local server right ?will sp_mshelpcolumns or just sp_columns work for you ?rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
|
|
|
sp_columns_ex error