If I am executing a query in MS Query Analyzer it runs in a few seconds. But when I want an ADO recordset of that query, it gives a timeout after 60 seconds.
I remarked that if I execute the query myself in MS Query it looks like this:
SELECT * FROM Customers
But when I intercept the query in Profiler, it looks like this:
exec sp_executesql N'(SELECT * FROM Customers (nolock))' And then it times out
When I add ‘exec sp_executesql’ in front of my query in MS Query Analyzer, it also gives timeouts.
Who can I avoid that MS SQL Server adds this command in front of my query?