Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: Invoke-Sqlcmd and Transactions

    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...

  • RE: Fastest way to copy backup file from server 1 to server 2

    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...

  • RE: Unable to complete login process due to delay in opening server connection

    What Parameters should I be checking ?

    THanks,

  • RE: Unable to complete login process due to delay in opening server connection

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

    Thanks,

  • RE: Unable to complete login process due to delay in opening server connection

    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...

  • RE: with grant option and TCP/IP

    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 /...

  • RE: Error 29538 while installing Hotfix

    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...

  • RE: Check Named Pipes and TCP/IP on multiple servers

    Thank You.

    Amit.

  • RE: SQL 2000 DB in SQL 2005

    Thank You.

  • RE: SQL 2000 DB in SQL 2005

    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...

  • RE: BULK INSERT Error

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

     

    Thanks.

     

  • RE: BULK INSERT Error

    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       ...

  • RE: BULK INSERT Error

    bcp version is 8.00.194

     

    Thanks.

  • RE: BULK INSERT Error

    I am on SQL SERVER 2000

     

    Thanks.

  • RE: Uploading Pictures in MSSQL 2000

    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.

Viewing 15 posts - 1 through 15 (of 15 total)