You can still use a stored procedure.<br>
Just compile it in the Master database.<br>
This will give you access from any database on the <br>
server.<br>
All the message is telling you is that the temp<br>
table #searchtemp has not been created on the second<br>
server.<br>
You need to find the DDL for it on the first sever<br>
and run it on the second server.<br>
Your procedure should compile fine after that.<br>
Also you might want to change...
Just place the % sign in from of the partial drug name and use LIKE in the where clause.<br>
<br>
WHERE drugname LIKE "partial%"<br>
OR<br>
WHERE drugname LIKE "%partial%"<br>
OR<br>
WHERE drugname LIKE "%partial"<br>
<br>
I ran into this one myself.<br>
My problem was that the drive I was installing to was NOT an<br>
NTFS file system. <br>
As soon as I converted to NTFS, everything worked fine.<br>
Search NT help for CONVERT.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.