Search results for query: *

I believe so, The DTS will execute fine without the scheduler. We connecting as 'sa' to schedule the job. Thanks,

The DTS package deletes all rows from 2 tables. Then, copies all records from 2 other tables that are refreshed into the 2 original tables. Delete all rows from Table A Table B Insert all records: Table A1 into Table A Table B1 into Table B If we execute the DTS by itself , it runs...

Scheduled a DTS package (SQL 2000) to run nightly. When the DTS package starts it errors out immediately. If we move the same DTS package to a different server and schedule it the Job runs successfully. I am recieving an error message: Executed as user: SQLSERVER\SYSTEM. The process could not...

I am trying to create an install package for a VB6 application that runs CR10 reports. I have used the Package and deploy within VB6 without any success. I have also tried to use Visual Studio Installer. The VB portion installs correctly but the Crystal does not. I am installing on a Citrix...

When viewing the contents of a directory using the ls -l command the owner and group name are shown as id's (numbers) not the user name. If the command is done as root the names display correctly. Also when logging on the system users receive disk quota messages. It was working fine previously...

Thanks Garths2, The code is working great as far as I can tell.

Thanks for the response and suggestion. I will try to be more detailed next time. The initial code gave me the error: -2147217900. Unclosed Quotation mark before the Character string '?'. My table has 3 fields. Char(20), Char(1), Image. I am not sure how the image is stored. It is not...

I am having Trouble coping an image type datafield from on table to another. I am using the following code but receive and error on the insert. I am user SQL Server 2000. Any suggestions would be greatly appreciated. Thanks copysrccmd.CommandText = "SELECT * FROM tbl1 where fld1 = '" &...

I have connected to an access database and I would like to contruct an update statement into another database. Without specifing the specific fields, I would like to user the fields attribute to get the name of the field (rec.fields(0).name) and the value (rec.fields(0)). My question is, How...

The user running the Procedure is not sa. But they do have execute rights on the xp_CMDShell SP. Can it only be run by a sa user? Sorry, what is BOL? Thanks

I am trying to run the following command from T-SQL and received an error. Can anyone tell me what this error means? EXEC master..xp_cmdshell 'dtsrun /S SERVERNAME /N PKGNAME' Error: Msg 50001, Level 1, State 50001 xpsql.cpp: Error 87 from GetProxyAccount on line 604 Thanks