Viewing 3 posts - 1 through 4 (of 4 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
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
Yes, its very much possible using sqlcmd..hopefully you are using SQL 2005 version...
Sample script
sqlcmd -S. -E -Q "select * from sys.objects"
pause
save the above file as .bat and try
June 25, 2009 at 11:37 pm
Viewing 3 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy