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, 2 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...

As we now know that XML NULL value takes no space , We would like know the space taken when values(non NULL values) are stored in a column with XML...

Read committed snapshot mode - can read last committed value,

even if "begin transaction" is done after uncommitted "update" query - tested.

what if userB had opened connection(with snapshot), after userA ran update query and commit is pending from user A ?

And

what if user A runs update query first, then user B...

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

My tempdb size = 200mb

Autogrowth set to "By 10 percent, unrestricted growth"

Will be using express edition.

All other errors were solved. Now when I execute DBCC Checkedb i will get only this error.

Msg 8921, Level 16, State 1, Line 1Check terminated. A failure...

Below query tested and time updated

-- with ucase
SELECT COUNT(*) from tblallindex 
WHERE bookdata.exist('/bookstore/book/author/text()[upper-case(.) = ''ERIK T. RAY'']') = 1;
-- CPU time = 5781 ms,  elapsed time...