Re: Question about SQL Profiler Results

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This newsgroup is for SQL Compact (SQL CE), not SQL Server 2000. You'd probably have better luck getting an answer on a different newsgroup.

--

Ginny Caughey
Device Application Development MVP


"Bishop" <nospam@xxxxxxxxxx> wrote in message news:06750DE6-C292-4596-AE4E-EDFF48E440B7@xxxxxxxxxxxxxxxx
I've been using SQL Profiler to look into why my MS SQL 2K server has been running slow. I've found a number of results from different applications where the TextData is null and the Duration is high. I can determine that they are comming from applications I've written because of the LoginName they use. How can I determine what is happening and why is the TextData null?

.

Relevant Pages

  • Re: Problems with SQL MSDE after SBS SP1 upgrade!
    ... Thanks for updates. ... This newsgroup only focuses on SBS technical issues. ... | Subject: Re: Problems with SQL MSDE after SBS SP1 upgrade! ...
    (microsoft.public.windows.server.sbs)
  • RE: NOLOCK due to data movement
    ... It is unfortunate that you do not understand that this is an SBS problem. ... The default instance of SQL 2005 is working fine. ... Please understanding our newsgroup is mainly focused on SBS support. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Outputs into Word
    ... To get a sql output in word without using mail merge, write a batch file to spool the sql to a temp location on the users c:\ then get the spool file from the temp location to open in word. ... no need for a data source just basic logic. ... One last coment if I may though, I would like thank Cindy again for spending her time trying to resolve my query and also like to show my appreciation for my new found "newsgroup ethiquette". ...
    (microsoft.public.word.docmanagement)
  • RE: Moving an SBS SharePoint Database
    ... Actually this is a SQL issue which should be better handled in our SQL ... Newsgroup. ... Move Databases Between Computers That Are Running SQL Server ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Help please
    ... you can allow access to SQL for user in Windows 2003 domain. ... > newsgroup, as there you may have more good sharing in SQL fields. ... > Microsoft CSS Online Newsgroup Support ... > | At this moment my client use software without license (please don't ask ...
    (microsoft.public.windows.server.sbs)