Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?
Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account or SQL Agent Job Owner ? Normally, We think its SQL Agent Service account user under which SQL jobs runs. But it’s not true in all cases, It depend on your Job owner permissions. If … Continue reading
The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB but whenever user try to run SQL Agent job, it get below error message. We have Checked that SQL Agent job related DB role is properly given to user. Also, Job is working fine … Continue reading
How to move file through FTP by CMD ?
CMD code to upload file direct into root of FTP site of server @ echo off REM ******** this batch file is to upload file echo user username> ftpcmd.dat echo password>> ftpcmd.dat echo bin>> ftpcmd.dat echo lcd D:\Filelocation>>ftpcmd.dat echo put filename.csv>> ftpcmd.dat echo quit>> ftpcmd.dat ftp -n -s:ftpcmd.dat 172.xx.xx.xxx del ftpcmd.dat CMD code to upload … Continue reading
What happen, If SQL Server new instance try to use exitsing named instance name?
We all know that SQL Server can have 1 default instance & many named instance. But I want to check, How SQL Server Setup behave, If I tries to use instance name that is already being used by some existing SQL server on my system. I am already having 2 instances running on my system, … Continue reading
