MS SQL Server MSEQ - Insert data

Author

Insert data

BMW

2006-10-24, 6:49 pm

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.

Thanks.

Arnie Rowland

2006-10-24, 6:49 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/genera...s-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

"BMW" <BMW@discussions.microsoft.com> wrote in message
news:4B998D1D-D459-4374-BFE0- 92D1A490DFF5@microso
ft.com...
> 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.
>
> Thanks.

Sponsored Links