Unable To Get MAPI Profiles

Jan 22, 2008

Error message "Unable to get MAPI profiles" in send mail task(DTS).

View 4 Replies


ADVERTISEMENT

SQL Mail - MAPI Profiles On Windows Server 2003

Sep 16, 2005

Scenario:DBMS: SQL Server 2000OS: Windows Server 2003Goal:Enable SQLMAIL via Internet MailProblem:How do I set up the MAPI profile for the SQL Server service account?On Windows 2000 Server, I can use "Control Panel"/"Mail" tocreate a MAPI profile for the SQL Server service account, and thenreference that profile for SQLMAIL in SQL Server and SQL Server Agent.But on Windows Server 2003, there is no "Mail" applet in "Control Panel".How do I create a MAPI profile, for the SQL Server service account,on Windows Server 2003?

View 5 Replies View Related

SQL Server And Profiles.

Mar 16, 2006

I've created a website using Microsoft's built-in profile/membership system. I'm used to referring to these elements without actually having to interact with the underlying tables. Thus, I type:Profile.UserName when I want a users UserName rather than querying the database manually.Now, I need to create a scheduled job in SQL that sends emails out based upon user preferences specified under Profile. Is there a way to use Profile within SQL Server 2005?David.

View 1 Replies View Related

Transactions And Profiles

May 26, 2006

HiI'm trying to make a transaction with the TransactionScope class and if I modify a profile and call ProfileBase.Save(), it throws an exception with the message: "MSDTC is unavailable".thanks

View 1 Replies View Related

Matching Users Profiles Using Sql

May 5, 2007

Hi folks
I have a section in my networking site where people can write things about themselves, such as likes dislikes, hobbies etc for their profile.
I am looking to provide a very basic profile matching service, and have done a bit of searching to find out what the best way to approach this feature is. I have looked at using the sql LIKE clause, but since the profile information can be any length, there seem to be too many variables to account for. I have also looked at identifying keywords in profile blurbs to do the matching too, but I am struggling to see how this could be done with relative ease.
My reason for posting this is simply to get some experienced knowledge about where to start the problem, of even some resources to look at that I may not have found yet.
If anyone could give me some advice on where to start i would be very grateful
I am develping in vb, with an sql server 2005 back-end

View 2 Replies View Related

SQL Server Configuration For ASP.NET 2.0 Profiles

Apr 12, 2006

Hi,
I want to configure SQL Server 2005 Express to work with profiles and that kind of ASP.NET 2.0 things :)
The problem is, when I run aspnet_regsql.exe I can't get a list of databases, and when I manually enter the database name, I get the same error."(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I've enabled the named pipes and tcp/ip connections in the Server Configuration Manager.I've also tried multiple logins.
I run the sql server locally.I can connect with my website to it, I can use the Management Studio Express (with win auth).
But I can't get those tables configured :(
Anybody got an idea?
Thanks in advance.

View 2 Replies View Related

Xp_startmail And Switching Profiles

May 13, 2002

Guys!
I'm using SQL Mail to send out Emails to Customers re: outstanding Invoices. I also use SQL Mail on the same box to send out emails to our Sales Reps with summaries of outstanding invoices. Now, I've set up multiple outlook profiles on the server. I tried using

xp_startmail @user = 'CreditControlDept'
xp_sendmail .... (to customers)
xp_stopmail @user = 'CreditControlDept'
xp_startmail @user = 'InvoiceTracker'
xp_sendmail...(to internal sales reps)
xp_stopmail @user = 'InvoiceTracker'

DOES NOT WORK!!! the profile does'nt switch at all. SQL Mail sends out all the emails using the profile that it started with. How can I use xp_startmail and xp_stopmail to switch between different user profiles.

Regards
Uday

View 1 Replies View Related

How To Find Matching Profiles?

May 6, 2006

Users have to answer 17 simple yes/no questions and the answers are stored in an column for each question as tinyint 0/1 values.

At least that's what seems reasonable to me at the moment.

The table is under my control so I could change it if needed.

Now from several tenthousend or maybe hundreds of thousends of entries I need to find those with the closest match. Of course, I need all of the entries that have the exact same answers and this is no problem. But - at least if there are not enough full matches - then I need all records that have maybe 16,15,14... matches out of the 17 answers.

I have not yet the idea on how to handle this without quering 17*16 different answer schemes.

View 7 Replies View Related

Storing ASP.NET 2.0 Profiles In SQL Server 2005

Oct 17, 2007

Hi Everyone,
I have an e-commerce site that uses Profiles in ASP.NET 2.0 to store items in a shopping cart.  The problem is that we are now using LDAP authentication, so we are getting rid of the ASPNETDB membership database that stores the profile values.  How can get the shopping cart functionalty to work with SQL Server 2005?  How can I store the profile object in a SQL Server instead of the ASP.NET memberships database?
Here is the profile field:
  <profile enabled="true">      <properties>        <add name="Cart" serializeAs="Binary" type="Commerce.ShoppingCart" allowAnonymous="true"/>      </properties>    </profile>
 
Thank you in Advance
-Sam 
 

View 1 Replies View Related

Can We Use SQLServer 2000 For ASP.NET Profiles And Aspnetdb ?

May 16, 2006

Hi,Can we use SQL Server 2000 for ASP.NET Profiles, Security etc.. ?for ASP.NET2.x?instead of SQL Server 2005 or Express editions?Rizwan

View 1 Replies View Related

SQL MAPI Problem

Aug 13, 2000

I am trying to install SQL Mail to send automatic system messages. The SQL Mail service starts but when I try to test it I get the following error. Does any one have any solution to this problem?

Error: A Mapi error ( error number 273) occured. Unable to get the default MAPI message Store due to MAPI error 273. The information store could not be opened.

View 2 Replies View Related

SQL MAPI Problem

Aug 13, 2000

I am trying to install SQL Mail to send automatic system messages. The SQL Mail service starts but when I try to test it I get the following error. Does any one have any solution to this problem?

Error: A Mapi error ( error number 273) occured. Unable to get the default MAPI message Store due to MAPI error 273. The information store could not be opened.

View 1 Replies View Related

SQLMail, MAPI Profile

Aug 7, 2000

I created a new MAPI profile on the server, and it seems to work fine with Outlook. I also dropped the previous default MAPI profile.

Now, when I go to the EM SQLAgent Properties, the only MAP profile offered in the SQLMail drop-down is the old, deleted profile. Also, only the old profile comes up with xp_get_MAPI_profiles.

How can I get SQLAgent to recognize that I've set up a new mail profile?

View 1 Replies View Related

MAPI Client E-Mail

Jun 28, 2000

Hello,

I would like to send e-mails from MS SQL Server 7. Does Linux accept MAPI client e-mails and deliver them? And if so, how does one set it up?

Thanks,
Denise

View 2 Replies View Related

SQL Mail MAPI Error

Mar 13, 2001

Hi,

I recently installed MS SQL server version 7.00.623 on a Win2k server. I installed Outlook 2000 and had the Exchange Administrator create a mailbox in order to use SQL Mail and SQL Server Agent alerts when jobs fail. The Outlook mailbox was set up with a different name then the SQL Server Agent so I created a new account for the SQL Server Agent to match the name of the mailbox. I can send and receive mail from Outlook when logged into the server but I receive the following error when testing the profile in SQL Mail and SQL Server Agent properties:

"[260] Unable to start mail session (reason: Unable to logon (reason: Unable to get the default MAPI Message Store due to MAPI error 273: The information store could not be opened); check the mail profile and/or the SQLServerAgent service startup account)"

The SQL Server Agent account is a NT User type, uses NT Authentication and has sysadmin server privledges and I am attempting to configure the mail while logging in to the server via Terminal Services Client using this account. I have tried to stop and restart the SQL Server Agent services but still receive the same error. When I log into Outlook, I receive a dialog box titled "Enter Password" that asks for a user name, domain name and password. The Exchange Admin. set this up so I have to use my user name, domain and password.




Do I need to install a service pack for SQL Server?

Did changing the SQL Server Agent account cause this to fail?

Does anyone have any insight on why I cannot get SQL Mail configured?

Thank You So Much

View 2 Replies View Related

Dts And Mapi Login Failure

Jan 8, 2002

I have several dts packages that run just fine through a third party scheduler. I then put a mail task on them to tell me if the package succeeded or failed. Every time the scheduler gets to the mail task it fails and logs a mapi login failure error. When I execute the dts package on my local box it sends the email with no problems. is it a problem with the robot login or is it associated to the profile? any help would be greatly appreciated.

Elizabeth

View 1 Replies View Related

Why Not Outlook For DTS MAPI Client?

Apr 12, 2002

My IT manager doesn't like the idea that a production process written in DTS needs Outlook 2000 running for DTS Email. I tend to agree that having an app like Outlook 2000 running in the production machine is kind of tacky. Am I missing something here? Why would MS suggest such a solution? Is there a way to configure DTS and Outlook so Outlook doesnt have to be running as an app?

Chiefley

View 1 Replies View Related

MAPI Login Failure

Jun 1, 1999

I have a situation where a SQL Maintenance Task is running, and suppose to email a report to the sys admin. Currently I am getting a Microsoft SQL-DMO Error 17903, Mapi Login Failure.

I have tested the Outlook 98 application and the profile is set correctly. I have tried to send an email within SQL and I receive the error above. I have carried all activities suggested by Microsofts Online Books. Can anyone suggest where to go from here. All Service Packs have been applied.

Thanks
Chris Le ROY

View 2 Replies View Related

SQL/MAIL -MAPI- Error Need Some Clues.

Nov 7, 2000

I set up e-mail on my SQL server (7.0) via SMTP.
I installed Outlook '97. Typical Installation.
Everything was working fine, for couple of days,
then I got Dr. Watson messages, about MAPI.
Dr.Watson
The application, exemapisp32.dbg, generated an application error The error occurred on 11/ 7/2000 @ 11:35:48.437 The exception generated was c0000005 at address 6e4f2630 (<nosymbols>)

Then SQL will give me this message:

Unable to read local eventlog (reason: The data area passed to a system call is too small).

Anyway, try to reinstall Outlook '97, but the problem continues.
Any help, will be greatly appreciated.

View 1 Replies View Related

SQL-MAIL : MAPI LOGIN FAILED

Nov 22, 1999

Hi friends,

I have Exchange & sql 7.0 on the same box. I have configured sqlserver
and sqlserveragent for the same nt login. Also a Mail profile is created and assigned to SQL-MAIL & SQL-AGENT.

I have a back-up job in SQLSERVER and the notification is set to exchange mail box. For the first time after restarting the exchange services, the notification works fine. But for the subsequent job executions, the notification failed and the message is "MAPI LOGIN FAILED".

Can any one help me..

Thanx in advance.

regards
MANI

View 1 Replies View Related

Test MAPI Connection (Definitive Description)

Feb 9, 2005

(Isn't this fun? Type MAPI and SQL into Google and it almost tilts!)

Here is the situation:
1- When SQL Agent starts, it establishes a MAPI session. For some bizarre design reason, it keeps that session open as long as it is running, rather than re-opening the session when it has mail to send. (this can be days, weeks, or months)
2- Frequently, Exchange servers are clustered. When the virtual server moves to a different physical server in the cluster, - or the Exchange server is restarted for whatever reason - the (above) MAPI session of the SQL Agent gets jammed.
3- SQL Agent tries, and fails to send an E-mail saying (for instance) that a database dump has completed (etc.)
4- User posts a question to some forum, asking for help again.

My solution: I created a job to run on a daily basis to restart the SQL Agent, and re-establish the MAPI session. Voila!

The problem: Now we (sometimes) get the message:
[241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)
This is incorrect - the service was never stopped!

*sigh* No hits in Microsoft or Google - Back to the drawing board.

SO: Can anyone think of a way to *test* the MAPI connection in a job step (without actually sending a message), so that the agent restart job is only executed if the MAPI connection is failing?

View 2 Replies View Related

SQL 2000 MAPI Mail Interface To Lotus Notes

Apr 23, 2001

I have not yet set up SQL2K mail -> Notes, but I see in Q263556 a warning regarding extended MAPI and non-Exchange servers.

Just wondering if anyone is using a SQL2K - Notes MAPI profile -- and if any reliability issues have come up?

Thanks in advance

View 1 Replies View Related

SQL Server 2008 :: Migrate All DB Mail Profiles To New Server?

Oct 6, 2015

I need to migrate the all dbmail profiles(around 15) from Old server to new SQL instance.

is their any script or any way to do so that i can perform all at a time instead of doing manually.

View 0 Replies View Related

URGENT.Sql Server Does Not Recognise MAPI , Or Profile Name URGENT

Oct 26, 2000

hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed

I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.

I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.

My next question, How to configure MAPI in Sql server if what I did was wrong.

View 1 Replies View Related

SQLServerAgent Error: MAPI Error: Table Too Big...Please Help

Aug 10, 2001

I'm trying to send a Test Email to Operators defined in a SQL 7.0 server (currently on SP2). And get the following error message:
"Error 22022: SQLServerAgent Error: MAPI error: Table too big."

We've checked the email profiles (also performed test on SQL MAIL) and can stop/start SQL Mail successfully. Verified that the accounts are correctly identified with appropriate permissions. MSDB is 150MB with no table that looks abnormal in size.

Has anyone come across this situation? Please let me know. THANKS!!!

View 2 Replies View Related

Unable To Connect To DB

Nov 27, 2006

Hello everybody
I wrote a vb.net win app that uses a mssql 2005 express DB.
On my localcomputer everything worked without a problem.
Now I wish to deploy my app on a remote computer (that has mssql 2005 express installed), so. I added an app setup project to my project using the vs2005 setup tool, installed the app on the remote computer, and copied the mdf file to the remote computer.
I'm able to see the DB through the remote computer mssql manager, But when I try to start the app on the remote computer I get this error massage :
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. error: 0 - No process is on the other end of the pipe.)
my connectionstring (in the config file) looks like that :
    <connectionStrings>        <add name="Info_Manager.My.MySettings.MaxinetConnectionString"            connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True"            providerName="System.Data.SqlClient" />        <add name="Info_Manager.My.MySettings.MaxinetConnectionString1"            connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True"            providerName="System.Data.SqlClient" />    </connectionStrings>
by the way changing the user instance attribute to "false" didn't help.
Does anybody know how to fix this problem.
 
 

View 2 Replies View Related

Unable To Use SQL Profiler

Aug 8, 2000

I am using SQL7. On the client network utility, I am using name pipe and have 4 entries and they are in the same format (ie. server name, named pipes and ip address). I have problem to connect to some of them and getting
[microsoft][ODBC SQL Server Driver]Client unable to establish connection
and [microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(CreateFile())
Any idea?

View 1 Replies View Related

Unable To Register

Jan 30, 2001

Hi,
I am trying to register one server and I get the following message -
"Client unable to establish connection Connection OpenCreatefile()"
Any advice highly appreciated.
Thanks
PD

View 1 Replies View Related

Unable To Connect

Aug 14, 1998

Howdy

Every time i reboot my NT Server and the SQL server service starts up. It logs this message to the event Viewer

Severity: 9 Error:10004, OS: 11001 Unable to connect: SQL Server is unavailable or does not exist. General network error. Check your documentation.ConnectionOpen (gethostbyname()()).

I don`t have any problem with the databases, all the users are able to connect to server and database without any problems, looks like everything is working at its best. But i am little concerned about this error message.

Please help

Thanks
vIVEk

View 1 Replies View Related

Unable To Restore To Other DB ?

Jul 22, 2004

Hi,

I have every nights a backup script that is running using the following command on my sql server 2000 :

backup database MYDB to disk="d:mssql2000MSSQLBACKUPdb_MYSERVER_MYDB.bak" with init

Now, i need to restore one of these files to a new Database with another name...in order to look at certain table and its content

I'm unable to find the correct RESTORE command and didn't find how to do it using enterprise Manager..

Any help would be VERY welcome ;-))

Florent -- Near the whole

View 6 Replies View Related

Unable To Connect

Apr 1, 2002

Everything has been working fine our SQL Server (lets call it Server A) (v2000 under NT 4), however sometime over the weekend it is unable to connect to one of our other SQL Servers (Server B).

In the Event Viewer I found this error:
SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip (TCP/IP)): Error 10013.

Everything on this server appears to be working fine, as in everything can connect to Sever A that needs to, but Server B can't connect to A, nor is it working the other way.

Also, Server A SQL Services run on port 2006, and B is on the standard 1433. Everything has been working with this up until today?

Any ideas?
Thanks!

Keith

View 1 Replies View Related

Unable To Backup All The Dbs

Apr 24, 2008

i am using sql 2005,i want to backup all the databases when i try to schedule a maintenance plan , i dont get all the databases listed event though i authenticate as SA.

View 6 Replies View Related

Unable To Complie

Jan 26, 2007

hi
i WAS ABLE TO COMPLIE this proc in the morning but droped unknowningly now iam unable to complie
all the column 'empr_id' exists when i run this speratly the select statement it works


CREATE PROCEDURE search_trans
(
@tpa_idvarchar(6),
@empr_idvarchar(18) = NULL,
@empe_keyint = NULL,
@service_start_dtedatetime= NULL,
@user_id_keyint,
@acct_type_cdevarchar(4) = NULL,
@batch_countint = 20
)
AS
BEGIN

SET NOCOUNT ON

DECLARE@total_errorstinyint,
@TXN_PROCESS_CDE_VALIDsmallint,
@DuplicateFlagint,
@user_type_cdesmallint,
@USER_TYPE_MBIsmallint,
@USER_TYPE_SYSTEMsmallint

SELECT@total_errors = 0,
@TXN_PROCESS_CDE_VALID= 1,
@DuplicateFlag=16,
@user_type_cde= dbo.udf_GetUserTypeCode(@user_id_key),
@USER_TYPE_MBI= 1,
@USER_TYPE_SYSTEM= 16,
@tpa_id = dbo.udf_IsDefaultString(@tpa_id, NULL),
@empr_id = dbo.udf_IsDefaultString(@empr_id, NULL),
@empe_key = dbo.udf_IsDefaultInt32(@empe_key, NULL),
@acct_type_cde = dbo.udf_IsDefaultString(@acct_type_cde, NULL),
@service_start_dte = dbo.udf_IsDefaultDateTime(@service_start_dte, NULL)


IF @tpa_id IS NULL
BEGIN
EXECUTE @total_errors = dbo.usp_ERR_InsertUserError @error_cde = 18015, -- TODO error code
@error_cnt = @total_errors
END

IF @total_errors > 0
BEGIN
GOTO EXITSP
END

DECLARE@TEMP_DUPLICATES TABLE
(
tpa_id VARCHAR(6) NOT NULL,
empr_id VARCHAR(18) NOT NULL,
empe_key INT NOT NULL,
service_start_dte datetime, -- TODO finish this declaration,
service_end_dte datetime,
cardholder_name VARCHAR(2000),
txn_amt_orig decimal(19,4),
approved_amt int,
denied_amt int,
merchant_name VARCHAR(50),
MTC char(4),
notes varchar(255),
txn_options smallint
)
INSERT INTO @TEMP_DUPLICATES
(
tpa_id,
empr_id,
empe_key,
service_start_dte,
service_end_dte,
cardholder_name,
txn_amt_orig,
--approved_amt
denied_amt,
merchant_name,
MTC,
notes,
is_dup
)
SELECT TOP 20 -- TODO latest entered @batch_count value duplicate records
FT.tpa_id,
FT.empr_id,
FT.empe_key,
FT.service_start_dte,
FT.service_end_dte,
(e.first_name+ ', '+ e.last_name ) AS cardholder_name, -- TODO: construct name with

firstname,lastname with joining with employee/dep tables if needed should decrypt the data
--E.first_name if cardholder_name is accessed by employee then these two column can be ignored,
--E.last_name,
FT.txn_amt_orig,
--approved_amt, -- --Need to to put condition to how to get approved amt,
FT.denied_fee, -- This column considered for denied_amt as this column doesnot exists
FT.merch_name,
FT.merch_id, -- MTC column on UI
FT.notes,
is_dup = '1'
FROM dbo.[vw_PDB_FLEX_TXN] FT (NOLOCK) INNER JOIN
dbo.[EMPLOYEE] E ON (E.[tpa_id] = FT.[tpa_id] AND E.[empr_id] = FT.[empr_id] AND E.[empe_key] =

FT.[empe_key])
inner join dbo.[TPA] T ON (E.[tpa_id] = T.[tpa_id]) INNER JOIN
dbo.[EMPLOYER] ER on (E.[tpa_id] = ER.[tpa_id] and E.[empr_id] = ER.[empr_id])
WHERE -- Duplicate records
FT.origin_cde >= 50 -- manual transactions
AND FT.txn_adjud_cde = 1 -- approved transactions
AND FT.txn_cde in ('10')
AND FT.txn_process_cde = @TXN_PROCESS_CDE_VALID -- valid
AND FT.[tpa_id] = @tpa_id
AND FT.[service_start_dte] = @service_start_dte
ANDFT.[etxn_seq_num] = 1
AND ((@acct_type_cde IS NULL) OR (@acct_type_cde IS NOT NULL AND FT.[acct_type_cde] =

@acct_type_cde))
AND (FT.txn_options & @DuplicateFlag = @DuplicateFlag)
AND FT.reimb_key is null -- not reimbused yet
-- Employer Id optional
AND ((@empr_id IS NULL) OR (@empr_id IS NOT NULL AND T.[empr_id] = @empr_id))
-- User has access to employer
AND(@user_type_cde IN (@USER_TYPE_MBI, @USER_TYPE_SYSTEM)
OR (@user_type_cde NOT IN (@USER_TYPE_MBI, @USER_TYPE_SYSTEM)
AND T.[empr_id] IN (SELECT[empr_id]
FROMdbo.[USER_EMPLOYER]
WHERE[tpa_id] = @tpa_id
ANDuser_id_key = @user_id_key)))
AND ((@empe_key IS NULL) OR (@empe_key IS NOT NULL AND FT.empe_key = @empe_key))
-- TPA is not active (All Status Except Perm Inactive)
AND T.[tpa_status_cde] < 4
-- Employer is active (All Status Except Perm Inactive)
AND ER.[empr_status_cde] < 4
ORDER BY FT.txn_dte DESC
--UNION ALL

-- join @TEMP_DUPLICATES table with dbo.[vw_PDB_FLEX_TXN]
-- to find out for each of above 20 records, possible duplicate claims
-- investigate more to make join/union/insert into -- the final goal is this SP should return all 'y' and 'n' data

EFFICIENTLY (NO CURSORS IN SP)


INSERT INTO @TEMP_DUPLICATES
(
tpa_id,
empr_id,
empe_key,
service_start_dte,
service_end_dte,
cardholder_name,
txn_amt_orig,
--approved_amt,
denied_amt,
merchant_name,
MTC,
notes,
is_dup
)
SELECT t.tpa_id,
t.empr_id,
t.empe_key,
t.service_start_dte,
t.service_end_dte,
(e.first_name+ ', '+ e.last_name ) AS cardholder_name, -- TODO: construct name with firstname,

lastname with joining with employee/dep tables
t.txn_amt_orig,
--t.approved_amt,
t.denied_fee,-- This column considered for denied_amt as this column doesnot exists
t.merch_name,
t.MTC,
t.notes ,
is_dup = '0'
FROM dbo.[vw_PDB_FLEX_TXN] T (NOLOCK) INNER JOIN @TEMP_DUPLICATES TP ON
(TP.tpa_id = T.tpa_id
AND TP.empr_id = T.empr_id
AND TP.empe_key = T.empe_key
AND TP.service_start_dte = T.service_start_dte
AND TP.[txn_amt_orig] = T.[txn_amt_orig]
)
INNER JOIN dbo.[EMPLOYEE] E ON E.empr_id = T.empr_id

WHERE (T.txn_options & @DuplicateFlag != @DuplicateFlag)
AND T.[tpa_id] = @tpa_id
AND T.[service_start_dte] = @service_start_dte
AND T.txn_cde in ('10','11','12')
ANDT.[etxn_seq_num] = 1
AND T.txn_process_cde = @TXN_PROCESS_CDE_VALID -- valid



-- NEED TO RETURN @TEMP_DUPLICATES ROWS
RETURN(0)

EXITSP:

IF @total_errors > 0
BEGIN
EXECUTE dbo.usp_ERR_GetUserErrors
END

RETURN (@total_errors)

END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

error:
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 70
Invalid column name 'is_dup'.
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 70
Invalid column name 'empr_id'.
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 70
Invalid column name 'empr_id'.
Server: Msg 207, Level 16, State 1, Procedure usp_TXN_SearchDupFlexTxn, Line 139
Invalid column name 'is_dup'.

krmm

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved