InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:54:51 GMT20http://www.sqlservercentral.com/Forums/Topic1363905-8-1.aspxYou can try OPENROWSET, documented in Books Online.Tue, 25 Sep 2012 08:04:59 GMTlptechhttp://www.sqlservercentral.com/Forums/Topic1363905-8-1.aspxtable is very big:-)Tue, 25 Sep 2012 07:21:09 GMTviveksvkolahttp://www.sqlservercentral.com/Forums/Topic1363905-8-1.aspxunless you consider dbmail creating an attachment as a file for an email, SQL server itself, doesn't have any native ways to write files to disk that I can think of; everything's an application...SQL Server Management Studio itself,, bcp,dts/ssis, CLR methods, powershell, Office like excel/word, custom applicaitons, etc all would count as "applications" in my book.it would be better for you to identify what applications you don't wnat to use instead.what's the real requirement? write data to disk, or not use applications at all? Think it through and let us know what you really need to do.Tue, 25 Sep 2012 05:50:45 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1363905-8-1.aspxDTS is another one to useTue, 25 Sep 2012 05:39:46 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1363905-8-1.aspxYou can use BCPTue, 25 Sep 2012 04:55:34 GMTvyashttp://www.sqlservercentral.com/Forums/Topic1363905-8-1.aspxIf your table is not very big, you could SELECT * FROM Table using 'Results to Text' instead of grid, then copy & paste the output to a text file.:-DTue, 25 Sep 2012 04:52:41 GMTlaurie-789651http://www.sqlservercentral.com/Forums/Topic1363905-8-1.aspxHi,This is vivek, i have one requirement load sql server table data to flat file(text file) with out applications.please any one help to me.Thanks&Regards,vivek.:-)Tue, 25 Sep 2012 04:03:57 GMTviveksvkola