开发者

SQL Server 2008 stored procedure problem

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜