Never mind on this. I discovered that by setting up a DSN on the local sql server, I can use the MS OLE DB Provider for ODBC Drivers and point...

Thanks for your input. Yes, we do have this configuration. We have one domain user account that runs the services for SQL Server and SQL Server agent. The account has...

Thanks, I'll try some variation of this.

CSDunn

Daniel,

Thanks for this contribution, I really appreciate it. The script files are pretty easy to decipher.

I wound up putting the text files into an MS Excel format, and that made...

If you know of a documented example of this that I might be able to find on the web, could you point me to the URL? If not, and if...

Yes, thanks for being so helpful. I'd also be iterested in seeing an Active X script that could do this kind of thing. SSIS appears to have some build in...

Thanks for your response on this. I'll have to put this on the back burner for now.

CSDunn

Fixed the problem. It may have had something to do with an MDAC version. I ran sp 2 for Windows xp again, and the problem cleared up.

Thanks!

I have been able to create a .udl file, but I cannot open it. When I try to open the udl file, I get the following error message; Microsoft Data...

yes, that just occured to me (duh).

Thanks!

Thank you for the assistance. It occured to me that I could probably get away with this:

Declare @SvcNameValue varchar(40)

Declare @BeginningAlpha char(1)

Declare @EndAlpha char(1)

Declare @PartialString varchar(5)

Declare @TerminatedString varchar(100)

SET @BeginningAlpha = ''...

I was aware that I could set ARITHABORT ON at the database level, but if I understand correctly ,If ARITHBORT is off, a value of NULL will be inserted where NULL values...

Thanks for your help. I'm trying this approach as I explore ways to more efficiently query a table that has eighty two fields, seventeen million records, no Primary Key, and...

I'm looking at some information in BOL that addresses 'Resolving Indexes on Views'. If you have any ideas on this, please share.

Thanks again!

CSDunn

Thanks again, I really appreciate the assistance!

CSDunn