InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 23:52:39 GMT20http://www.sqlservercentral.com/Forums/Topic1108871-111-1.aspxYou could use a WINDOWS scheduled task calling a bcp out command with a trusted connection.Regarding details for bcp please see BOL (BooksOnLine, the SQL Server help syste usually installed together with SQL Server).Another option would be using a SQL Server job and xp_cmdshell but that should require additiona lsteps to avoid making xp_cmdshell available for every user (which would open a security hole of unknown depth).A third solution would be a SSIS package called.I, personally, would use either the first or the second option.Sun, 15 May 2011 05:31:12 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1108871-111-1.aspxI want to create a Job scheduler in SQL Server 2008 that should be create a log in text file and stored in some other drive automatically. So for that I think I must need some script. So may be you can give me the right suggestion to resolve my issue. Thanks.:discuss:Sun, 15 May 2011 01:22:07 GMTgyani