Custom Query Size Limit in FP 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul (anonymous_at_discussions.microsoft.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 08:08:31 -0800

FP 2000 seems to have a size limit on placing large SQL
Statements into the Custom Query box in the Database
Results wizard.

Anyway around this?

Thanks,

Relevant Pages

  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... Personally I feel using the copy DB wizard is more effort than just a backup ... Passwords Between SQL Servers ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Using Database Results Wizard for dropdown
    ... Present SQL for the form (showing just the dropdown portion for GroupMix; ... > Is there a parameter you can add to the sql of the Database Results Wizard ...
    (microsoft.public.frontpage.programming)
  • RE: ODBC Imports of entire Database
    ... When I run the wizard it does not give me the option to copy the entire ... connect to the other database. ... Start the SQL Server Import and Export Wizard ... SSIS package so that we can maintain the SQL base and not have to recreate ...
    (microsoft.public.sqlserver.dts)
  • RE: Trouble with SQL Adapter Metadata Wizard in BizTalk Server 2006
    ... However when I type the SQL Server name ... it works fine and then I can select the default database. ... I'm getting in trouble with SQL Adapter Metadata Wizard in BizTalk 2006. ...
    (microsoft.public.biztalk.general)
  • Problems with sortable tables and DRW
    ... This tutorial uses Frontpage's Database Results Wizard. ... The page is saved as an Active Server Page because FrontPage ... When you specify options, FrontPage writes the SQL ...
    (microsoft.public.frontpage.client)