Ok been a while.
I have one db that uses DBname..Procname to execute a proc in another dB.
works fine.
On the same server I have created some new DB's and tried the same thing.
I get "Can not find the DB on the server"
I created the DB using the ADP upsize
is there a registration that I need to-do?forgot
this is being called from AmericanBridalInterface db
here is the sp call
execute AmercianBridal..SP_LkUpSupplier @.SupplierID
here is what the profiler shows
[AmericanBridalInterface]..sp_procedure_params_rowset N'SP_LkUpSupplier', 1,
N'dbo', NULL
if exists (select * from syscomments where
id=object_id(N'[dbo].[sp_procedure_params_rowset]')) select c.text,
c.encrypted, c.number, xtype=convert(nchar(2), o.xtype), datalength(c.text),
convert(varbinary(8000), c.text) from syscomments c, sysobjects o where
o.id = c.id and c.id = object_id(N'[dbo].[sp_procedure_params_rowset]')
order by c.number, c.colid
select o.name from sysobjects o where o.xtype = N'P' and
(OBJECTPROPERTY(o.id, N'ExecIsStartup') = 1) and (o.name =N'sp_procedure_params_rowset')
"BJ Freeman" <bj_newsgroups@.free-man.net> wrote in message
news:eQ7zEvGWDHA.548@.tk2msftngp13.phx.gbl...
> Ok been a while.
> I have one db that uses DBname..Procname to execute a proc in another dB.
> works fine.
> On the same server I have created some new DB's and tried the same thing.
> I get "Can not find the DB on the server"
> I created the DB using the ADP upsize
> is there a registration that I need to-do?
>|||never mind. went to sysdatabases and got the name from there.
works now.
"BJ Freeman" <bj_newsgroups@.free-man.net> wrote in message
news:eQ7zEvGWDHA.548@.tk2msftngp13.phx.gbl...
> Ok been a while.
> I have one db that uses DBname..Procname to execute a proc in another dB.
> works fine.
> On the same server I have created some new DB's and tried the same thing.
> I get "Can not find the DB on the server"
> I created the DB using the ADP upsize
> is there a registration that I need to-do?
>
No comments:
Post a Comment