Script out of user just gives me this:

/****** Object: User [dbo] Script Date: 10/1/2024 2:31:15 PM ******/

CREATE USER [dbo] FOR LOGIN [sa] WITH DEFAULT_SCHEMA=[dbo]

GO

Using this script is where I see...

OMG, can I scream yet? This is ... somewhat hilarious and painful and scary all at the same time. Object-level permissions on dbo – SQLServerCentral Forums

HELP!

Additional note: If TRUNCATEONLY isn't working, check min file sizes on the tempdb files. They may be larger than they are supposed to be. ALTER the files to resize and...

So there is an alternative if tempdb has "gone wild" and this isn't ordinary growth.

The commands above will help you, as you surmise, but plans will have be recreated and...

My workplace has made sure I am unable to update the ssms.Application. pkgdef file to fix my save locations. Very annoying because none of us can make changes in that...

Probably a good idea.

Anyone else have this problem?

Ant-Green, am I missing something? I'm trying to script to a file. That link shows me how to copy from one server to another.

EDIT: I think what I need is...

• This reply was modified 3 months, 2 weeks ago by  Brandie Tarvin.

I have dbatools installed. I'll look at this information. Thanks.

That article is for SQL 2008. The servers are 2017 and I'm pretty sure SMO code doesn't work anymore in 2017.

EDIT: Even looking at the PowerShell options, it doesn't let...

• This reply was modified 3 months, 2 weeks ago by  Brandie Tarvin.

SMO still works? I thought it got deprecated or removed.

I'll check it out.

And the hits keep coming. Google Chrome, fixed now fortunately.

Passwords disappear for millions of Windows users thanks to Google | Windows Central

It gets better. A few days after the CrowdStrike outage, now THIS is a thing and it's totally Microsoft:

Windows July security updates send PCs into BitLocker recovery (bleepingcomputer.com)

Anyone notice that Microsoft is trying to blame the EU for their 2009 non-compete settlement being the root cause of the CloudStrike issue?

I don't see anything in their connection strings that indicate they're trying to log in as a "user" vs "login" so I still have no idea what the issue is.

They are using a stored procedure at the upper level which references the views, and I'm not sure changing the last view's code to be a proc in the other...