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 |
|
catrina.florin
Starting Member
1 Post |
 Posted - 2009-10-08 : 07:34:02
|
| Hello,I have a db that has a few stored procedures that use openrowset statement. Everything is working fine but when I try to restore this database using script (and I need to do this!) all those statements fail with this error:Cannot process the object "set fmtonly off exec [db name].dbo.[sp name]". The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.Any clues? (I tried everything.. I compared the databases and they seem identical)P.S.: the linked server is the host server (I am using openrowset just to process the output from stored procedure) |
|
|
|
|
|
OPENROWSET on restored db