InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 00:21:35 GMT20http://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxWhy not use an SSIS package to generate the file?Thu, 03 Mar 2011 06:05:49 GMTSteve-3_5_7_9http://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxA little more information would be nice as to what the big picture of this is... Is the parameter some data that needs to be retrieved from SQL? I could whip out a VBS script to hit the DB, grab the value, and pump it into the script. Powershell possibly?Wed, 02 Mar 2011 10:31:46 GMTMad Mychehttp://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxThe file will be created from the context of the sql server, so you should be able to write it to any drive or share the sql server has access to.Wed, 02 Mar 2011 10:17:51 GMTZZartinhttp://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxHi, Here the txt file will be created in server. Is it possible to create a file in local machine?Wed, 02 Mar 2011 09:39:09 GMTRamGhttp://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxYou can use sp_OACreate to access the the File System Object (Active X)[url=http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/]reading & writing files in sql server[/url]Fri, 08 Oct 2010 08:57:49 GMTMad Mychehttp://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxIs there any other way to create store procedureThu, 07 Oct 2010 03:52:25 GMTjain.ashish309http://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxI can't believe this is the slickest way to achieve what you're after, but this works :w00t:[font="Arial Black"]CREATE PROCEDURE EXPORT_DATA@FileName varchar(255)asbegin declare @bcpCommand varchar(255), @Result int set @bcpCommand = 'bcp "Select 1 as a" queryout "' + @FileName + '" -c -t, -T -S ' exec @Result = master..xp_cmdshell @bcpCommand, no_outputend[/font]Don't forget that xp_cmdshell is not enabled in the db configuration by defaultMike.Fri, 09 Jul 2010 04:12:44 GMTMike Seddonhttp://www.sqlservercentral.com/Forums/Topic907575-146-1.aspxHi, I need to create a stored procedure that accepts a parameter, this paramentes is a name. When i pass the name to the stored procedure, this procedure creates a empty txt file with the name that i passed as the parameter.Is it possible to do this using t-sql?Thank youWed, 21 Apr 2010 03:37:35 GMTriver1