Run it as ascript automatically

[makumbi]

Hi members is there a way of saving this script in a specific folder and i write a code to run it from there automatically and if yes how does that code look like.

GO
SET ANSI_WARNINGS OFF
GO
SET ANSI_NULLS ON
GO

insert into testtbl(phone,address,city)
SELECT phone,address,city
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=kabojja6;UID=makumbi;PWD=',
pubs.dbo.authors) AS a
ORDER BY a.au_lname, a.au_fname

 

[bborissov]

You could save it as script file and use sqlcmd to run it in windows scheduler.


Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.