It's not a stored procedure - direct sql call on a linked server. SELECT DBEMP_EMPLOYEE, RTRIM(UPPER(SUBSTRING(DBEMP_FIRST_NAME, 1, 1))+LOWER(SUBSTRING(DBEMP_FIRST_NAME, 2,20))) +' ' +RTRIM(DBEMP_MIDDLE_INIT)+' '+RTRIM(UPPER(SUBSTRING(DBEMP_LAST_NAME, 1, 1))+LOWER(SUBSTRING(DBEMP_LAST_NAME, 2,20))) AS Full_Name FROM hsremedyweb02.Lawson.dbo.Employee ORDER BY Full_Name Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, December 05, 2006 11:52 AM To: [email protected] Subject: Re: SQL Menus Issue ** Is the DB owner that owns the AR System database permitted to use that stored proceedure? Joe ----- Original Message ---- From: "Dunn, Eric" <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, December 5, 2006 12:47:09 PM Subject: SQL Menus Issue ** I am a little perplexed... I am in the process of migrating from one server to another for an hardware & application upgrade - newer, better, faster hardware. Windows server 2003 SQL 2000 ARSystem 5.01.03 I have built the new server. Loaded SQL server. Loaded AR System. Taken a copy of the database backup from the original server and restored from back up. After restoring, I ran the sp_changedbowner ARAdmin , true command to reassign ARAdmin as the owner. Here is my issue - I have a particle menu - it is a sql query to another server pulling employee information. I have linked the servers together in the same manner as the original. The query does not pull anything back in the client, but if I run the sql query in query analyzer it works.. What am I missing? Eric W. Dunn Programmer Analyst III - Remedy/Collaboration McLeod USA, Inc. - Network Engineering 8665 New Trails Dr. The Woodlands, TX 77381 (281)465-1265 (281)465-1951 fax NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. __20060125_______________________This posting was submitted with HTML in it___ _____ Check out the <http://us.rd.yahoo.com/evt=43257/*http://advision.webevents.yahoo.com/mailb eta> all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster. __20060125_______________________This posting was submitted with HTML in it___ NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
