sql server mseq: Insert data -- sql server mseq

Insert data

BMW
10/6/2006 3:38:01 PM

sql server mseq: Hi,

I haven't figure out why the store procedure execute withour error, but the
data doesn't on the table.

I have a store procedure which is call by the component in the exchange
server.
I saw the store procedure is compelted on SQL Server Profiler and the writer
comlun display '1'. However the data didn't insert on the table. Also the
store procedure returns the value to indicate there were success.

The exchange server connects to the server sql 2005 by using TCp/IP protocol.
The user is domain admin.

I succeed add one new record only suddenly even the write column did show
'0'. For all tests, the data didn't insert on the table.

Hope someone help me to solve it.

Re: Insert data

Arnie Rowland
10/6/2006 4:11:09 PM

It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )

The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

[quoted text, click to view]