Forum Replies Created

Viewing 10 posts - 31 through 40 (of 40 total)

  • RE: How to setup linked server?

    Hi Sameer,

    I am getting following error:

    OLE DB provider "SQLNCLI" for linked server "XXXXX" returned message "Communication link failure". Msg 10054, Level 16, State 1, Line 0 TCP...

    April 27, 2006 at 4:16 pm

    #634718

  • RE: Connect local MS SQL 2005 Enterprise on Windows XP Professional

    Hi,

    Thanks for trying to help. I had installed MS SQL 2005 Enterprise on my Windows XP Professional laptop. I am able to connect to other remote servers. However, I could...

    March 6, 2006 at 9:15 am

    #624947

  • RE: openquery

    I tried to re-use exisiting stored procedure which does all linking process. However, the exisiting sp does drop, drop login, re-link, and finally trying add a record into linked server's tmp...

    December 14, 2005 at 5:18 pm

    #609619

  • RE: Linked Server

    Thanks for the tip..

    December 13, 2005 at 4:34 pm

    #609345

  • RE: Northwind or pubs

    Hi Markus,

    Thanks for the extra tip. Happy hoiday!

    Chris

    November 23, 2005 at 11:04 pm

    #605619

  • RE: Northwind or pubs

    Thanks guys. I did attach both Pubs and Northwind into SQL 2005.

    Chris

    November 22, 2005 at 9:43 am

    #605276

  • RE: Add column to table in stored procedure

    Hi,

    I believe I resolve the problem. SQL Server expects all columns (as well as other objects) exist when the sp gets compiled. Compiling error due to the columns don't exists...

    July 22, 2005 at 11:21 am

    #576518

  • RE: Add column to table in stored procedure

    Thanks for help.

    The table:

    CREATE TABLE SOP_stgDataConversionBudgetRevenueSellIn (

           Column1       varchar(18)   NULL,

           Column2              varchar(40)   NULL,

           Column3  smallint      NULL,

           Column4        varchar(5)    NULL,

           Column5               decimal(17,3) NULL,

           Column6              money         NULL

    )

    go

    Part...

    July 22, 2005 at 10:04 am

    #576484

  • RE: BCP problem

    Hi Phill,

    It must have a reason in order to work. So if I understand correctly, it works because -t and -r/n are part of default. But why it didn't work when...

    July 11, 2005 at 6:11 pm

    #573181

  • RE: BCP problem

    H David,

    Thanks for the help. I tried:

    bcp DATABASENAME.dbo.TABLENAME out XXXX.txt -c -t\t -r\n -S %SqlServer% -T || SET ErrMsg=BCP out of XXXX failed. && Goto :EndErr

    July 11, 2005 at 4:11 pm

    #573162

Viewing 10 posts - 31 through 40 (of 40 total)