No announcements
Found 2612930 threads
-
0 VotesXp_cmdShell not working with XMLNAMESPACES for xml file export
Does it work ?Unanswered | 5 Replies | 78 Views | Created by Anonymous - Friday, January 4, 2019 10:32 AM | Last reply by Anonymous - Saturday, January 5, 2019 5:24 AM
-
0 Votes
How to export the data to a file (csv) without using xp_cmdshell
I'm sorry, but you just want to export data to a flat file...what's the hangup...Answered | 10 Replies | 5745 Views | Created by wkpli - Thursday, November 3, 2016 2:40 PM | Last reply by ryguy72 - Friday, November 18, 2016 3:12 PM -
2 Votes
xp_cmdshell
xp_cmdshell 'dir \\persqloeout\sql\out\12345.csv' select @fileexistornot as CmdShell_ReturnCode This worked like charm and returns 0 if file exist or 1 if ...Answered | 4 Replies | 4959 Views | Created by Srisaravanan - Wednesday, December 8, 2010 11:46 AM | Last reply by Srisaravanan - Wednesday, December 8, 2010 2:19 PM -
4 Votes
Is it Possible to use XMLNAMESPACES and a CTE at the Same Time?
;with xmlnamespaces(default 'http://www.company.com/messages...')Answered | 8 Replies | 17566 Views | Created by John Saunders - Saturday, July 31, 2010 5:30 AM | Last reply by D Parks - Friday, April 19, 2013 12:27 AM -
1 Votes
problem with xp_cmdshell
I can't know why the file is not where you expect it to be, but a hint: if C: refers to your local disk, and SQL Server runs on a different machine, SQL Server is looking ...Answered | 4 Replies | 8539 Views | Created by Rishabh K - Monday, December 20, 2010 5:31 AM | Last reply by Erland Sommarskog - Tuesday, July 10, 2012 3:01 PM -
0 Votes
Export Data to new Excel File without using XP_CMDSHELL
The Files first have to be created by the query.Answered | 4 Replies | 5395 Views | Created by Vincent-Vega - Thursday, November 6, 2014 6:49 AM | Last reply by Vincent-Vega - Thursday, November 20, 2014 6:22 AM -
0 Votes
export in XML Problem.
Hmm, have you tried a different editor to read the XML file?Answered | 9 Replies | 3479 Views | Created by First Programer - Thursday, December 13, 2012 8:10 AM | Last reply by First Programer - Tuesday, December 18, 2012 4:15 AM -
1 Votes
xp_cmdshell
What do you think the ratio of DBAs is that have actually worked with the Windows folks to limit the privs of the SQL Server Service login or the SQL Agent compared to those ...Answered | 15 Replies | 7425 Views | Created by Jackson_1990 - Thursday, January 13, 2011 2:46 AM | Last reply by Jeff Moden - Friday, May 17, 2013 1:47 PM -
0 Votes
xp_cmdshell to ZIP and rename a file
NULL One thing - If i run this command on the bat file it working.Answered | 3 Replies | 9095 Views | Created by xXShanXx - Tuesday, October 16, 2012 1:51 PM | Last reply by Kalman Toth - Tuesday, October 16, 2012 2:42 PM -
2 Votes
xp_cmdshell is not working in my pc
by running script select * from AdventureWorks.HumanResources.Employee for xml auto,elements by clicking on output xml will open ...Answered | 11 Replies | 4922 Views | Created by kushkrishna - Friday, September 24, 2010 4:24 PM | Last reply by kushkrishna - Friday, September 24, 2010 9:11 PM -
1 Votes
xp_cmdshell
Can I check if xp_cmdshell is enabled or not?Answered | 3 Replies | 1142 Views | Created by biltz - Tuesday, November 11, 2014 7:46 AM | Last reply by Praveen Rayan D'sa - Tuesday, November 11, 2014 9:40 AM -
1 Votes
xp_cmdshell -can't run a .sql file
xp_cmdshell is used in executing the command prompt commands for example you want to get the file names from a directory.Answered | 4 Replies | 3930 Views | Created by Chaithanya Reddy - Monday, November 28, 2011 7:18 AM | Last reply by DVR Prasad - Monday, November 28, 2011 11:40 AM -
1 Votes
EXEC master..xp_cmdshell not working - Cannot load the DLL xpweb70.dll
On the other 2 the xp stored proc was created but I'm not getting files.Answered | 5 Replies | 13962 Views | Created by trendel - Tuesday, May 11, 2010 7:36 PM | Last reply by Vincent Li - Thursday, May 13, 2010 7:23 AM -
0 Votes
how to use xp_cmdshell to write to text file
xp_cmdshell lives the OEM world, so your file gets mangled.Answered | 7 Replies | 37070 Views | Created by ML90 - Wednesday, December 30, 2009 3:46 AM | Last reply by Erland Sommarskog - Thursday, July 22, 2010 9:29 PM -
0 Votes
xp_cmdshell error
I think to fix this you have to give the login that your app uses to access the database, execute permission on xp_cmdshell extended stored procedure ...Answered | 6 Replies | 9798 Views | Created by TerryCarter - Friday, October 8, 2010 3:11 PM | Last reply by TerryCarter - Monday, October 18, 2010 8:45 AM -
0 Votes
How to export multiple table data to XML File?
Hi Latheesh, I optimize it as, Create Table TempDb..Tmp (XML_Data XML) Insert into TempDb..Tmp <Your Sql ...Answered | 8 Replies | 5509 Views | Created by S_Surve - Friday, September 14, 2012 8:31 AM | Last reply by S_Surve - Friday, September 14, 2012 5:42 PM -
0 Votes
Export Site structure to XML file
Please have a look at the class implemented ...Answered | 2 Replies | 8117 Views | Created by _Stefan_ - Wednesday, March 2, 2011 1:29 PM | Last reply by _Stefan_ - Thursday, March 3, 2011 9:05 AM -
0 Votes
Bcp error using xp_cmdshell
Moreover the bcp command works in the command prompt.Answered | 14 Replies | 30333 Views | Created by sir_zql - Thursday, August 23, 2012 5:39 PM | Last reply by Pelser - Tuesday, April 8, 2014 1:06 PM -
1 Votes
Export Values of column to file
Thanks for the reply, right am i working on getting the rights to enable the xp_cmdshell.Answered | 13 Replies | 1805 Views | Created by santelices - Wednesday, October 21, 2015 6:48 PM | Last reply by Visakh16 - Saturday, November 7, 2015 10:45 AM -
0 Votes
EXEC xp_cmdshell
And two years later when you move the database to a new server, you would have forgotten all about it, and wonder why things has stopped working.Answered | 5 Replies | 3339 Views | Created by MVP_88 - Monday, February 23, 2015 4:11 PM | Last reply by Erland Sommarskog - Wednesday, February 25, 2015 11:55 AM - Items 1 to 20 of 2612930 Next ›
No announcements
