Thanks Everyone,

Paul is correct I figured this out shortly after the posting.

After renaming the Alias and sorting by the actual database field

the sort order works fine.

Thanks again,

Jeff

We are using named instances and when I run the command. I get the following.

Remember tempdb as far as the database is concerned no longer exists.

Since in our scenario...

Adrian

That worked, and is exactly what I needed.

Thanks,

Jeff

This is the link to the CSV that I need loaded in to a table located in SQL Server 2000.

http://www.globalindices.standardandpoors.com/data/wdpmi_bus.csv

Thanks,

Jeff

Thanks Mike your suggestion worked.

FYI -This is the working Code

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

 Dim dtPreviousDate

 Dim strFileDate

 Dim strTableName

 Dim strSQLTableName

 Dim Result

 Dim cnSybase

 Dim cnSymposium

 Dim rsSybaseSYM

 Dim rsSQLSYM

 Dim rsCallByCallStat

 Dim rsCallByCallStatSQL

 Dim strConn1

 Dim strConn2

 Dim strSQL...

Mike,

With the detach and re-attach method how would you handle system databases master, temp, msdb and model. Also, how do you recommend transferring DTS packages as well as scheduled jobs.

Thanks,

Jeff

Is there a way to allow the user to change

a standard logon password without the DBA's

intervention.

jcollins