Hi, I want to write a program in VB 6.0 to access files and directories from a remote server using windows authentication . But I am not familiar with this. Appreciate your help. kalam.

Hi, I am using two temp tables of same name e.g. #temp in two diffrent sored procedures of diffrent name e.g sp1 and sp2, in SQL server 2005. I am just not sure whether there will any problem when users will be accessing the two stored procedures simultanously. Please help. Kalam.

Hi, I created a SQL Linked server for excel file. I am using that Linked server to Import the data from Excel files.When selecting the reords from this linked server , it returns the data in alphabetical order. But I want the same order of columns which is in Excel file. for selecting the records i am using tis Query: select * from ExcelImport...Test$ where, ExcelImport is Linked server name and Test$ is the sheet in the excel file. Please help. kalam.