Viewing 3 posts - 1 through 3 (of 3 total)
Open a notepad file..type in the below command
sqlcmd -s -E -Q
pause
save the file as .bat file and just double click on the file..it will run the required commond...for testing initially...
June 26, 2009 at 12:09 am
#1015775
Can you logon to the linked server and check if you have given the user account(under which the job is running) “Connect” rights to the default database on the linked...
June 26, 2009 at 12:03 am
#1015772
Yes, its very much possible using sqlcmd..hopefully you are using SQL 2005 version...
Sample script
sqlcmd -S. -E -Q "select * from sys.objects"
save the above file as .bat and try
June 25, 2009 at 11:37 pm
#1015762