Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sgreenwest

    New to SQL Server and DTS

    Hi All, I'm pretty new to all this stuff so please be nice. i have been handed the problem of designing and developing an on-line application system for our business. The application will be hosted by an external company and we will upload and download information to the company on a daily...
  2. sgreenwest

    Moving test ASP.NET application to live environment

    i did run it though the query analyser and it seemed to work ok. But i've just noticed a problem with it. Something happened when i backed up DB and restored it. Some of the output parameters in the stored procedure got wiped out of the file so i copied the developemnt ST over the backed up one...
  3. sgreenwest

    Moving test ASP.NET application to live environment

    here is the stored procedure. CREATE PROCEDURE EmployeeLogin ( @userName varchar(50), @password varchar(20), @NurseID varchar(7) OUTPUT, @Forename varchar(50) OUTPUT, @Surname varchar(50) OUTPUT ) AS SELECT @NurseID = NurseID, @Surname = Surname, @Forename = Forename FROM...
  4. sgreenwest

    Moving test ASP.NET application to live environment

    checked this the run fine in the QA. i just changed the code so the error is returned it says "Procedure or function EmployeeLogin has too many arguments specified this SP works fine in the test environment. just to let you know i new to SQL and .NET so please excuse my ignorance for simple...
  5. sgreenwest

    Moving test ASP.NET application to live environment

    All, i have been pulling my hair out all day. i just completed my first section of my new ASP.net application. The system uses SQL Server 2000 and vb.Net for code behind pages. I'm using visual studio 2002. My system is working fine on my local laptop but when I copied the file over to another...
  6. sgreenwest

    Moving test ASP.NET application to live environment

    All, i have been pulling my hair out all day. i just completed my first section of my new ASP.net application. The system uses SQL Server 2000 and vb.Net for code behind pages. I'm using visual studio 2002. My system is working fine on my local laptop but when I copied the file over to another...
  7. sgreenwest

    Importing information from unix file to Database

    can i set it up so the sytem will check every few minutes if there is new information so in the location.
  8. sgreenwest

    Importing information from unix file to Database

    All, I have been told I have to develop a system to that imports a UNIX text file periodically over the day into a SQL server Database. I am new to SQL server but can anyone give a pointer to what I will need to do to enable this to happen, the background to it is the file is sent out to a...

Part and Inventory Search

Back
Top