Re: I miss TBatchMove

From: Bryan Valencia (bryan_at_209software.com)
Date: 06/05/04 

Date: Sat, 5 Jun 2004 08:02:16 -0700

> > Otherwise, how do I
> >move all or part of a table from database "A" to database "B" using ADO?
> With an SQL server an Insert Query works well

That would work, but the data is travelling between different databases.

Relevant Pages

  • Re: Very slow Responding SQL2000
    ... Can you install the SQL Server client tools remotely and connect ... using both Enterprise manager as well as Query ANalyzer and check the Query ... One more thing is uncheck the AUTOCLOSE option for all databases ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 Database corrupt
    ... All query returns a response. ... I've tried DBCC CHECKDB, but it's doesn't detect any error. ... the databases are corrupt. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Using sp_executesql
    ... I gave only a portion of code where I was trying to reproduce the bug. ... And than run the query once again. ... I was trying to replicate the bug by adding several create/drop databases ... I used 2 databases in this example to force SQL Server to set ...
    (microsoft.public.sqlserver.programming)
  • Re: Convert Month Names To Sortable Values?
    ... I forgot to mention the databases I'm using. ... I've got an Access version of it that I'm using to develop the thing, but when it goes live it will be on SQL Server. ... computed column in the query only, ... >> What I want to do is sort on this column, but sort it by the actual date. ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQLServer stops responding w/SQLServer Agent
    ... Perhaps Agent started a job which blocks some query that your web app is running? ... I am running about 50 databases on the box. ... What happens every-once-in-awhile is that SQL Server will stop responding. ... Manager), query analyzer will return results, etc. but no Web traffic goes through. ...
    (microsoft.public.sqlserver.tools)