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 bkrike 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: *

  • Users: bdc101
  • Content: Threads
  • Order by date
  1. bdc101

    SQL Server 2000 Server Change

    We have an old server running SQL Server 2000 that we are replacing, and we are keeping SQL Server 2000 on the new server. The reporting department wants to rebuild Reporting Services 2000 on the new server instead of restoring the old copies when we do the switch. If I do not restore the msdb...
  2. bdc101

    SQL Server 2005 Database Mirroring Setup

    I have two questions: 1) Can one instance of sql server on a third server be the mirror for instances on multiple servers, i.e. database x on server x and database y on server y both have a mirror on server z? 2) A separate license is not required for the secondary instance if it is used solely...
  3. bdc101

    Schemabound View will not Update

    I have a partitioned view that is schemabound to the underlying tables. There is a job that runs every minute that has a step which is supposed to update the view. When the job runs, that step fails with the following error message: UNION ALL view 'sl' is not updatable because a partitioning...
  4. bdc101

    problem with recordset

    Hello all: I am trying to run a query against a database in an asp page, and I am getting an empty recordset returned. I know there is data that should be returned by the database, and I know the query works because I can run it against the database manually with success. I cannot find what...
  5. bdc101

    error codes with msxml in vbs file

    I am getting one of two error codes from a vbs file when the task scheduler in Windows Server 2003 tries to run it. The file is used to generate several different sales reports at night. The reports will still generate if someone is there to press ok within a certain amount of time on the...
  6. bdc101

    Data cut off

    I am running a query in Navicat that is pulling data from a MySQL database. The query pulls all the data, but it is cutting off fields. For instance, an address that is "123 Anystreet" in the db will say "123 Anys". I ahve never seen this happen before. Does anyone know the cause of this...
  7. bdc101

    IF Statement only works on first run through For Loop

    Can anyone help me figure out why the IF statement in the two WHILE loops I have in the following code will work correctly on the first time through the FOR loop but not on the second try. It finds a match and assigns the values on the first run through the FOR loop and everything is calculated...

Part and Inventory Search

Back
Top