Microsoft SQL Management Studio failed to load

I am running SQL Server 2005 bata on my Windows Server 2003, web edition
machine. Recently got an error that the Bata had expired. I ignored this.
However, other C# apps using the Db started having problems.
Uninstalled .Net Framework Version 2. I downloaded the most
recent version from MS, installed the new version.
Now I can't run Management studio or the profiler. Get the following errors:
'Procedure entry point _CxxFrameHandler3 could not be located in the
dynamic link library MSVCR80.dll '
and a follow on error
..."\v2.0.50215\mscorwks.dll could not be loaded".
How do I get back to being able to use these tools?
Hi
The .NET versions are tightly linked to the SQL Server Betas.
Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
They are the newest and are a perfect match.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"FredC" <FredC@.discussions.microsoft.com> wrote in message
news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
> machine. Recently got an error that the Bata had expired. I ignored this.
> However, other C# apps using the Db started having problems.
> Uninstalled .Net Framework Version 2. I downloaded the most
> recent version from MS, installed the new version.
> Now I can't run Management studio or the profiler. Get the following
> errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
> dynamic link library MSVCR80.dll '
> and a follow on error
> ..."\v2.0.50215\mscorwks.dll could not be loaded".
> How do I get back to being able to use these tools?
|||Sql server 2005 CTP won't install here. It keeps asking me to insert
disk 2.
|||On Tue, 20 Sep 2005 08:59:05 -0700, "FredC"
<FredC@.discussions.microsoft.com> wrote:

>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
>machine. Recently got an error that the Bata had expired. I ignored this.
>However, other C# apps using the Db started having problems.
>Uninstalled .Net Framework Version 2. I downloaded the most
>recent version from MS, installed the new version.
>Now I can't run Management studio or the profiler. Get the following errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
>dynamic link library MSVCR80.dll '
>and a follow on error
>..."\v2.0.50215\mscorwks.dll could not be loaded".
>How do I get back to being able to use these tools?
In addition to Mike's comments you need to be very careful about
uninstall order of components from the old SQL Server 2005 and .NET
Framework builds. That is described in some detail in the documents
that come with September CTP.
Andrew Watt
MVP - InfoPath
|||I found and downloaded SQL Server September 2005 CTP but I can't find Visual
Studio 2005 RC1. Where do I get it?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> The .NET versions are tightly linked to the SQL Server Betas.
> Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
> They are the newest and are a perfect match.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "FredC" <FredC@.discussions.microsoft.com> wrote in message
> news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>
>
|||Apologies microsoft, after all the things I've been saying about them.
All you do, is...
1. Install everything apart from SQL express, on the RC VS.Net 2005
1. put the "server" ISO on, install everything but the bottom checkbox.
1. put the "client" ISO on, install everything to run from the
harddrive.
1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
Hey presto, it all works, including SQL express integrated into VS.Net.
(Now we can use SQL Express, with files, who is going to use Access?)
|||drawnai:
Thanks for the good info. But I got myself into more trouble. I thought I'd
try to uninstall Visual Studio and Sever. All the .Net stuff seems to
uninstall and the Server itself uninstalls, but tools like management studio
and profiler don't. They are in my start menu but not in add and remove
programs. Result is that Sever will not install the new tools. Got any
experience at get rid of this stuff while saving existing databases?
"drawnai@.hotmail.com" wrote:

> Apologies microsoft, after all the things I've been saying about them.
> All you do, is...
> 1. Install everything apart from SQL express, on the RC VS.Net 2005
> 1. put the "server" ISO on, install everything but the bottom checkbox.
> 1. put the "client" ISO on, install everything to run from the
> harddrive.
> 1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
> Hey presto, it all works, including SQL express integrated into VS.Net.
> (Now we can use SQL Express, with files, who is going to use Access?)
>
sql

Microsoft launches SQL Server 2005.

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft launches SQL Server 2005.

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft launches SQL Server 2005.

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

Microsoft launches SQL Server 2005.

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft launches SQL Server 2005.

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserversystem/applicationplatform/launch2005/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/errorpages/smarterror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft launches SQL Server 2005.

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft Feedback Center: Available?

I've been trying to get to the MSDN Product Feedback Center to report a bug
in SQL Server 2005 Management Studio. I'm getting an Error when I try to
reach the site - msdn.microsoft.com/feedback - Is it available?
"An error has occurred during the processing of your request. Please try
again later. "
Persistence pays off. I got in with the menu at the top of Management Studio
with Community-Send Feedback.
"Dr. Network" <charles.hawkins@.jenzabar.net> wrote in message
news:ObkYbN1VGHA.5288@.TK2MSFTNGP14.phx.gbl...
> I've been trying to get to the MSDN Product Feedback Center to report a
> bug in SQL Server 2005 Management Studio. I'm getting an Error when I try
> to reach the site - msdn.microsoft.com/feedback - Is it available?
> "An error has occurred during the processing of your request. Please try
> again later. "
>
|||Try http://lab.msdn.microsoft.com/ProductFeedback/
That URL works for me.
Andrew Watt [MVP]
On Mon, 3 Apr 2006 15:18:17 -0400, "Dr. Network"
<charles.hawkins@.jenzabar.net> wrote:

>I've been trying to get to the MSDN Product Feedback Center to report a bug
>in SQL Server 2005 Management Studio. I'm getting an Error when I try to
>reach the site - msdn.microsoft.com/feedback - Is it available?
>"An error has occurred during the processing of your request. Please try
>again later. "
>

Microsoft ASP Licensing Program for SQL Server

I own and run a small ASP that provides membership management services to
non-profit organizations. Currently I host my application on a dedicated
Windows Server 2003 machine at a hosting provider. The application is
..NET-based and makes use of SQL Server databases on a shared SQL Server
machine at said hosting provider.
I have recently been encountering limitations with this usage of SQL
databases on a shared machine. I am ready to purchase my own SQL Server
license. It looks like a per-processor license is the way to go. Because I am
a small operation, I cannot afford outright purchase of SQL Server Enterprise
Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
($4,700-plus for 1 processor).
It looks like the program for me may be the Microsoft ASP Licensing Program,
which appears to offer a monthly bill for a SQL Server per-processor license.
But I'm not getting good answers on this program from the published
materials. In particular, my questions are:
1) Is my company eligible for this program? We are a Registered Member in
the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says a
company must be a Microsoft Certified Solution Provider to buy from the ASP
Licensing Program. Is this a hoop I need to jump through to buy SQL Server on
the ASP plan?)
2) What is the pricing for this program?
Any help you can offer on these questions would be appreciated.
rxsullivan wrote:
> I own and run a small ASP that provides membership management
You should contact Microsoft directly for this question.
David Gugick
Imceda Software
www.imceda.com
|||I agree that you should contact your local MS office for this. In
Australiia, this particular area is looked after by a "Regional Hosting
Specialist", but he's mainly interested in the SPLA licensing you're
referring to. Make sure you look up what's available to you through your ISV
contacts as my experience is that in some cases, these guys can sometimes
save you more money than through SPLA, especially if you're a leading
product in your field.
What country are you in? I'd be happy to ping my local contact to see if I
can help get you connected.
Regards,
Greg Linwood
SQL Server MVP
"rxsullivan" <rxsullivan@.discussions.microsoft.com> wrote in message
news:A6B1CA2D-E162-477E-A1E9-B2E9EBBEE40A@.microsoft.com...
>I own and run a small ASP that provides membership management services to
> non-profit organizations. Currently I host my application on a dedicated
> Windows Server 2003 machine at a hosting provider. The application is
> .NET-based and makes use of SQL Server databases on a shared SQL Server
> machine at said hosting provider.
> I have recently been encountering limitations with this usage of SQL
> databases on a shared machine. I am ready to purchase my own SQL Server
> license. It looks like a per-processor license is the way to go. Because I
> am
> a small operation, I cannot afford outright purchase of SQL Server
> Enterprise
> Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
> ($4,700-plus for 1 processor).
> It looks like the program for me may be the Microsoft ASP Licensing
> Program,
> which appears to offer a monthly bill for a SQL Server per-processor
> license.
> But I'm not getting good answers on this program from the published
> materials. In particular, my questions are:
> 1) Is my company eligible for this program? We are a Registered Member in
> the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says
> a
> company must be a Microsoft Certified Solution Provider to buy from the
> ASP
> Licensing Program. Is this a hoop I need to jump through to buy SQL Server
> on
> the ASP plan?)
> 2) What is the pricing for this program?
> Any help you can offer on these questions would be appreciated.

Microsoft ASP Licensing Program for SQL Server

I own and run a small ASP that provides membership management services to
non-profit organizations. Currently I host my application on a dedicated
Windows Server 2003 machine at a hosting provider. The application is
.NET-based and makes use of SQL Server databases on a shared SQL Server
machine at said hosting provider.
I have recently been encountering limitations with this usage of SQL
databases on a shared machine. I am ready to purchase my own SQL Server
license. It looks like a per-processor license is the way to go. Because I am
a small operation, I cannot afford outright purchase of SQL Server Enterprise
Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
($4,700-plus for 1 processor).
It looks like the program for me may be the Microsoft ASP Licensing Program,
which appears to offer a monthly bill for a SQL Server per-processor license.
But I'm not getting good answers on this program from the published
materials. In particular, my questions are:
1) Is my company eligible for this program? We are a Registered Member in
the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says a
company must be a Microsoft Certified Solution Provider to buy from the ASP
Licensing Program. Is this a hoop I need to jump through to buy SQL Server on
the ASP plan?)
2) What is the pricing for this program?
Any help you can offer on these questions would be appreciated.rxsullivan wrote:
> I own and run a small ASP that provides membership management
You should contact Microsoft directly for this question.
--
David Gugick
Imceda Software
www.imceda.com|||I agree that you should contact your local MS office for this. In
Australiia, this particular area is looked after by a "Regional Hosting
Specialist", but he's mainly interested in the SPLA licensing you're
referring to. Make sure you look up what's available to you through your ISV
contacts as my experience is that in some cases, these guys can sometimes
save you more money than through SPLA, especially if you're a leading
product in your field.
What country are you in? I'd be happy to ping my local contact to see if I
can help get you connected.
Regards,
Greg Linwood
SQL Server MVP
"rxsullivan" <rxsullivan@.discussions.microsoft.com> wrote in message
news:A6B1CA2D-E162-477E-A1E9-B2E9EBBEE40A@.microsoft.com...
>I own and run a small ASP that provides membership management services to
> non-profit organizations. Currently I host my application on a dedicated
> Windows Server 2003 machine at a hosting provider. The application is
> .NET-based and makes use of SQL Server databases on a shared SQL Server
> machine at said hosting provider.
> I have recently been encountering limitations with this usage of SQL
> databases on a shared machine. I am ready to purchase my own SQL Server
> license. It looks like a per-processor license is the way to go. Because I
> am
> a small operation, I cannot afford outright purchase of SQL Server
> Enterprise
> Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
> ($4,700-plus for 1 processor).
> It looks like the program for me may be the Microsoft ASP Licensing
> Program,
> which appears to offer a monthly bill for a SQL Server per-processor
> license.
> But I'm not getting good answers on this program from the published
> materials. In particular, my questions are:
> 1) Is my company eligible for this program? We are a Registered Member in
> the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says
> a
> company must be a Microsoft Certified Solution Provider to buy from the
> ASP
> Licensing Program. Is this a hoop I need to jump through to buy SQL Server
> on
> the ASP plan?)
> 2) What is the pricing for this program?
> Any help you can offer on these questions would be appreciated.

Microsoft ASP Licensing Program for SQL Server

I own and run a small ASP that provides membership management services to
non-profit organizations. Currently I host my application on a dedicated
Windows Server 2003 machine at a hosting provider. The application is
.NET-based and makes use of SQL Server databases on a shared SQL Server
machine at said hosting provider.
I have recently been encountering limitations with this usage of SQL
databases on a shared machine. I am ready to purchase my own SQL Server
license. It looks like a per-processor license is the way to go. Because I a
m
a small operation, I cannot afford outright purchase of SQL Server Enterpris
e
Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
($4,700-plus for 1 processor).
It looks like the program for me may be the Microsoft ASP Licensing Program,
which appears to offer a monthly bill for a SQL Server per-processor license
.
But I'm not getting good answers on this program from the published
materials. In particular, my questions are:
1) Is my company eligible for this program? We are a Registered Member in
the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says a
company must be a Microsoft Certified Solution Provider to buy from the ASP
Licensing Program. Is this a hoop I need to jump through to buy SQL Server o
n
the ASP plan?)
2) What is the pricing for this program?
Any help you can offer on these questions would be appreciated.rxsullivan wrote:
> I own and run a small ASP that provides membership management
You should contact Microsoft directly for this question.
David Gugick
Imceda Software
www.imceda.com|||I agree that you should contact your local MS office for this. In
Australiia, this particular area is looked after by a "Regional Hosting
Specialist", but he's mainly interested in the SPLA licensing you're
referring to. Make sure you look up what's available to you through your ISV
contacts as my experience is that in some cases, these guys can sometimes
save you more money than through SPLA, especially if you're a leading
product in your field.
What country are you in? I'd be happy to ping my local contact to see if I
can help get you connected.
Regards,
Greg Linwood
SQL Server MVP
"rxsullivan" <rxsullivan@.discussions.microsoft.com> wrote in message
news:A6B1CA2D-E162-477E-A1E9-B2E9EBBEE40A@.microsoft.com...
>I own and run a small ASP that provides membership management services to
> non-profit organizations. Currently I host my application on a dedicated
> Windows Server 2003 machine at a hosting provider. The application is
> .NET-based and makes use of SQL Server databases on a shared SQL Server
> machine at said hosting provider.
> I have recently been encountering limitations with this usage of SQL
> databases on a shared machine. I am ready to purchase my own SQL Server
> license. It looks like a per-processor license is the way to go. Because I
> am
> a small operation, I cannot afford outright purchase of SQL Server
> Enterprise
> Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
> ($4,700-plus for 1 processor).
> It looks like the program for me may be the Microsoft ASP Licensing
> Program,
> which appears to offer a monthly bill for a SQL Server per-processor
> license.
> But I'm not getting good answers on this program from the published
> materials. In particular, my questions are:
> 1) Is my company eligible for this program? We are a Registered Member in
> the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says
> a
> company must be a Microsoft Certified Solution Provider to buy from the
> ASP
> Licensing Program. Is this a hoop I need to jump through to buy SQL Server
> on
> the ASP plan?)
> 2) What is the pricing for this program?
> Any help you can offer on these questions would be appreciated.

Mgt Studio Express vs Mgt Studio "Full" questions

I am currently using Management Studio Express to administer remote SQLServer databases I support as a DBA. I notice that I cannot "see" DTS packages on the remote server from Express, but when I login directly to the server (Term Services) and use the local Management Studio (Full?), that I CAN see the DTS packages.

1) What are the other differences between Management Studio Express and Management Studio "Full"?

2) Is it possible to aquire and install (upgrade) on my workstation, to Management Studio "Full" so that I can take advantage of the additional capabilities the "Express" version does not have, in order to manage my remote servers?

TIA,
Phil Streiff, MCDBA

There are quite a few differences between SSMS and SSMS-Express.

You can obtain (and be properly licensed for) SSMS with SQL Server Workgroup, Standard and Enterprise Edition.

|||

Thanks Arnie,

I will definitely upgrade to SSMS now, based on your input.

I suppose I have to pay for the SQL2K5 Standard or Workgroup license, even though I'm only installing the Mgt Studio on my workstation and not the whole database engine.

Phil

|||

SS 2005 Workgroup Edition is about $750 with 5 CALs. (Maybe better pricing is around.)

IF you were in a dev environment, you could get SS Developer's Edition for about $50. But I don't think that it would be legit to manage production servers.

Maybe one or more of your clients provide you with SSMS to manage their servers.

For definitive licensing questions, call the licensing folks at:

Licensing –VL Contact
(800) 426-9400

Good Luck!

MgmtStudio: Use current connection/window when opening file

Is there a setting that I am missing, or is it just not possible to do.

When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.

Is there a way that I can set it to NOT do this, and use the existing Window/Connection.

As we have to SQL Logins and thus need to type our passwords each time a new connection is made...

Also, is CTRL-N not in use anymore to open a new connection/window ?

This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

MgmtStudio: Use current connection/window when opening file

Is there a setting that I am missing, or is it just not possible to do.

When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.

Is there a way that I can set it to NOT do this, and use the existing Window/Connection.

As we have to SQL Logins and thus need to type our passwords each time a new connection is made...

Also, is CTRL-N not in use anymore to open a new connection/window ?

This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Mgmt Studio not supporting 7.0?

I tried using Mgmt Studio RTM to connect to SQL Server 7.0 instance and
received this:
"This version of Microsoft SQL Server Management Studio can only be used to
connect to SQL Server 2005 and SQL Server 2000 servers (ConnectionDlg)"
I thought Mgmt Studio was going to support 7.0?
Hi
No. 7.0 is really very close to end of life so no support for it.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Johnny Ortega" <john.ortega@.quest.com> wrote in message
news:uuklBLx5FHA.2956@.TK2MSFTNGP12.phx.gbl...
>I tried using Mgmt Studio RTM to connect to SQL Server 7.0 instance and
> received this:
> "This version of Microsoft SQL Server Management Studio can only be used
> to
> connect to SQL Server 2005 and SQL Server 2000 servers (ConnectionDlg)"
> I thought Mgmt Studio was going to support 7.0?
>
|||Maybe part of the confusion is because the book 'Microsoft SQL Server 2005 -
Changing the Paradigm' mentions that SQL Server 7 will be supported (page
97).
Ben Nevarez
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:usTkijx5FHA.2628@.TK2MSFTNGP11.phx.gbl...
> Hi
> No. 7.0 is really very close to end of life so no support for it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Johnny Ortega" <john.ortega@.quest.com> wrote in message
> news:uuklBLx5FHA.2956@.TK2MSFTNGP12.phx.gbl...
>
|||Hi
Lots of features get dropped from the Product over it's development life.
This support was dropped very early. SMO support for SQL Server 7.0 was
dropped very late and there is still documentation mentioning it.
During the development program, even e-mails were stale by the time most
people read them, let alone printed books.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:e2lMdML6FHA.1000@.tk2msftngp13.phx.gbl...
> Maybe part of the confusion is because the book 'Microsoft SQL Server
> 2005 - Changing the Paradigm' mentions that SQL Server 7 will be supported
> (page 97).
> Ben Nevarez
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:usTkijx5FHA.2628@.TK2MSFTNGP11.phx.gbl...
>

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
Regards,
Gary BlakelyTry to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
--
Regards,
Gary BlakelyTry to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>|||Hi Gary,
SQL Server 2005 Management Studio totally supports attaching SQL Server
2000, MSDE2000 and SQL Express databases by using sp_detach_db/sp_attach_db
stored procedure.
Please try again via the following:
1. Connect to your MSDE instance, and run the following statement:
use master
go
exec sp_detach_db 'YourDatabaseName'
2. Connect to your SQL Server 2005 instance and run the following statement:
use master
go
exec sp_attach_db @.dbname='DatabaseName',
@.filename1 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test.mdf',
@.filename2 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test_log.ldf'
Could you please mail me (changliw@.microsoft.com) the SQL error logs and a
screenshot of the error message for further research?
By default, the error logs of SQL Server 2005 instance are located in
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG". You may check it
if there are multiple instances installed on your computer.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
Regards,
Gary Blakely
Try to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>
|||Hi Gary,
SQL Server 2005 Management Studio totally supports attaching SQL Server
2000, MSDE2000 and SQL Express databases by using sp_detach_db/sp_attach_db
stored procedure.
Please try again via the following:
1. Connect to your MSDE instance, and run the following statement:
use master
go
exec sp_detach_db 'YourDatabaseName'
2. Connect to your SQL Server 2005 instance and run the following statement:
use master
go
exec sp_attach_db @.dbname='DatabaseName',
@.filename1 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test.mdf',
@.filename2 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test_log.ldf'
Could you please mail me (changliw@.microsoft.com) the SQL error logs and a
screenshot of the error message for further research?
By default, the error logs of SQL Server 2005 instance are located in
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG". You may check it
if there are multiple instances installed on your computer.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Meta Data Management / Dependancy Analysis

BI perspective, meta data management is quite crucial. In SQL 2000, as far as I know we didn't have a great support for meta data. Has that changed in SQL2005?
What about dependancy analysis? For example if I drop a column from a SSIS data flow what would be affected? Is it possible?

Thanks

Hi Thiru,
Re: Dependancy analysis: IDW 13 (I think) contained new functionality in the data-flow that detected when the metadata of the data-flow was not correct (e.g. If a column gets deleted from a component all downsteam componentrs will be affected) and prompts the designer with a number of options to fix. Of course, this same functionality is still there.

Re: Metadata management: What sort of metadata do you want to manage (e.g. metadata about the pipeline, execution metadata etc...?
How do you want to manage it?

-Jamie|||Jamie

We have used AbInitio EME (yes I know very very expensive product) at Reuters. Which does meta data management very well. This enables us to let the user community (via web site) to see where the data comes from and how we have transformed etc. So users can see it very clearly what calculations have been conducted etc.

At General Motors, SAS consultants used to show how SAS does dependancy analysis. I thought it was quite impressive.

I would like to see these two features inside SQL Server / even if we have to purchase it as separate product(s).

So my question, "is MS going to provide similar tools like their competitors?" I did speak to few MS speakers at TechEd, but didnt get any definite answer. Jamie, I was wondering whats your opinion on this?

Maybe Kirk or Ash can shed any light?

Thanks

Sutha|||Sutha,
Informatica too has a fantastic real-time monitoring tool called the Workflow Monitor. I asked a while back whether SSIS was going to get anything similar and was told "Not in this version".

Remember that this is still a version 1 product and even though there's a tremendous raft of features perhaps we shouldn't be expecting metadata tools such as these too early.

I'd be particularly interested to see if Donald has any thoughts on this but unfortunately he doesn't check this forum.

-Jamie|||Jamie

Infact I did speak to Donald about thing among other things. He didnt give me a definite answer and therefore I did assume it is not there. I did ask him about AbInitio data profiler and what is equivalent in SSIS. He did point that grpahs can act as a data profiler. I think MS need to make improvements on Data Profiler side too.

To compete with AbInitio, Informatica and other products, MS have to come up with a tool which can compete at same level. MS can compete very easily on price as the other products are extremly expensive.

Lets see what Kirk or Ash got to say!

Thanks

Sutha|||Hi guys, thanks for the questions. We're still just trying to get Yukon out the door. So, as you can imagine, we haven't quite transitioned to V.next discussions. We're aware that metadata management is something people are asking for. However, what that means to one person may be totally different than for another.
We're aware of what competitors provide, and will be looking at how to best fill the needs of our customers. As we get closer to planning v.next, we'll be eliciting more input like this from you our customers. We have some ideas about what's next, but we'd like to hear what you have to say.
Thanks,|||Thanks Kirk. I understand you are trying to get the product shipped in time. For next release it would be great if we could have something to cater for these 3 major areas.
Data Profiler (We can do now to a cretain extent)
Metadata Management Tool
Dependancy Analysis Tool

Sutha|||Can you describe those a little better to me? Please send me email directly and we can take this off line. Thanks,
K

Kirkha[at]Microsoftdotcom|||Ok ta. I will do that.

Thanks|||

In all of the responses I did not see where someone said if there is a way to at least generate some sort of meta data reports of the packages. Yes it is in xml, but I assume Microsoft at least has a way to retrieve meta data easilly. For examples Tasks Names, Sources, Variables and etc. Quite obviously not every one will want to open Visual Studio to find out what DTS packages we have servicing a Warehouse. Can anyone provide some insight on this?

|||Henry,
I haven't heard of anything like that but it sounds like it could be a useful little tool.
Perhaps a .Net utility that uses X-Query to get at the elements of the .dtsx file? I can really see some value in something like this. I imagine someone in the SSIS community will come up with something like that before too long!

-Jamie|||Jamie

As you say someone will come up with something soon. It is going to be a valuable tool. Clients enquire this type feature when we try to sell MS DW solution to them. Maybe Darren and Allan can come up with something? hint hint :-)

Thanks
Sutha

PS - Jamie, I haven't done that mail yet