Search:  
NamespacesDiscussions.NET v1.1Feedback
Tracking back SqlClient accesses
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.


Remas Wojciechowski
Hi!

I'm using the SqlClient to read/modify/... data on my sql server.
Intermittently some records are changed even though I wouldn't expect them
to. If I were able to find out when and which modifications were sent to the
sql server from my page, it could give some indications where to look for
the bug. I tried to open/read the transaction protocol (LDF file) but to no
avail. Any hints?

(I hope that post is not too much OT)

Thanks
Remas
http://www.aspalliance.com/remas
Reply to this message...
 
    
Brian W. Spolarich

You could use SQL Profiler to do this, which comes with the SQL Server =
2000 administration tools.

-bws

| -----Original Message-----
| From: Remas Wojciechowski [mailto:Click here to reveal e-mail address]
| Sent: Wednesday, July 10, 2002 9:19 AM
| To: ngfx-sqlclient
| Subject: [ngfx-sqlclient] Tracking back SqlClient accesses
|=20
|=20
| Hi!
|=20
| I'm using the SqlClient to read/modify/... data on my sql server.
| Intermittently some records are changed even though I=20
| wouldn't expect them
| to. If I were able to find out when and which modifications=20
| were sent to the
| sql server from my page, it could give some indications where=20
| to look for
| the bug. I tried to open/read the transaction protocol (LDF=20
| file) but to no
| avail. Any hints?
|=20
| (I hope that post is not too much OT)
|=20
| Thanks
| Remas
| http://www.aspalliance.com/remas
|=20
|=20
| | [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR =
ID
| | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D =
JOIN/QUIT
|=20
Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com