May 1, 2008 at 1:33 am
hello,
while giving profiler trace to index tuning wizard in sql2k (dev. edition) running on windows 2k3. It shows Error in executing sql statment and show application log in viewer as
--------------
The description for Event ID ( 4 ) in Source ( ITW ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:
Error in Parsing Event:
declare @P1 int
set @P1=0
exec GETSTOCKLEDGER 'Sep 1 2006 12:00:00:000AM', 'Sep 30
-------------
while trying to run those sql query after copying them from text data coloumn of trace table in QA they are showing error in sysntex ie. there is incomplete query in text data coloumn. I don't no why it is showing incomplete query...
But if i use same trace table with sql2k5 by importing database it show complete sql query in text coloumn and also it show no error in DTA
can any one tell me why INDEX TUNNING WIZARD is creating problem
thanks for any kind of support.....
May 1, 2008 at 6:37 am
What does the procedure GETSTOCKLEDGER do? It sounds like you may have incorrect syntax in there, but it could be something wrong on the server itself.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 2, 2008 at 1:45 am
dear,
GETSTOCKLEDGER is just a user defined procedure with some input parameter. above i have describe just a single log which might have arise during the execution of captured statment by profiler.
if there is some probelm on server end then why the same trace table is working fine with sql2k5.
I don't no if this thing is linked with while observing text data coloumn in trace table it show incomplete sql query captured in sql2000
May 2, 2008 at 6:42 am
dheeraj17sharma (5/2/2008)
dear,GETSTOCKLEDGER is just a user defined procedure with some input parameter. above i have describe just a single log which might have arise during the execution of captured statment by profiler.
if there is some probelm on server end then why the same trace table is working fine with sql2k5.
I don't no if this thing is linked with while observing text data coloumn in trace table it show incomplete sql query captured in sql2000
The syntax for the function could be wrong for SQL Server 2000.
You might be seeing truncated code coming out of the text column, not because the data is truncated in the text column (although that's possible) but because Query Analyzer and SSMS have limits on how much text they will return. Go into Tools, Options and look at the properties under Query Results, Results to Grid to be see how much of the text you're able to display.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply