kkp40
3/15/2007 1:44:00 PM
Hi.
I have a problem when I try to run an application against a local SQL-
server, it works find when I run the application against a SQL-server
on a server.
The problem is this I have 2 databases and some times I have to access
(from the program) SP's that is located in "the other" DB (not the one
I'm connected against).
This is done by setting the name of the DB, owner and SP-name
(MyOtherDB.dbo.sp_name) in an SqlCommand object.
When I run localy I get an exception saying that it can not find
MyOtherDB in systemdatabase but when I run "select * from
sys.databases" I can see MyOtherDB.??
Can anyone tell me what the problem is??