What are the correct Active Directory priviledges that should be applied to
the service account that runs the MSDTC?
Thanks,NT AUTHORITY\NetworkService
is the correct startup account.
There are no specific Active Directory settings needed.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Showing posts with label directory. Show all posts
Showing posts with label directory. Show all posts
Wednesday, March 7, 2012
Monday, February 20, 2012
MS-DOS COPY problem
Hi,
I want to create a batch file which copies existing files in one directory to another directory(actually sub-directories in the second directory) based on the dates they were created using MS-DOS command.
Example:
File A created on Jan-10-03
File B created on Dec-12-97
File A & B are in C:/ drive and when I run the batch file the File A should be copied to d:/Jan & File B should be copied to D:/Dec
Please let me know!
Thanks.Use xp_cmdshell ...|||Could you please elaborate...I am kind of new to the IT field.
Thank you.
Originally posted by snail
Use xp_cmdshell ...|||xp_cmdshell allows you to issue commands to the operating system just as if you were at a DOS prompt. xp_cmdshell must be called from the Master database. Look it up in Books Online for syntax and details.
blindman|||Doing this with CMD commands is going to be tuff. For this type of work I would suggest a scripting language like PERL, PYTHON or even good old qbasic! Of course you could do this with TSQL but this is not always the best solution for system scripting. Knowing one of the above languages will make short work of this kind of task.|||Hi,
another possibility would be an ActiveXScript in a DTS package. For information about working with files in DTS refer to http://www.sqldts.com/default.aspx?292
Bye,
Carsten
I want to create a batch file which copies existing files in one directory to another directory(actually sub-directories in the second directory) based on the dates they were created using MS-DOS command.
Example:
File A created on Jan-10-03
File B created on Dec-12-97
File A & B are in C:/ drive and when I run the batch file the File A should be copied to d:/Jan & File B should be copied to D:/Dec
Please let me know!
Thanks.Use xp_cmdshell ...|||Could you please elaborate...I am kind of new to the IT field.
Thank you.
Originally posted by snail
Use xp_cmdshell ...|||xp_cmdshell allows you to issue commands to the operating system just as if you were at a DOS prompt. xp_cmdshell must be called from the Master database. Look it up in Books Online for syntax and details.
blindman|||Doing this with CMD commands is going to be tuff. For this type of work I would suggest a scripting language like PERL, PYTHON or even good old qbasic! Of course you could do this with TSQL but this is not always the best solution for system scripting. Knowing one of the above languages will make short work of this kind of task.|||Hi,
another possibility would be an ActiveXScript in a DTS package. For information about working with files in DTS refer to http://www.sqldts.com/default.aspx?292
Bye,
Carsten
Subscribe to:
Posts (Atom)