August 17, 2006 at 12:00 pm
I need help in creating a script for updating two tables called "table1" & "table2" from database1 to an identical database1 on other server in SQL 2000. The user wants an icon created on his desktop, so that he can run the script whenever he wants to update those tables.
Any help would be greatly appreciated.
Thanks,
MK
August 17, 2006 at 9:34 pm
Hmmmm I suppose you could have a stored procedure that does the update, then VB script or something to execute the stored proc
August 18, 2006 at 8:06 am
Homebrew01,
As I'm a newbee, I would appreciate if you can give more details to achieve this. -- Thanks
August 18, 2006 at 9:16 am
I might be able to help with the SQL script if I had more details of what you actually want to do. I'm not the person to ask about VB. There may be a better way for a user to execute a SP. If you don't get any good responses here, maybe try posting in another forum for ideas about a user running a SP from outside SQL.
August 18, 2006 at 9:31 am
SQL Server has command line support. You could probably create a batch file that executes the stored procedure (or DTS package), and put a shortcut to that batch file on his/her desktop.
Unless these tables are very small, I would sugest you save this in a DTS package and schedule it there rather than letting someone potentially bang your server with updates all day long.
The Redneck DBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply