http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/3731.aspxMon, 07 Jan 2008 12:49:04 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3731xmldeveloper0http://sqlserver.ro/forums/thread/3731.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3731<P>Daca rulati pe 2005 poate nu este enabled xp_cmdshell.</P> <P>Verificati Surface Area Configuration.</P>http://sqlserver.ro/forums/thread/3730.aspxMon, 07 Jan 2008 10:52:02 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3730Diana0http://sqlserver.ro/forums/thread/3730.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3730<P>&nbsp;<FONT face="Verdana, Arial, Helvetica, sans-serif" size=-1><FONT face="Verdana, Arial, Helvetica, sans-serif" size=-1>Pe ce versiune de SQL&nbsp;server lucrezi? Exista un mesaj de eroare legat de problema ta in logurile de SQL, in Event Viewer, etc...?</FONT></FONT>&nbsp;</P>http://sqlserver.ro/forums/thread/3729.aspxMon, 07 Jan 2008 10:17:52 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3729noface0http://sqlserver.ro/forums/thread/3729.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3729<P>salut</P> <P>am urmatorul query:</P> <P>declare @sql varchar(8000)<BR>select @sql = 'bcp "select data from dsq..extract"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; queryout c:\bcp\1.txt -c -T'<BR>exec master..xp_cmdshell @sql</P> <P>problema e ca nu vrea sa imi scrie in fisier de nici o forma la executia din procedura. daca rulez bcp-ul de mai sus direct in linie de comanda merge impecabil...</P> <P>mersi</P>