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!

Register Log in
  • Congratulations dencom 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. 360degreehosting

    can't dbcc checkdb in single user mode

    Hi, I have a database in MS SQL 2000 Server that I need to run the dbcc checkdb (db, REPAIR_ALLOW_DATA_LOSS) I have tried putting the whole instance in single user mode with sqlservr -m and just the db in Enterprise Mgr. Which in it's self works. But when I try to connect with Query Analyzer...
  2. 360degreehosting

    Install a test database on the same sql server?

    Hi, I need some help to install a test database on the same SQL server. I need to bring the data along from the live database as well. I did it once successfully but I can remember and we have too many people using the db now for me to make a mistake. I have tried to create a new db and...
  3. 360degreehosting

    Combine three queries into one for a single report

    Hello, We're using ASP to show reports to our affiliates. Right now, we have a report page that has 3 tables on it (there is one html table per query). We would like to have a single query that groups rows by RegTime and shows the value for each of these three queries on the same row. For...
  4. 360degreehosting

    Help with a simple JOIN please

    Hi, I need help with a simple join. I'm not sure where I'm going wrong but help would be appreciated. Table Structure:: Table1: ZipCode Table2: ZipCode Table 1 - sample data ZipCode _______ 12345 12346 12347 12347 78943 78942 Table 2 - sample data ZipCode _______ 12345 12346 12347...
  5. 360degreehosting

    Launching Remote Desktop from an ASP Page

    Hello, We have lots of servers that several admins have to connect to. I was wondering if there is a way that I can create an ASP page for our Intranet that would give them a way to click on a hyperlink and Launch their local Remote Desktop application and connect them to the server from the...
  6. 360degreehosting

    select statement where i have to match several columns and a range

    I need help with a select statement please that deals with combining some columns and a range I have 2 tables that contain phone numbers: Table1 has the following columns AreaCode Prefix Suffix Table2 has the following columns AreaCode Prefix LowRangeSuffix HighRangeSuffix How do i write...
  7. 360degreehosting

    Deduplicate a text file

    Hello, I have some text files i need to deduplicate. I have started with the following code but I'm getting an error and don't know where to go from here. File 1 text file contents: steve@123.com steve@234.com steve@123.com I'm wanting to check if the string already exists in the File 2...
  8. 360degreehosting

    FSO not working

    Hello, I have a Windows 2003 Server, IIS, ASP installed/enabled all in a default installation and no special tweaking. FSO isn't working on correctly and I'm sure it's something simple. Here is a simple test that returns "false" when it should return "true" because I have verified that the...

Part and Inventory Search

Back
Top