Viewing 11 posts - 1 through 11 (of 11 total)
No go on the restart of SSMS. Tried on another server and it worked fine. It was 13.0.4422 but SSMS 17.1. All databases are compatibility mode of SQL 2016.
November 14, 2018 at 7:36 am
Sue,
Thanks for the link. Uninstalled\reinstalled 16.5 and was able top connect.
Joe, I have full admin rights but tried 'run as admin' to no avail before going...
April 11, 2018 at 5:58 am
Couldn't get it to work that way but it headed me but down the right road. Specified a new condition using database facet in the 'Against targets' and the existing...
October 5, 2017 at 10:28 am
When I try the distributed transaction I get error
Msg 3910, Level 16, State 2, Line 3
Transaction context in use by another session. I tried killing...
September 1, 2017 at 10:43 am
There was an entry for another server. My best guess is that it was somehow leftover from a vm cloning process as that server no longer exists. Thanks for the...
July 24, 2017 at 10:47 am
Result from select @@servername
RIPNCSMDB1
Result from
sp_dropserver
July 20, 2017 at 1:47 pm
This indicates a text mix page which is new to me. The object id is the table. My issue may be more isolation level than the clustering as I...
September 10, 2013 at 11:13 am
Code below. You are correct on the serializable but am verifying I have the right code as this is almost the entire sp less some declarations. I asked about...
September 10, 2013 at 9:29 am
The deadlock info is below. Both spids are inserting via the same stored procedure. This is an audit type table so there are high inserts. There is...
September 10, 2013 at 8:42 am
The index page is showing on the deadlock graph which led to my assumption.
September 9, 2013 at 10:11 am
Viewing 11 posts - 1 through 11 (of 11 total)