By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 2,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

Is it possible to run SQL-Cursor through cmd??

P: 41
Hi
Is it possible to run SQL-Cursor through command prompt??
if yes how?? plz help me.
Jun 16 '08 #1
Share this Question
Share on Google+
4 Replies


ck9663
Expert 2.5K+
P: 2,878
What are you trying to do?

-- CK
Jun 19 '08 #2

P: 41
What are you trying to do?

-- CK
i want to run cursor through schedular.
Jun 20 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Create it in stored proc.

Use OSQL to execute it.

-- CK
Jun 21 '08 #4

Delerna
Expert 100+
P: 1,134
OR
create in a stored proc
create a DTS to run it
create and schedule a job in "management/SQL Server Agent/Jobs"
(The context menu of the DTS has an option to schedule the DTS)

ALSO
vb scripts can be scheduled
vbscripts can also execute stored procs on SQL Server

:)
Jun 22 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.