MSSEARCH for SQL 7

I need to install this and don't seem to have the second disc of the two
disc SQL 7 set.
Is that something I can download somewhere, or will I have to order another
disc set?Chad,
Pretty much sure that you cannot download it free.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"CB" <chadb@.dentistryonline.com> wrote in message
news:ux57wRUOEHA.2480@.tk2msftngp13.phx.gbl...
> I need to install this and don't seem to have the second disc of the two
> disc SQL 7 set.
> Is that something I can download somewhere, or will I have to order
another
> disc set?
>

MSSEARCH for SQL 7

I need to install this and don't seem to have the second disc of the two
disc SQL 7 set.
Is that something I can download somewhere, or will I have to order another
disc set?
Chad,
Pretty much sure that you cannot download it free.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"CB" <chadb@.dentistryonline.com> wrote in message
news:ux57wRUOEHA.2480@.tk2msftngp13.phx.gbl...
> I need to install this and don't seem to have the second disc of the two
> disc SQL 7 set.
> Is that something I can download somewhere, or will I have to order
another
> disc set?
>

MSSEARCH for SQL 7

I need to install this and don't seem to have the second disc of the two
disc SQL 7 set.
Is that something I can download somewhere, or will I have to order another
disc set?Chad,
Pretty much sure that you cannot download it free.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"CB" <chadb@.dentistryonline.com> wrote in message
news:ux57wRUOEHA.2480@.tk2msftngp13.phx.gbl...
> I need to install this and don't seem to have the second disc of the two
> disc SQL 7 set.
> Is that something I can download somewhere, or will I have to order
another
> disc set?
>

MSDTC Resource on Win2003 cluster

I am having trouble to fail over MSDTC Resource group to a second node in a two node cluster. It is running fine on the first node but refuse to start on the second node.
Any help will be greatly appreciated.
Yuhong
yuhong.huo@.yale.edu
I found the solution. Just want post it here in case anybody run into the same problem.
I took the MSDTC Cluster Group offline on the first node and ran msdtc.exe -resetlog command on the second node. And it worked. See article: http://support.microsoft.com/?kbid=243204
Yuhong
|||You may want to check kb article..
http://support.microsoft.com/default...b;EN-US;248025
Van Thothathri
Windows Clustering
High Availability Microsoft Enterprise Server Products
"This posting is provided "AS IS" with no warranties, and confers no
rights."
Use of included script samples, if any, are subject to the terms specified
at http://www.microsoft.com/info/cpyright.htm
"Yuhong Huo" <anonymous@.discussions.microsoft.com> wrote in message
news:EEA345EC-A673-48A9-8E61-2580049D5F14@.microsoft.com...
>I am having trouble to fail over MSDTC Resource group to a second node in a
>two node cluster. It is running fine on the first node but refuse to start
>on the second node.
> Any help will be greatly appreciated.
> Yuhong
> yuhong.huo@.yale.edu

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