Enterprise Manager Open Table/Return All Rows

After upgrading Windows 2000 server to Windows Server 2003 Standard Edition
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWD
I'd try re-installing the tools...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>
|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Edition
Table/Return
>
|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:

> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Table/Return
>
>

Enterprise Manager Open Table/Return All Rows

After upgrading Windows 2000 server to Windows Server 2003 Standard Edition
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWDI'd try re-installing the tools...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Edition
Table/Return[vbcol=seagreen]
>|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:

> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Table/Return
>
>

Enterprise Manager Open Table/Return All Rows

After upgrading Windows 2000 server to Windows Server 2003 Standard Edition
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWDI'd try re-installing the tools...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> > After upgrading Windows 2000 server to Windows Server 2003 Standard
> Edition
> > I'm receiving a '8007007F Unknown Error' when I use the 'Open
Table/Return
> > All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> > Although not exactly my issue KnowledgeBase Article 817301 suggested
> > re-registering query.dll and tquery.dll. I've tried this and I'm still
> > having the same issue. If anyone is knows of this issue please respond.
> >
> > Thank-you,
> > EWD
> >
> >
>|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:
> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> > I'd try re-installing the tools...
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> > news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> > > After upgrading Windows 2000 server to Windows Server 2003 Standard
> > Edition
> > > I'm receiving a '8007007F Unknown Error' when I use the 'Open
> Table/Return
> > > All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> > > Although not exactly my issue KnowledgeBase Article 817301 suggested
> > > re-registering query.dll and tquery.dll. I've tried this and I'm still
> > > having the same issue. If anyone is knows of this issue please respond.
> > >
> > > Thank-you,
> > > EWD
> > >
> > >
> >
> >
>
>

Enterprise Deployment of SSIS

Hello, we are interested in upgrading our Data Warehouse environment to SQL Server 2005 to take advantage of SSIS. Our current data warehouse environment consists of 2 production servers with over 900 DTS packages between the 2 servers.

Are there any white papers out there detailing what type of deployment works well for an Enterprise wide use of SSIS? We're trying to determine if we should use SSIS on the same server hosting our databases, or separate SSIS onto its own dedicated box. If we went the dedicated route, what type of horsepower would we need on the SSIS box (procs, RAM, etc.)? Also, if we went the dedicated route, does it make sense to have 1 SSIS server that handles the data warehouse packages and the OLTP packages, or should that be separated into 2 SSIS servers having one server for each environment?

Thanks for any help you can provide on this subject!

Eric

the 32 bit version of ssis can use a maximum 3 GB of RAM. because of this limitation, i recommend using the 64 bit version instead (if possible).