Groups | Blog | Home
all groups > sql server new users > november 2004 >

sql server new users : error is storing data


wessam
11/30/2004 4:41:04 AM
Hello,
i've made an application with the vb.net and i created my connection
through the sql server by stored procedure. The identity of the [ID] of the
table that the data is stored in is on and i've entered some data as a trial.
Then i've deleted the rows that i've entered and i made the identity off and
then i made refresh then i made the identity on so that the data entered to
be accurate.
unfortunately when i've ran the application no data was stored in the table
and there is no error appeared !! and i don't know what to do!!
Your help is appriciated

rboyd NO[at]SPAM onlinemicrosoft.com
11/30/2004 2:54:24 PM
You can use SQL Server profiler to capture the commands that go to the SQL
Server. This way yyou can see if the command to insert the data is even
getting executed.

You will want to capture the following events:

Errors and Warnings
TSQL
Stored procedures

Launch Profiler and then insert data via the application. Check to see if
the insert gets to SQL Server. There may be an error that is getting
generated.

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button