how to see the data of variables in SQL Profiler

hi everyone...

i am having problem debugging my sql scripts. if i run the application, the stored procedure fails, but if i run the stored procedure in SQL Analyzer, it is successful... i used the SQL profiler to trace the sequence of events in the stored procedure and triggers, however, i cannot see the data of the declared variables.. my question is, is there a way to know or see the contents of the variables in SQL Profiler?

any help would be appreciated...
thanks in advance....

Aug 1 '07 #1

Subscribe Post Reply

3102

DonlonP

hi everyone...

i am having problem debugging my sql scripts. if i run the application, the stored procedure fails, but if i run the stored procedure in SQL Analyzer, it is successful... i used the SQL profiler to trace the sequence of events in the stored procedure and triggers, however, i cannot see the data of the declared variables.. my question is, is there a way to know or see the contents of the variables in SQL Profiler?

any help would be appreciated...
thanks in advance....

To display the value of varaible on the messages screen do:

PRINT (@myVar)

Aug 1 '07 #2

Similar topics

Accessors vs public data members

by: Zap | last post by:

Widespread opinion is that public data members are evil, because if you have to change the way the data is stored in your class you have to break the code accessing it, etc. After reading this...

C / C++

SQL Losing Data

by: Neil Ginsberg | last post by:

We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC linked tables. I recently created a new set of tables for the app, and users are complaining that unsaved data is being...

Microsoft SQL Server

Mysterious loss of data from mssql2k

by: M Wells | last post by:

Hi All, I'm trying to track down a mysterious problem we're experiencing in which updates and inserts to tables in our mssql2k server appear to be 'disappearing.' To explain our situation: ...

Microsoft SQL Server

Any way to find out which SP is updating data in a specific table?

by: serge | last post by:

Can you create an UPDATE TRIGGER and use some type of code to figure out which SP just updated the current table? If not how can i achieve what i want? I tried to run SQL Profiler and i don't...

Microsoft SQL Server

Large Data pass page by page in ASP.Net

by: ivanlkc | last post by:

Hi All, Thanks for reading my post! :-) I would like to ask a question about passing data in ASP.Net. Currently, I use a session variable to keep this data(string) to allow several pages to...

ASP.NET

Static vs Dynamic Variables - Speed Difference

by: Dennis | last post by:

I have a function which is called from a loop many times. In that function, I use three variables as counters and for other purposes. I can either use DIM for declaring the variables or Static. ...

Visual Basic .NET

Application Trace Profiler

by: Bryan | last post by:

Does anyone have an example of an application that can connect to a running process and capture Trace.WriteLine calls like in SQL Server Profiler? I know that we can inherit from a TraceListener...

.NET Framework

ResultSet is from UPDATE. No Data.

by: David Linsin | last post by:

I created a simple test case to reproduce the problem (also check Bug #15500): import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement;...

MySQL Database

Making ones own memory profiler lite in c#

by: Sam Samson | last post by:

Can any-one recommend some good sites detailing how to code a simple memory profiler? How do they "look under the hood"? I built an uber simple service that tracks the process' memory but I need...

C# / C Sharp

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to Use CodiumAI's pr-agent?

by: erikbower65 | last post by:

Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...

General

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

How to insert a new record in a database

by: Taofi | last post by:

I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...

DB2 Database

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

To verify entry of a dropdown

by: DJRhino | last post by:

Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...

Microsoft Access / VBA

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How to calculate date of retirement from date of birth

by: Mushico | last post by:

How to calculate date of retirement from date of birth

Data Management