Detect what version of SQL Server Express engine is available before connection?

I would like to detect what version of SQL Server Express engine is available so that I can connect either to the (localdb)\v.11 (SQL Server 2012 per https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/hh510202(v=sql.110)?redirectedfrom=MSDN#Anchor_1) or (localdb)\MSSQLLocalDB (SQL Server 2014 and up per https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15&redirectedfrom=MSDN&viewFallbackFrom=sql-server-2014#Anchor_1) instance name when attempting to attach a file in the connection string using the AttachDBFileName= mechanism.

I would most likely want to do it from Powershell in some manner, but whatever method is reliable, I can use. I do know that sometimes a LocalDB connection can be a bit slow as it attaches the file and starts up on demand, so I have in the past been pretty lenient on the connect timeout for these LocalDB connections compared to the real SQL Server connections, so I would prefer not trying to connect and waiting for timeout, since I think I’ve already got an exaggerated timeout just for normal successful connection.

How to detect two different mice at the same time, and record their separate movements?

I would like to use two computer mice simultaneously, and to record data their separate movements on windows. I have successfully used TeamPlayer to create two cursors, but the software that I am using to record the movement data records only one output – the sum of the two cursors. How am I to use both computer mice at once, and record their separate outputs?

I have looked at the thread Is it possible to detect two different mice at the same time, and have their movements recorded seperately?, but this is quite old now and most of the solutions offered are now unavailable.

What is the best way to detect constant or periodic amplitude of the spectrogram?

Suppose I get interpolating function in the solution of the complicated differential system. I plot a solution for various input values that control the outcome of the solution. Some give exponential results and some give sinusoidal results with constant amplitude (periodic) and sinusoidal with increasing amplitude. I am trying to find the solution with constant periodic amplitude. I do that with spectrogram. How do I detect that in spectrogram? In the code, you can see that spectrogram shows constant peaks. I used peak detect for solution of the ode, extrapolated a linear function and calculated the slope of those peaks. But that is time consuming and not a very thorough method. I am looking for another method using spectrogram or other. t1 and t3 shows true and t2 shows false for amplitude detection.

ClearAll; xrange=40; ode={y''[x]+a*y'[x]+b*y[x]==0,y'[0]==1,y[0]==0}; solution1=NDSolve[ode/.{a->0.0,b->2},y[x],{x,0,xrange}]  Plot[Evaluate[y[x]/.solution1],{x,0,xrange},PlotRange->All]  solution2=NDSolve[ode/.{a->0.2,b->2},y[x],{x,0,xrange}]  Plot[Evaluate[y[x]/.solution2],{x,0,xrange},PlotRange->All]   Plot[Evaluate[Sin[0.5*x]*Cos[6*x]],{x,0,xrange},PlotRange->All]  t1=Table[Evaluate[y[x]/.solution1][[1]],{x,0,xrange,1/20}]; Spectrogram[t1]  t2=Table[Evaluate[y[x]/.solution2][[1]],{x,0,xrange,1/20}]; Spectrogram[t2]  t3=Table[Evaluate[Sin[0.5*x]*Cos[6*x]],{x,0,xrange,1/20}]; Spectrogram[t3] 

Is there a spell or item that can detect Lycanthropes while they are in their human form?

Since purchasing the Troll Skull Tavern in Waterdeep, Ichabod the Inscrutable has run afoul of the Shard Shunner wererat gang. He believes their leader to be none other than the Fellowship of Innkeeper’s guildmaster, Mister Fairkettle.

Obviously, Ichabod can’t just run to the Watch, some of them are likely on Fairkettle’s payroll! What magical means are available to him that would help him identify and prove who the wererats are?

Ichabod has access to any published, core (non-UA) item or spell that is not an artifact or 9th level.

Is there a spell or item that can detect Lycanthropes while they are in their human form?


This question is purely hypothetical. Any resemblance to characters, living or dead, actual or fictional, is purely coincidental and is in no way intended to be a spoiler.

Detect collisions for each instantiated objects

I want to instantiate cube at a random position when I click mouse and do something (change color or freeze position ..) for each cube when detect collision on the plane.

I tried first few steps:

public Rigidbody cube;  void OnCollisionEnter(Collision collision) {     if (collision.gameObject.name == "Plane")     {         //Do somthing for each cube         cube.constraints = RigidbodyConstraints.FreezePositionY;     } }  void Update() {     Vector3 position = new Vector3(Random.Range(-5f, 5f), 8,Random.Range(-5, 5));      if (Input.GetMouseButtonDown(0))     {         Rigidbody clone;         clone = Instantiate(cube,position, Quaternion.identity);     } } 

Does Detect Magic make an Arcane Mark placed on an invisible surface glow?

Invisible arcane marks glow when hit by Detect Magic.

Usually, how this works is that someone casts Detect Magic on an item and they see this fluorescent drawing on it, marking it as the belonging of some specific mage.

This time, however, we have a creature that likes turning invisible every time it hears our magus cast True Strike or every time too many people swarm them, and the magus would like to slap an arcane mark on their back so that, when the creature goes invisible, a round 1 Detect Magic causes the glow, marking the square and letting everyone but the Detect Magic caster target the right square.

Does this work?

Is a Wild Shaped druid effectively immune to the Detect Thoughts spell?

For standard usage of the Detect Thoughts spell,

"If the creature you choose has an Intelligence of 3 or lower or doesn’t speak any language, the creature is unaffected" (PHB, pg 231).

Additionally one may use the Detect Thoughts spell to detect the presence of creatures they can’t see, however

"You can’t detect a creature with an Intelligence of 3 or lower or one that doesn’t speak any language" (231).

The description for Wild Shape states,

"your ability to speak or take any action that requires hands is limited to the capabilities of your beast form" (67).

Apart from the crow, no non-awakened beast has the ability to speak (the crow specifically has the Mimicry abilty and notably has no languages listed on its stat block).

So it begs the question, can a Wild Shaped druid be affected by the Detect Thoughts spell?

Going one step further, would a druid with the ability to speak telepathically while Wild Shaped be affected any differently by the spell?

Related questions:

  • Does the Detect Thoughts spell work against an Intellect Devourer?
  • In what ways can a druid’s Wild Shape be detected?
  • Can a druid speak while in wild-shape?
  • Can I Wild Shape or Polymorph into an Awakened Beast?

This question was inspired by the Telepathic feat from Tasha’s Cauldron of Everything.

(Pathfinder) Detect vs Seeing (Wording)

Question: If a creature is in the etheral plane and can lower the hit chance from 50% to 20% If you can detect It. Would the effect apply or you need to see it?

Spell in question is Bink

Abilities confusion

Spirit Sensing Stance: By sensing the different patterns all beings that exist have, the senses of the Veiled Moon disciple exceed that of natural beings and move into the realm of supernatural awareness. While in this stance, the initiators gains the scent special ability and he may detect creatures on the Ethereal plane that are near the Material plane within 30-ft. of his position.

See Invisibility: You can see any objects or beings that are invisible within your range of vision, as well as any that are ethereal, as if they were normally visible. Such creatures are visible to you as translucent shapes, allowing you easily to discern the difference between visible, invisible, and ethereal creatures.

The spell does not reveal the method used to obtain invisibility. It does not reveal illusions or enable you to see through opaque objects. It does not reveal creatures who are simply hiding, concealed, or otherwise hard to see.

See invisibility can be made permanent with a permanency spell.

Blink: You “blink” quickly back and forth between the Material Plane and the Ethereal Plane and look as though you’re winking in and out of reality at random. Blink has several effects, as follows.

Physical attacks against you have a 50% miss chance, and the Blind-Fight feat doesn’t help opponents, since you’re ethereal and not merely invisible. If the attack is capable of striking ethereal creatures, the miss chance is only 20% (for concealment).

If the attacker can see invisible creatures, the miss chance is also only 20%. (For an attacker who can both see and strike ethereal creatures, there is no miss chance.) Likewise, your own attacks have a 20% miss chance, since you sometimes go ethereal just as you are about to strike.

How does the Detect Magic spell see any creature that knows at least one cantrip? [duplicate]

The detect magic spell states (emphasis mine):

you sense the presence of magic within 30 feet of you. If you sense magic in this way, you can use your action to see a faint aura around any visible creature or object in the area that bears magic

And the definition of a cantrip in the PH is (emphasis mine):

A cantrip i s a spell that can be cast at will […]. Repeated practice has fixed the spell in the caster’s mind and infused the caster with the magic needed to produce the effect over and over.

Is a visible creature that knows and can cast at least one cantrip detected as "bearing magic" by the spell detect magic?