thx Steve, i have a meeting with one of their reps to ask, amongst other things,  why they bring etl biz partners to their seminars if snowpipe is a good...

thx ant-green, report what?   The buggy ssms 21 product or now going on close to a day that my latest  sql server central post on ssms 21 issues disappeared?

...continuing issues...

• This reply was modified 1 week, 4 days ago by stan.
• This reply was modified 1 week, 4 days ago by stan.

there have been 3 updates that i'd like to post ...

-i installed ssms 19 side by side with the buggy ssms 21 and it has no problems in the gui...

i uninstalled ssms and reinstalled with copilot preview and all is well.   thank you.

so...which if any of these is ssms?   This seems somewhat confusing.    am i installing all 4?   how about for core functionality?   in the old days i think we installed...

• This reply was modified 1 week, 6 days ago by stan.

smo 17.100 is the latest so i'll now try a reinstall.  hope it doesnt break vs and put me in a wild goose chase.

running oe details as admin got the same error.    i could be crazy but i think even earlier (on rt click) than attempting the same (rt click and script...

• This reply was modified 1 week, 6 days ago by stan.

i am currently on 21.4.12+5.36408.4.

But am noticing there is an smo version too which sounds more like what is involved in my issue, its 17.100.73 .0+some really long string of...

thx Brian and Steve...

1. im sure he installed it as an admin but wasnt watching what he chose for users.   But the fact that i'm using every other facet of...

im not sure where my last post went but after choosing a very promising button for the ssas extension but not seeing ssas, i rebooted and finally saw what you...

• This reply was modified 2 weeks, 5 days ago by stan.

as i feared i now have to go in search of the analysis services extension.    gonna lookup instructions on the web first.  this extension didnt come along with ssdt. ...

• This reply was modified 2 weeks, 5 days ago by stan.
• This reply was modified 2 weeks, 5 days ago by stan.

yep, its always an adventure.   I chose what you see below ,  noticed to the right that ssdt would be included, followed the instructions, and then in vs searched for...

never mind , i see that info in the deadlock report links.

Instead can you tell me 1) what the frame ids are?, 2) where in the deadlock report i might...

thx lowell, do one or more lines in there tell you which resources deadlocked, on what indexes etc?

interesting.   i generally rdp into that machine and more often than not when i disconnect, ssms is still left running under my creds.   let me see if that makes a...