I can able to grant user who is non sysadmin  to linked server by granting  rights to user on SYS.XP_PROP_OLEDB_PROVIDER. However, the caveat is it allows user to access...

I remember this one vaguely - it was a bug in SQL Agent. There were fixes people posted to change the refresh setting in the registry but Microsoft had a...

I've done a few of those changes, sometimes it's not too fun. The -q switch seems like it works most of the time but not all of the time. Undocumented...

This is a SQL Server forum but...Add a semicolon at the end of the closing parenthesis from the create table -

CREATE TABLE people (

id INT,

name VARCHAR(255),

PRIMARY KEY(id)

);

INSERT...

Just an FYI....I've seen similar things with subreports and the rectangle trick usually works. I had one that didn't, don't really remember the details of the report other than I...

You may want to look at the DMV sys.dm_db_tuning_recommendations which was added in SQL Server 2017 and see if you can throw together what you need using that DMV. When...

I'm still not sure what the views accesses. If you have an error with msdb, I was wondering if you have objects in those views that access other databases but...

If the views are accessing objects in another database, I would guess you are running into issues with ownership chaining across databases. It's something that used to be enabled in...

Your welcome. FYI - This article is a good read on the subject and getting into that problem I mentioned with shrink, defrag, shrink, etc:

Shrinking databases and rebuilding indexes...

The two different database platforms work a lot differently. I've seen vacuum compared to shrinkfile, defragging indexes and ghost cleanup. All three are very different and I think you see...

I don't trust my status :)....but the agent process actually runs the jobs so Agent needs to be running. It's a pain but yeah you'll need to run those manually.

Sue

Nothing particular with always on - it will generate a lot of IO, can cause blocking and will result in fragmentation whether in an availability group or not. The secondary...

If Agent isn't running, the jobs won't run. The error tells you that Agent isn't running so it couldn't be told to run the job.

Sue

Good thought as people often overlook the resource database. It's not a database to move though....

I don't believe that specific version is available as a download. You would...