Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-10-27 : 15:04:40
|
| 1/When I create a new trace, it gives me sevral events including the SQL server s own functions and provcedures. How do I tell profiler to display only the requests we send SQL server from a VB program or other company made programs instead of including sql server own events as well. That will help me filter the requests and locate the problem easily.2/ also ,. sometimes, my text data column description gets truncated and as a result I can't see the whole text of a request. What causes that and how can I fox it pls?Thank you, i am not familiar with profiler. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-27 : 15:12:18
|
| 1. Add filters to your trace2. Save the data to a table. You will get the entire string in the TextData column.Tara Kizer |
 |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2006-10-27 : 16:20:55
|
| for 1/ which columns in the filter should i keep or remove in order to get only the commands we send to sql server from the vbthanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-27 : 16:40:11
|
| I filter on the LoginName. There are lots of ways to filter though. You can exclude the database server. You can include the HostName of the clients you want to profile. Etc...Tara Kizer |
|
|
|
|
|
|
using profiler