You can try this solution :

Create a Wrapper.sql with a Transaction defined in it, and within that transaction use :r to call other scripts. Here is an example:

--Wrapper.sql

:On Error Exit

SET...

Without installing the Exchange Server, and without having any access to my corporate Exchange Server, from where can i get these two files easily ? Since these are just two...

What Parameters should I be checking ?

THanks,

One other thing I found is... all the Files are created on a SAN drive. Could this be a cause of the Problem ?

Thanks,

This might sound a bit silly, but on which Server should I set up monitoring ? Server A... or Servers B, C , D ? At some other time, it...

There are multiple ways to find out if SQL Server is configured to use TCP/IP. In SQL2005, you can use Configuration Manager-> SQL Network Configuration->Client Protocols ->TCP/IP ( Enabled /...

I have installed this hotfix on other Production Servers successfully, and I am member of a group which in turn is part of Administrators on this Server. So, I don't...

Thank You.

Amit.

Thank You.

Hi,

Thanks for the reply.

Do i need to detach the database ? The prb is the SQL 2000 database machine is no longer available to me. I only have the mdf/ldf...

The file is on my local machine - the server is also on my local machine.

Thanks.

With this file :

8.0

2

1 SQLCHAR 2 20 "\t" 1 SerialNumber ""

2 SQLCHAR 2 50 "\t\n" 2 Comments ""

and this command :

exec master..xp_cmdshell 'bcp "TKD01.dbo.online_batch14" in "C:\Amit\Online\batch14\online_test_batch14.txt" -f"C:\Amit\Online\Online.fmt" -U"sa" -P""'

I get this output :

output                                                                                                                                                                                                                                                          ---------------------------------

NULL

Starting copy...

NULL

0 rows copied.

Network packet size (bytes): 4096

Clock Time (ms.): total       ...

bcp version is 8.00.194

Thanks.

I am on SQL SERVER 2000

Thanks.

Thanks Mark. I would be working on this migration project ( from DB2 to SQL Server ) sometime very soon. So, your advice should definitely help me with that.