checking success of a request in a stored procedure

Hi,
Say I have a stored procedure which does two INSERT operation.
How can I check if the first INSERT succeeded in order to know if I
should carry on and do the second one ?

RegardsYou can check @.@.ERROR to see if an error was raised, or @.@.ROWCOUNT to
see how many rows were inserted - in some cases you might consider it
an error if no rows were inserted.

See here for much more information:

http://www.sommarskog.se/error-handling-II.html

Simon

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgs
what operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs
|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thru
a client interface
tks & rdgs
"wei xiao" wrote:

> what operation do you have in mind? performance monitor can show you network
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
>
>

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgswhat operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thru
a client interface
tks & rdgs
"wei xiao" wrote:
> what operation do you have in mind? performance monitor can show you network
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> > Hi ,
> >
> > how can i check if the current bandwidth that i am having is enough for
> > the operation ? can i use the performance monitor or the profiler(which
> > item
> > to choose) ?
> >
> > tks & rdgs
>
>

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgswhat operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thr
u
a client interface
tks & rdgs
"wei xiao" wrote:

> what operation do you have in mind? performance monitor can show you netwo
rk
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
>
>