In the ss below you can see that I have a table (dbo.clan.spouses) with a column (spousesID) that has a datatype  of uniqueidentifier.

I assigned that value not knowing the...

Here's the section of the documentation that seems to apply here and it's in the form of step-by-step instructions.  I do NOT know for sure if this will prevent DBAs...

I had to modify the script (added a couple of columns in @FileList and @DbNameHeaders) and added some more logic to suit my needs.

This script works like charm in...

As for not being able to see the column you added in the design view, it sounds like you did all the proper refreshes and so I have to ask,...

This is NOT a problem with code.  It IS a setting in SSMS to prevent casual users from making changes using the Object Explorer.  Unfortunately, it's an instance wide setting...

The error message is...

Msg 8114, Level 16, State 5, Line 12

Error converting data type varchar to numeric.

... and I'm surprised that this doesn't fail in Sybase but I don't...

One of the first things you should do is to download Brent Ozar's first responder kit and run it.

Here's where you can get the kit...

https://www.brentozar.com/first-aid/

Here's where you can learn to...

Heh... it's funny how timely this article is, Grant.

One of the companies that I do a little work for has customers that must be responsible for the following meme...

I'm a retired IT guy in his 80s fighting boredom by trying to learn new things.  SQL is the newest topic.

Am I in the right place or do you...

How to rewrite a query in MS SQL:

WHERE a.ROWID IN (SELECT rid

FROM ( SELECT ROWID rid,

row_number() OVER (PARTITION BY c.id ORDER BY c.id) rn

FROM details c

WHERE a.id = c.id

AND...

The "JOIN" in the second query is in the WHERE clause as...

and (DFR.transaction_header_guid = ICT.transaction_header_guid)

It's also referred to as an "old style" or "Non-SANSI" "Equi-Join"

Jeff Moden called it a Consensus Engine, which I thought was a brilliant description.

It's pretty much at peak hype in the hype cycle.  It is genuinely useful, just not...

For Perplexity.ai, it came so VERY close and, yet, it still failed.  It did write corrected to go after this bit of narrative, though.

It's important to note that the...

+1000!  I've said that it has the "being human" part pretty much down pat.  I very confidently provides the wrong answer...

Yes... that can be done and the methods have been available for quite a while.  The problem is that it's arduous for the server to record information every time a...