No , a normal select query with few where conditions followed by a ordey by clause

No . im not using Prepare()  statement

My VB.NET code is in the below format

Dim command As New SqlCommand(query, connection)
command.ExecuteReader()

the query does not contain any variables or parameters

I am using the  read committed isolation level to execute the command

It happens for a particular SELECT query, but the error doesn't occur consistently,it's generated randomly.

I’m running the SQL query through VB.NET code. To check if the query execution time was slow, I executed the query directly on SQL Server and verified that it runs...

We have already tried closing and reopening SSMS. But , that did not work . I want to set this execution timeout for all the sessions in the SSMS programmatically...

Apologies for the confusions caused . I am planning to set the execution timeout for all queries that I will be running in SSMS. My goal is to stop the...

Error: 9001<c/> Severity: 21<c/> State: 5.
Error during rollback. shutting down database (location: 1).
Database was shutdown due to error 3314 in routine 'XdesRMReadWrite::RollbackToLsn'. Restart for non-snapshot databases will...

I have already tried this , does not work . Same error repeats.

When I run the same query multiple times why does the CPU time fluctuate between 0 and 16ms in tracer, query cost and live data explorer? Also I have updated...

To add to what Johan said, I'd also check to make sure your database owner is a valid, enabled user.  I've had service broker fail to send messages because...

What are you trying to do with notification services ?

Chances are you can do it more easy and less intrusive on your server /  instance using Extended Events...

When  the following query was run ,

SELECT * FROM [msdb].[dbo].[suspect_pages]

we found that few pages in a table was corrupted.

If it is a data page we can get...

• This reply was modified 3 years, 5 months ago by   IT researcher.

We have a single SQL server instance , to which 200 users(.net application) are connected and are waiting to receive notification from SQL server when a row has been updated...