Microsoft SQL Server 2005 Express Edition Toolkit Is not in my Add Remove Programs how do I unin

I have Microsoft SQL Server 2005 Express Edition Toolkit installed but there is something from with the installation since every time that I try and create a Report Server Project It gives me error

Could not load file or assembly "Microsoft.ReportingServices.Designer, Version 9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannopt find the file spesified.

How can I reinstall it or repair the installation so it will work. I have uninstalled every SQL2000 component in Add Remove Programs and reinstalled them. The problem is however that I cannot see an entry for "Microsoft SQL Server 2005 Express Edition Toolkit" in the Add Remove programs in Windows XP Profesional.

Can someone please help me. Maybe tell me where the uninstall file is located on disk?

Any help will be great

Manu Thanks

This may not be what you are expecting but it could be you don't have IIS installed in your box and when IIS is not installed, in full SQL Server editions the installer skips Reporting services. So make sure IIS is installed before trying to open reporting services because it will not run without it. Hope this helps.|||

Thanks for the quick response.

I have everything else working, IIS is working and I can access the report manager and the report server url's, those all work fine. The problem comes in when I try and create a Report Server Project in Visual Studio. As soon as I try and create the project I get the error I mentioned above. It is as if it doesn't find the Reporting Services Design Assembly, but I've done a search on the PC and I did find the dll, so I might need to spesify somewhere where it is?

I'd like to just uninstall the Toolkit and Reinstall it but the Express installer doesn't support uninstalling and the Add Remove Programs in Control Panel doesn't have an Entry for the Toolkit.

Microsoft SQL Server 2005 DTS Designer Components

Hi,

I learned this from one of SSIS book-Migrating from Data Transformation Services to Integration Services in SQL.

For the design time components, Microsoft has created a special distribution called the Microsoft SQL Server 2005 DTS Designer Components. The Designer Components distribution replaces the components that get uninstalled when you upgrade your last instance of SQL Server 2000. If you want to upgrade all your SQL Server 2000 instances, this is the best and only option for recovering the DTS designer.

Is anybody heard of this 2005 DTS Designer component?

Where to download? How it works? Any experience to will be appreciated.

Thanks,

Charley

Some info here-

DTS2000
(http://wiki.sqlis.com/default.aspx/SQLISWiki/DTS2000.html)

|||

Thanks so much.

Charley

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

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 DST Webcast Starting in 30 Minutes

There is a free Microsoft Webcast on Daylight Saving Time starting at 2:00pm
today PST (30 minutes from now). Please see the information below if you
would like to attend.
Click the meeting URL:
https://www.livemeeting.com/cc/lmevents/join?d=msft092407sa&role=attend&pw=ATN783
or
If you can't click the above meeting URL, click the following link:
https://www.livemeeting.com/cc/lmevents.
When you click on either URL, the Join Meeting page appears. In the
following fields, verify or enter this information:
Name: (Enter your first and last name)
Meeting ID: msft092407sa
Meeting Key: ATN783
More information on DST Webcasts:
http://support.microsoft.com/gp/dst_webcasts.
--
Regards,
Scott Schnoll
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no
rights. Please do not send email directly to this alias. This alias is for
newsgroup purposes only.Sorry for the spam, but I should be 2:00pm PDT, not PST.
"Scott Schnoll [MSFT]" <scschnol@.online.microsoft.com> wrote in message
news:OPs1Vou$HHA.2268@.TK2MSFTNGP02.phx.gbl...
> There is a free Microsoft Webcast on Daylight Saving Time starting at
> 2:00pm today PST (30 minutes from now). Please see the information below
> if you would like to attend.
> Click the meeting URL:
> https://www.livemeeting.com/cc/lmevents/join?d=msft092407sa&role=attend&pw=ATN783
> or
> If you can't click the above meeting URL, click the following link:
> https://www.livemeeting.com/cc/lmevents.
> When you click on either URL, the Join Meeting page appears. In the
> following fields, verify or enter this information:
> Name: (Enter your first and last name)
> Meeting ID: msft092407sa
> Meeting Key: ATN783
> More information on DST Webcasts:
> http://support.microsoft.com/gp/dst_webcasts.
> --
> Regards,
> Scott Schnoll
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights. Please do not send email directly to this alias. This alias is for
> newsgroup purposes only.
>sql

Method EnumDatabaseMapping on Login SMO object takes 3 minutes

Hi,

The EnumDatabaseMapping call below takes upto 3 minutes on some SQL Servers whereas it takes hardly any time at all on others. What may cause such a long delay?

Regards,
Joginder Nahil
www.starprint2000.com

Private Sub OutputUserMapping(ByVal oLogin As Microsoft.SqlServer.Management.Smo.Login)

Dim colDatabaseMapping() As DatabaseMapping
colDatabaseMapping = oLogin.EnumDatabaseMappings

' Rest of the code has been deleted

End sub

Hi Joginder,

EnumDatabaseMappings is an expensive operation. SMO issues queries that iterate over all databases on the server and stores intermediate results in a temporary table. This might take time for a server with many databases and users, especially if under heavy load.

You can find out more by running SQL Server Profiler and inspecting the queries that are being sent to the server.

Arur Laksberg
SQL Server Team
Microsoft

|||

Hi Artur,

I am inclined to say that 3 minutes is a very long time in computer processing time (BTW my SQL Server is on the same computer as running the application and has 1GB memory + 3.6 Pentium 4 Processor+ there is nothing much else running) to enumerate just three databases AdventureWorks, Pubs and Northwind.

Regards,

Joginder Nahil
www.starprint2000.com

Meta Data Services

Hello SQL Gurus:
How do I enable the SQL Server Meta Data Services? When I installed the
default instance, during SQL installation for the first time, I did not see
anything about installing meta data services. I am practicing with DTS and i
n
the Select Source Table And Views page, the SQL Services Meta Data Services
is grayed out and I want to be able to select it and proceed with my tasks i
n
the 70-228 book about modifying tables and summarizing dta in the
northwindreportdata database using the DTS Import/Export wizard. How do I
enable the meta data services? Thank you.Hi
I have never used this, but one way may be to install the meta data SDK.
John
"Dominick D." wrote:

> Hello SQL Gurus:
> How do I enable the SQL Server Meta Data Services? When I installed the
> default instance, during SQL installation for the first time, I did not se
e
> anything about installing meta data services. I am practicing with DTS and
in
> the Select Source Table And Views page, the SQL Services Meta Data Service
s
> is grayed out and I want to be able to select it and proceed with my tasks
in
> the 70-228 book about modifying tables and summarizing dta in the
> northwindreportdata database using the DTS Import/Export wizard. How do I
> enable the meta data services? Thank you.|||Well, I was looking, but I could not find out how to install the meta data
SDK. Can you point me in the right direction? Thanks.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I have never used this, but one way may be to install the meta data SDK.
> John
> "Dominick D." wrote:
>|||Hi
I think this is part of the SQL 2000 installation, but I don't remember ever
seeing it!
John
"Dominick D." wrote:
[vbcol=seagreen]
> Well, I was looking, but I could not find out how to install the meta data
> SDK. Can you point me in the right direction? Thanks.
> "John Bell" wrote:
>

Message Time to Live

Hi There

I have issues around forwarding message being dropped because they exceed the forwarding message time to live.

I cannot find anything in BOL or the net regarding changing the message time to live value to be higher, does anyone know where i change this setting ?

Thanx

The message time to live is 30 seconds and cannot be changed. However the tolerated time drift between servers is 30 minutes, so effectively a message can stay in traffic 30 minutes and 30 seconds. With such a long lifetime, I find it difficult to believe message are really dropped because of lifetime expiration. First of all, can you verify that there is no time drift between the servers involved?

|||

Hi Remus

I just posted the complete scenario under the thread "Messages cannot be dispatched", i will mark this quesiton as resolved, we can continue on that thread, i will check server times now.

Thanx

|||

Hi Remus

ANother point is that we are expecting to send very large messages over very slow netowkrs that will take hours to send, are you saying that is not possible with SB ?

Thanx

|||

During transport a 'message' is an individual fragment, 90kb in size. The 90Kb have to reach the final destination within 30 minutes. Are you saying your network is slower than 60 bps?

|||

Hi Remus

The server times are the same.

The network is +- 1KB per second, i doubt the 30 minutes is the issue , but i am definately expering the problem, but like i said my real concern is actually a related issue under the thread "Large Messages cannot be dispatched" lets continue there, Thank You

Message Retieval

Hello again,

A.
This time I would like to get your input on two ways of getting a message off a queue. Both are samples, but I would like to know more about the implications.
This first example (BOL) goes directly to the queue:

WAITFOR (

RECEIVE TOP(1)

@.messageTypeName = message_type_name,

@.messageBody = message_body,

@.conversationHandle = conversation_handle

FROM ExpenseQueue

), TIMEOUT 500 ;
The second one (SQL Server samples) obtains a conversation hanle, then gets a message:
WAITFOR(
GET CONVERSATION GROUP @.conversation_group_id FROM [dbo].[ProcessBCHQueue]),
TIMEOUT 500 ;

RECEIVE
TOP(1)
@.conversation_handle = conversation_handle,
@.message_type_name = message_type_name,
@.message_body =
CASE
WHEN validation = 'X' THEN CAST(message_body AS XML)
ELSE CAST(N'<none/>' AS XML)
END
FROM [dbo].[ProcessBCHQueue]
WHERE conversation_group_id = @.conversation_group_id ;

what are the implications between both calls?
I would think that:
1. In any case messages are initially send via a dialogue, so I am not sure why the first example eliminates the conversation handle;
2. Does the second example allow for more readers getting messages on different conversations, since unique conversation handles are explictly obtained?
3. Since the first method was in the Handling Poison Messages of BOL, is that a more straight forward approach that allows for easier handling of error messages?
4. Anything else that might be interesting to note? Please share.

Thanks again,

Lubomir

The second example shows how to process messages when you need to retrieve a state from your database associated with the incomming messages. The recomended way is to store this state in a table and use the conversation_group as the table key. The second example allows you to first lock an available conversation group (one that has messages to be received), then look up the state associated with this particular group, then receive the messages of this group.

The different approach is only a performance optimization. The first example would require you to look up this state for each message received. The second example allows you to look up the state once, then process all messages for that particular conversation group in a loop, w/o looking up the state again.

The typical example of processing in the second case is:

BEGIN TRANSACTION
WAITFOR (GET CONVERSATION GROUP...), TIMEOUT ...
WHILE (@.conversation_group IS NOT NULL)
BEGIN
-- lookup state in the state table here, using the @.conversation_group key
--
RECEIVE TOP(1) ... WHERE conversation_group = @.conversation_group
WHILE (@.conversation_handle IS NOT NULL)
BEGIN
-- proces message here
--
RECEIVE TOP(1) ... WHERE conversation_group = @.conversation_group
END
COMMIT;
BEGIN TRANSACTION;
WAITFOR (GET CONVERSATION GROUP...), TIMEOUT ...
END
COMMIT

The transaction boundaries are important in this example. One shouldn't commit each individual message as it processes the inner loop, as a commit will actually release the lock on the conversation_group and another reader might alter the looked up state.

There is no difference between the two approaches on how many readers can progress in paralel. Both approaches will lock the conversations in the same way, the difference is only in how the procedure would handle an application specific state lookup.

HTH,
~ Remus

|||Thank you very much Remus,

Lubomir