开发者

SQL Server 2008 stored procedure problem

开发者 https://www.devze.com 2023-03-03 03:54 出处:网络
I created a stored procedure on my MFG4 server in the user database having 2 Sections. First section has query like:

I created a stored procedure on my MFG4 server in the user database having 2 Sections.

First section has query like:

Select * From MFG4.User.Usr.EmpMast

And second has

Select * From MFG5.User.Usr.EmpMast

Now I have problem that when the MFG5 server does not have the user database it displays an error even if it does not run fir开发者_运维百科st section where query is all right!!!

What should I do now???


Try This:

SELECT * FROM [MFG4].[User].[dbo].[EmpMast]
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号