Linked Servers

Technical Article

RE: QOD 17th Nov

  • Reply

"This is a poor question" OK, well, thanks for the skewer. I'll think twice about posting a question from now on. ;-/ I represented it as I found it, did look in BOL, and did not find anything to contradict the author's comment. I have experimented with it as a feature, and have found that […]

You rated this post out of 5. Change rating

2003-11-17

1 reads

Technical Article

RE: Index for column with a lot of Null

  • Reply

CREATE TABLE [dbo].[CheckQueue] ( [CheckQueueKey] [int] IDENTITY (1, 1) NOT NULL , [AppUser] [int] NULL , [CmdCodeKey] [smallint] NOT NULL , [CustomerKey] [int] NULL , [RequestDate] [datetime] NOT NULL , [ResponseDate] [datetime] NULL , [CheckQueueCodeKey] [smallint] NULL , [WebCustomerKey] [int] NULL , [ProductKey] [smallint] NULL , [PIN] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [SerialNbr] [varchar] […]

You rated this post out of 5. Change rating

2003-08-28

Technical Article

RE: BCP Utility

  • Reply

Hi Phill, Yes, I did try creating and using a format file to bcp in and out. Still got the same result going in, and bcp out, the money columns came out as garbled characters instead of numbers. In the end I did end up linking to SQL Server 2000 and using DTS. I agree […]

You rated this post out of 5. Change rating

2003-08-28

Technical Article

RE: Joining a text file with a table in a query

  • Reply

I am able to create the linked server but I am getting a message when I attempt to verify the tables or query the tables (files) The error is: Server: Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 20 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: '\\Mhc_remote\Groups\mis\BHO\PREMIER\Pending' is not a […]

You rated this post out of 5. Change rating

2003-07-24

1 reads

Technical Article

RE: Server 2000 exam or Server 2003?

  • Reply

Thanks for your views on this, I haven't been thinking about how Yukon will affect this. The more I look into it the more I think the 2000 would be more appropriate for my current work and I am guessing that a lot of what I learn on 2000 can be taken to 2003 anyway, […]

You rated this post out of 5. Change rating

2003-07-10

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers