Thank you Ant-Green! I got totally hung up on the Windows login vs SQL Login and didn't think I could change it with that alter command. That worked. For anyone...

• This reply was modified 1 year, 11 months ago by  scribesjeff.

I ran into this issue on SQL 2016 when we installed a QA box and took the default NT service\MSSQLServer account to start the SQL server service. Then we tried...

Hi,

The answer is ......Its the certificate. I had a new one made and didn't use and FQDN in any of the fields. and now it auto populates with...

Hi,

Thanks for the replies. Brandie its not so much querying the data that is the issue. I typically just give them access to views that have all the...

HI Rob,

Its a warehouse datamart setup. And yes they do the excel thing to me as well. Its health care and there are 25000+ employees. A lot of...

Hi Lynn

Well that certainly worked a lot better! Thank you so much! It returns the code all on one row.

Regards,

Jeff

Thanks Kevin very useful.

I found this link quite helpful as well.

https://www.simple-talk.com/sql/learn-sql-server/resource-governor/

Regards,

Jeff

Thanks That fixed it

THANKS LYNN! I missed the quotes 8-(

Works good now.

Hi Lynn,

Thanks for the reply but when you are getting data that is stored as an int and you are trying to case it as a char that will error...

Thanks everyone I appreciate the help. I was able to link it back to a date table with proper datetime fields and do my datediff with that. The cast and...

Hi,

Thanks for pointing me to the view. Here's the solution if anyone is looking for it.

UPDATE sysjobsteps

SET command = '/SQL "PATH TO PACKAGE" /SERVER NEW_SERVERNAME /MAXCONCURRENT " -1 " /CHECKPOINTING...