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]
精彩评论