And after changing my search terms in Google to "SQL Server get job name from sp_who2 program_name" instead of something more generic, I HAVE FOUND IT!

CONVERT(VARCHAR(34),master.dbo.fn_VarbinToHexStr(sj.Job_ID))

This function converts jobID to...

Oh, nevermind. I think I found it. WHERE sys.objects.object_id > 0 AND sys.objects.object_id < 1042102753.

Let me know if anyone knows of any other method.

EDIT: Hrm. Nope. Not quite the solution...

• This reply was modified 11 months ago by Brandie Tarvin.

Following up on this... Will it hurt if I remove system object permissions from the public role?

Or, alternatively, is there a method to ensure that I only remove user objects...

No, it was definately object-level permissions on the public role. I revoked them and my regular account no longer could see the database data.

I'm assuming that it only showed for dbo because it was in public. Because it didn't show for dbo on other databases.

The script I should have used is below:

            
October 1, 2024 at 8:03 pm
            
#4464324

            
            
                                                
        

Oh, good grief. My check on public securables finally loaded (I had turned away from it and forgotten to close it after taking that screenshot). Apparently it is public, not...

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 1 year, 1 month 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 1 year, 1 month ago by Brandie Tarvin.