it's true. But command xp_____cmdShell is very strong . xp___cmdshell is invoked by a user who is a member of the sysadmin . I am only dbo.
but I cant use xp_____cmdShell. Only this user can run dts . Am I right ?
I can't use command xp____cmdShell ..
Hi, I asked about some tips about this problem. But now it's same. But I haven't admin rights. I want to import some text file but into sql table...
Now it's ok, thanks, lubo
btW ... I HAVE INSTALL sql server on more pc as local. This code is correct on other pc . It is wrong on my pc. Both are version SQL Server 2000.
PART II SELECT * FROM OPENQUERY(ExcelLink, 'select * from [test$]') GO but here is an error , test.xls has sheet names Test
i must write my mesage to more windows. I don' know where is proble but i can't write long here msg PART I -execute sp_dropserver 'ExcelLink' EXEC...
HI, I tried such code --Here we set up the linked server using the JET provider EXEC sp_addlinkedserver N'ExcelLink', @srvproduct = N'',...
Hi, help me please with this .. I am using statement for importing xls file -> sql server tables in stored procedure. Sql server is 2000 . Sample :...
So , my SQL run on server not on PC. And drive D is drivo on local pc. Now I understood - it's a problem .
I am working with MS Sql server 2000. In stored procedure I need to find out if some specific folder exist on drive .
Luis , When I replace name of folder (now is name foto) (sample ) declare @cesta as varchar(255) set @cesta='dir D:foto' drop table testDir create...
REsult is 1 The system cannot find the file specified. 2 NULL But D:Tmp is exist . BTW - name of xp__procedure what i call is xp__cmdShell ( in...
Part II EXEC Master..xp_____cmdShell @cesta
Part I declare @cesta as varchar(255) set @cesta='dir D:Tmp' create table testDir (output varchar(255)) insert testDir
I want to subscribe here more about it . But i get back error always when i press SUBMIT REPLY.
Yes , but result is same.
Thnaks for answer . Dineshasanka - when i set set @File ='d: mp' OR 'd: mpX' set @Switch =0 Drive d: ... is existing Directory 'd: mp' ... is...
First , best wishes in this year. Help me please .. How can I find out if some folder on pc is exist ? Thanks , Lubo
Separate names with a comma.
