RE: SQL2000 (64 bits) edition

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joseph (Joseph_at_discussions.microsoft.com)
Date: 01/04/05 

Date: Mon, 3 Jan 2005 17:41:05 -0800

Please advise whether we need to the "SQL web DB admin." tools as well?? Or
just using the SQL32 to remote admin the SQL64 baby?

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> No issues that I am aware of or encountered. Just treat it like any other
> server. Make sure that you install SQL Server 2000 SP3a on the machine that
> has the client tools installed. Cleint tools get fixes too!
>
> Regards
> Mike
>
> "Joseph" wrote:
>
> > Mike,
> > Thanks for your quick response. Will there have any incompatible issue and
> > does anything we need to pay attention to in handling 64bits SQL from 32bits
> > SQL EM?
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> > > Hi
> > >
> > > For SQL Server 2000, you have to use EM installed on a 32 bit machine to
> > > manage SQL Server on 64Bit
> > >
> > > SQL server 2005 will not have this limitation.
> > >
> > > Regards
> > > Mike
> > >
> > > "Joseph" wrote:
> > >
> > > > Our system equipped with the 64 bits SQL server but we found that there is no
> > > > enterprise manager come with it. Does anybody know how to manage this? I
> > > > found a tool called "SQL Server Web Data Administrator" which can manage the
> > > > SQL through web server, pls advise whether this tools is workable on the 64
> > > > bits edition?

Relevant Pages

  • Re: Reading sequential files in COBOL vs SQL
    ... Obviously in COBOL I'd having to allow for reading a high ... |> | Mike Sicilian ... |> sequential search will be almost twice as fast as SQL because on average you will quit after reading half the file and SQL will ...
    (comp.sys.ibm.as400.misc)
  • Re: Batches
    ... "Mike" wrote in message ... >> building a single string I could have answered that more appropriately. ... >> Andrew J. Kelly SQL MVP ... >>> This is just the standard method of the built in .NET SQL Server data ...
    (microsoft.public.sqlserver.programming)
  • Re: Error after Install Sharepoint Service with SP1
    ... I completely miss the SQL 2005 piece. ... Mike Walsh, Helsinki, Finland ... > After I installed sharepoint service with SP1 in a box with SQL 2005 April> CTP of Window 2003, I encountered following error when access SharePoint ... I checked IIS log and my NT domain> name/ID was shown as authenticated user. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: reclaiming LOB space
    ... Books Online says "Reclaims space from dropped variable-length columns ... But as I understood Mike, he did not drop the column, only setting the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • Re: Reading sequential files in COBOL vs SQL
    ... Obviously in COBOL I'd having to allow for reading a high ... | If the files are already in the database and have an index that would allow keyed retrieval of the records you seek then SQL would ... | Mike Sicilian ... If your program can quit the search as soon as you find the record you are looking for, then a COBOL sequential search will be almost twice as fast as SQL because on average you will quit after reading half the file and SQL will always read the whole file. ...
    (comp.sys.ibm.as400.misc)