Tagged questions

15 results found

Problem scheduling data copy from netware shareAugust 16, 2011

Hey, I've got a problem. I have a novell file server and a NT4 workstation SP6a. I want the workstation to copy data from the novell server every hour or so. The novell administrator made a share

46

views

0

votes

7

answers

grant permission on xp_cmdshellAugust 16, 2011

Hi, EE experts, I run into "permission denied on object xp_cmdshell, database master, owner dbo." problem on my following code. With cmd         Set .ActiveConnection = c

41

views

0

votes

2

answers

XP_CMDSHELL executes successfully on SQL 2000 but fails on MSDE 2000 for Sharepoint DBAugust 16, 2011

We have two instances of SQL one being SQL 2000 server and one being MSDE 2000 as installed with sharepoint. Both instances services are set to run using a domain account. We are trying to get the XP_

53

views

0

votes

9

answers

How to write an output file from within a stored procedure or triggerAugust 16, 2011

Greetings: I have a 'requirement' which is to update a directory on a system by writing out a file upon a certain event - namely - a table in the database gets a new insert or is updated. &#16

34

views

0

votes

4

answers

Execute dinied on xp_cmdshellAugust 17, 2011

I have made a trigger in sql2005 that calls a webservice using xp_cmdshell. The webservice is made in php. When i use the terminal server (windows 2003) to fire the trigger it works as intended, but w

52

views

0

votes

9

answers

xp_cmdshell does not execute for non-sysadmin account even though proxy account has been setupAugust 17, 2011

Hi all, i hope you can help me. Basically a dts package has been setup that pulls in data from another companies server, this data requires to be on-demand i.e individual users can pull in updates of

37

views

0

votes

16

answers

Writing to a text file from MSSQL stored procedureAugust 17, 2011

I am looking for a way to create a text file and populate it with multiple lines of information. I would like to declare a variable and manipulate this and then add to a text file - looping through se

38

views

0

votes

2

answers

xp_cmdshell , ECHO and '|' charactersAugust 17, 2011

I am trying to ECHO data to a file. works:     Select @FileString  = 'abc,cde,fgh'     SELECT @EchoString = 'echo ' + @FileString + ' > ' + @FileNam

39

views

0

votes

15

answers

Error using xp_cmdshell in SQL2005 triggerAugust 18, 2011

I have a trigger on a table in a SQL 2005 database. The trigger runs after updating the table. Basically, it grabs a field value from the table and makes a command shell call to a .Net executable on t

58

views

0

votes

6

answers

XP_CMDSHELL Access is DeniedAugust 18, 2011

Does someone know the article(s) that can explain why I might be getting the Access Is Denied when I try to run the following: DECLARE @DOScmd varchar(150)       SET @DOS

67

views

0

votes

3

answers