Re: SQL Server 2008 Problem?

From: "Litchfield, Greg" <glit...@GraceU.edu>
> I have a script that has run successfully for several years.  We> recently changed from SQL Server 2005 to SQL Server 2008 and now my> query results seem to be missing data.  The script runs a stored> procedure.  If I run the stored procedure from SQL Server Management> Studio I get 98 records.  When I run it from my script it only returns> 93 records.  The ones missing are records 74, 77, 95, 97, and 98.  Has> anyone seen a problem like this? 

Use the SQL Server Profiler to see the exact SQL the script attempts 
to run. 

If the script already had an open connection when you started the 
profiler, have a look even at the "Existing Connection" items. Maybe 
the options are set different between the connection used by the 
script and by the Management Studio. The ANSI_NULLS setting comes to 
mind, that one could affect the results as could 
concat_null_yields_null.

Jenda



===== Jen...@Krynicky.cz === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed 
to get drunk and croon as much as they like.
	-- Terry Pratchett in Sourcery

_______________________________________________
Perl-Win32-Database mailing list
Perl...@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs