I would like to run a couple of SQL statements usually executed via Query Analyzer on a monthly bases, but I would like to create a small VB program so it can be run from the desktop.
I know I can create a Job in SQL and have it on the server, but I want to run via a VB apps.
The instruction I would like to put in VB is simple:
SET column = expression
I don't want the VB program to ask to press a key, I would like to have statements executed when clicking the VB icon from the desktop.
I can connect VB to SQL instance successfully and even relate the table's DataField to VB Fields.
I'm using Visual Basic 6 and SQL 2000 (both with latest SP)