Viewing 9 posts - 1 through 9 (of 9 total)
Thanks for the response, Harold.
In my case, I don't have the opportunity to change the target of Client Components, which requires 1.4 GB. The options on the "Change Folder"...
November 10, 2005 at 9:14 am
You can run DTS jobs from a command prompt or in a batch job.
The basic syntax is "dtsrun /S /E /N"
The /E switch tells DTS to run under a...
October 6, 2005 at 3:44 pm
1) Display SQL Server state did not seem to make a difference
2) I want to withold final judgement, but initial results suggest that setting the "Always prompt for login name...
October 6, 2005 at 2:41 pm
Actually, I found the problem. I needed to add the -S switch as below.
BCP "SELECT * FROM ##temp_ftp_bat" queryout "C:\FTP_Test\ftp_script.txt" -S databaseserver -T -c'
Thanks for the reply.
December 20, 2004 at 10:23 am
Sorry, I don't have an answer but I'm experiencing the exact same problem with a cluster environment.
Did you ever find a solution?
December 20, 2004 at 9:06 am
Thanks for all the feedback guys. I've opted to not install the second instance of SQL Server and to use a 3rd party application to encrypt and compare my...
August 11, 2004 at 7:52 am
Surprise! The column name is unique within tables in the database but is referenced by numerous Views.
Thanks for the assist, smv929, it worked perfectly.
UR
April 29, 2004 at 6:35 am
Not a dumb question at all.
I think that it was ultimately a permissions issue, although I'm not sure why, because the owner of the job was a login with administrative...
March 5, 2004 at 6:45 am
Have you given any thought to Transactional Replication?
September 11, 2003 at 1:51 pm
Viewing 9 posts - 1 through 9 (of 9 total)