Screenshot is a little hard to read, but I would guess the problem is that the SQL Server Agent user doesn't exist on the database.  Looking at the user, it...

They should just need EXECUTE permissions as far as I am aware.

I would double check that you granted permissions on the correct object in the correct database on the correct...

I created a script that replicates this behavior but I do not have a good "reason" why this behavior exists, just a theory.  Sample script:

DROP TABLE IF...

I would try a repair install of VS2019 or look for updates to VS2019.

It sounds like something may be broken with your VS install (just a guess).

What error are you getting?

Did you install the SSDT (or whatever they are calling it in VS 2019)?  Chances are you are missing the reporting templates for VS2019.  This link has some directions:

https://tomaztsql.wordpress.com/2019/11/03/installing-ssis-ssrs-and-ssas-with-visual-studio-2019/

But the...

If you don't want to create the object on the secondary server first (which is the method I would HIGHLY recommend doing as then you can properly define the datatypes...

Yes, sorry.  My reply was before I realized that this data is already stored inside SQL Server.  I wouldn't bother making a new table for it when a view will...

For fun, I tried running the query you had pasted and it runs fine on my system.

My guess is you copy-pasted that from another site that does some formatting on...

PLEASE DISREGARD THIS POST.  OTHERS REPLYING TO THIS ARE DOING A MUCH BETTER JOB ON THIS THAN THE BELOW ADVICE.

I agree with Jeffrey here - I would create a table...

• This reply was modified 4 years, 8 months ago by Mr. Brian Gale. Reason: disregard this post

I agree with ratbak here. You need some way that SQL can order the data that makes logical sense.

One HUGE problem with using the names of numbers is that it...

I would like to add to what Eric said.

I think your test case is flawed.  You are not simply testing if having the LDF and MDF on different disks is...

Ours fall into ZZartin's bucket too - if the new bug is low impact or low probability of reproduction or low risk, we tend to not roll back.  If the...

Since it is a JOIN, if that JOIN is on the PK/FK column, it may be already indexed.  If it isn't, you MAY get a boost by indexing on that...

If you want a single, minimum value returned, don't group the data.