Probably BUG on Dependency tool

In SQL SERVER 2005 SP2 the dependency tool seem to work bad on view declared as the follow one:

SELECT QUERY1

 

UNION

 

SELECT QUERY2

 

The problem can be fixed rewriting the view as

 

SELECT QUERY1

UNION

SELECT QUERY2

 

Simone

WARNING ANOTHER KB UPDATE FOR VISTA x64

WARNING, Microsoft released another update!

 

At this moment in time we have 3 updates for Vista Ultimate x64:

KB932596, KB938979, KB941649

 

If you have one of them installed the: bcdedit -set loadoptions "DDISABLE_INTEGRITY_CHECKS" function wil, stop functioning.

In other words, it will be impossible to load unsigned drivers.

 

Many people have problems and even internet connections, firewall programs like Peerguardian (freeware) will not function.

 

As programmer to be able to make a program that uses drivers, you must get them signed at Microsoft. This costs money.

 

It is of course a way of unfair business, by Microsoft. It is unreasonable to demand mony for a freware program for example.

 

If you don't want problems, and want to use unsigned drivers. Remove the mentioned updates.

 

ANOTHER DANGER:

Microsoft has plans to include these updates in Vista SP1, if Microsoft does this many people will be unable to use their programs. And even connect to the internet, with teir trusted firewall applications like for example Peerguardian.

 

Also:

It damages technological advance, if you are a programmer how can you write a new driver? Get your BETA builds signed??? It is insanity on the part of Microsoft.

 

Complain NOW!

 

In my opinion Microsoft should fire the guy, most responsible for these updates. Un do them, and defenetly not include them in SP1.

 

If they don't, they probably will get another million dollar fine by EU commisioner Nellie Kroes. Deserved this time I think!

 

 

Kindest regards,

 

 

Uncle X(NL)

November updates to The Configuration Manager Documentation Library

The Configuration Manager Documentation Library on TechNet has been updated for November.  Many of the updates were added directly in response to customer requests and comments and questions that we saw here.

 

For a list of the new or updated topics, see "What's New in the Configuration Manager Documentation Library for November 2007" (http://technet.microsoft.com/en-us/library/bb892811.aspx). New and updated topics also say "Topic last updated—November 2007" so if you see a conflict with a previous version, trust the later date.

 

Discussions about a printable format are underway but no news there.

 

An updated November chm is still in the works but not available at this time. We'll keep you posted when we have that ready to download.

 

As always, we welcome your feedback and discussion about the documentation in the Documentation forum.

 

 

 

Step-by-Step guide for "How to Install a Configuration Manager 2007 Primary Site Using Custom Setup"

Hi,

I just created a Step-by-Step guide for "How to Install a Configuration Manager 2007 Primary Site Using Custom Setup" uploaded to below link...Welcome your feedback on any corrections or additions...

http://cid-8092d81ddc784c66.skydrive.live.com/browse.aspx/Configuration%20Manager%202007%20|5SCCM|6

Thanks

Shaminda

Reply:

Gee, a lot like http://technet.microsoft.com/en-us/library/bb633203.aspx, but with pictures!

 

 

------------------------------------

BizTalk - Data-driven application host server (?)

Now the BizTalk is recognized and advertized mostly as an Integration server.

 

There is an architectural pattern for using BizTalk. It is used:
* as an integration engine, as an integration layer between applications (usually and as a data transformation layer);
* for the workflow applications (including the long-running workflows);
* as a host for Business Rule Engine applications.

I think the BizTalk Server is more then that.
 
Let's think of BizTalk Server as a generic Application Server.
Now we have the Windows Server OS as an Application Server. We have the IIS as the Application Server.
Windows can host the standalone applications and Windows service applications. We can start the applications by hand, schedule its start by the Scheduled Task utility, setup the special developed applications as the Windows Services.
IIS hosts the Web applications.
 
Let's look at the BizTalk Server as a generic Application Server. Application Server for our usual standalone applications.

The .NET applications can easily start from the Expression shape of the simple Orchestration. There is little redundancy in development.

What the advantages we have using the BizTalk as an Application Server for standalone applications?
 
Data-driven applications:
Somewhere in the system the data appears. It can be a new file copied in a folder, new file received by FTP, new data in SQL database, new messages in the message queue, new data in the SAP/R3 application, new e-mail. Those data triggered the BizTalk application.
Data is appeared and this starts the appropriate application.
Say a hundred new files appears in the folder (or a hundred rows appeared in the SQL database). And this starts a hundred appropriated applications to concurrently process this data.
This is not easy to implement this data-driven application management in the usual standalone application.
BizTalk implements many transport and application adapters to transfer data to/from BizTalk applications, like File, FTP, MSMQ, SAP/R3, JD Edwards, etc.
 
Long-running applications; data correlations:
Say our application sent data to the remote partner then after several minutes or days the partner modified data and sent it back.  How can we facilitate the application to wait this response? How can the application survive the server restarts? How can we facilitate the situation when thousand applications are waiting the  responses and flooding the server memory? How can we correlate the response data with appropriate application?
BizTalk by design works all these cases.
 
Scaling up and scaling out:
Having BizTalk as an Application Server the developers can redesign the architecture from big, monolithic application to the small, isolated business-unit application set. BizTalk helps to transfer data between those small applications, helps to correlate data. This ways to high scalable application. Moreover the BizTalk has the intrinsic functionality to manage the high availability and high performance requirements by the special host mechanism.
 
Yes, it's true that the data-driven applications get the well-organized data which definitely is the output from other applications. Is that mean we've returned to the point where we have gone because it means the old paradigm, the integration level where the BizTalk always was positioned?
The integration tool is the intermediate level tool. It is not the self-independent tool.
But seems the BizTalk is the self-independent Application Server for our usual standalone applications.

  
Regards,

OpsMgr SP1 RC (ROM)

 

Hi all,

 

I've just had a look at the release notes etc. for SP1 RC, and was wondering about any possible caveats in upgrading the RMS to SP1, given the fact that the SCE servers in gateway mode will be pre-SP1?  I'll post in the SCE NG regarding SP1 for SCE...

 

Thanks,

 

Eugene

Reply:

 

Hi Eugene,

 

Just found you have another duplicated issue posted at "System Center Essentials - General" :

 

OpsMgrSP1 RC?

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2373488&SiteID=17

 

Therefore, I will mark this thread and lock it. Thank you.

 

At the same time, here is a RMS related document for your reference:

 

Microsoft's Remote Managed Services Solution for Partners

http://download.microsoft.com/download/d/c/f/dcfdca55-1316-4ebb-8dd1-901cf73e7533/managed%20services%20overview(v3).doc

 

 

Sincerely,

Robbin Meng

Microsoft Online Community Support

 

------------------------------------
Reply:

 

Thanks. That seems to have answered the SCE issue, what I am still worried about is the impact of SP1 RC on a ROM env, such as what we have setup at the moment.

 

If we cannot upgrade SCE to SP1, then I assume asap we need to upgrade the OpsMgr gateway servers we have downstream?

 

(I realise this is not for a production env as yet, but need to plan ahead)

 

E

------------------------------------
Reply:

Hello Eugene,

 

So far, I have not been confirmed that SCE in "Service Provider" mode will be OK with the RMS running SP1 RC or eventually SP1 RTMv version. I am still researching on this issue.

 

Regarding upgrading SCE to SP1, personally, I think SCE SP1 should be released in the first half of year 2008. So far, we have not the list of the hotfixes which will be included into SP1. Also, I agree that we test SP1 in your test computers first, not for a production environment.

 

Thanks again.

Sincerely,
Robbin Meng
Microsoft Online Community Support

 

------------------------------------
Reply:

 

Thanks for the reply!

I would appreciate some feedback on the "SP" mode compatibility (don't mind testing it, but if I can save a few hours that would be welcome!). It is in any case something I imagine the ROM team would need to clarify, as there are partners like is deploying in increasing numbers.

 

Regards,

 

Eugene

------------------------------------
Reply:

Hi Eugene，

 

Regarding the compatibility of incoming SP1, this issue is still under research and discussion. I will keep you updated on this thread.

At the same time, if you have any feedback, please feel free to share it with us here. Thanks again for your time and efforts.

 

Sincerely,

Robbin Meng

Microsoft Online Community Support

------------------------------------

please help me in terminal service in windows vista ultimate

 

dear all,

 

 i have one vista ultimate pc and number of vista business pcs, now i can't access one server from my pc but i can access other servers and vista business pcs can access all server .

 

can any one help me??

 

thanks,

Reply:

Hi,
 
From your post, I understand that a Vista ultimate machine cannot terminal to a specific server (we call it "fail" server.).

To further analysis the issue, please help to confirm the following points: 

1. Is it a domain or workgroup environment?
2. Is there any differences between the "work" servers and "fail" server? Such as the OS version, network segment.
3. Is the "fail" server running Application Mode or Remote Administrative mode?
4. Please capture the error message to me when the Vista ultimate machine cannot terminal to the "fail" server.

Sincerely,

 

Joson Zhou

Microsoft Online Community Support

 

------------------------------------
Reply:

 

Hi,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

 

Sincerely,

Joson Zhou

Microsoft Online Community Support

------------------------------------

network problem

 

my computer cant connect to another computer in our house the other computer can access this one but this just comes up with network diagnostics which doesnt know wots wrong trying to have a battle on starcraft

Reply:

Hi Sativa,

 

Please understand that we have not enough information about how starcraft works, but I will try my best to check if it is a networking issue.

 

Before we go further, I would like to confirm the following points with you:

1.    Are all computers running Windows Vista?

2.    Can the problematic computer access share folder on the other computers?

3.    Does it work if you turn off the firewall on all computers?

 

Sincerely,

 

Joson Zhou

Microsoft Online Community Support

 

------------------------------------
Reply:

Hi Sativa,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

 

Sincerely,

Joson Zhou

Microsoft Online Community Support

 

------------------------------------

Windows Vista laptop and 2000 Server Environment

I got a new Vista Business laptop and am trying to add a network share to the Windows 2000 domain cotroller.  I enter the path to the resources and click connect, but have no luck seeing the 2000 server.  I can ping the domain controller.  When I try to add this to the domain, it can't find the DC either.  Is there anything special I need to do for Vista to talk to 2000 server?

Any ideas?

Thanks,

Dirk

Reply:

 

Hi Dirk,

 

Do you mean there is a share folder but it fails to add to the Windows 2000 Active Directory? Or there is share folder on Windows 2000 Domain Controller, but it fails to be accessed on the Vista laptop?

 

For further analysis, please provide the following information:

 

1. Does the Vista join the domain?
2. Is the Vista using wireless or wired network to connect DC?

  

Sincerely,

 

Joson Zhou

Microsoft Online Community Support

------------------------------------
Reply:

Hi Dirk,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

 

Sincerely,

 

Joson Zhou

Microsoft Online Community Support

------------------------------------

Remote Console logon Failure

 

Having trouble logging in remotely using the SCE console.  I think the reason is the same as the reporting issue fixed in the hotrollup.

 

The computer on which you try to install Essentials 2007 has a NetBIOS domain name that does not match the first part of the FQDN of the domain. For example, the NetBIOS domain name is CONTOSO-XYZ. However, the domain is named contoso.com instead of contoso-xyz.com.

 

Now the HotRollUp fix fixed the installation on the server.  I don't want to sit in the server room in the cold but would rather use the SCE console on my laptop at the comfort of my desk, it installs ok, but I cannot connect to the server as it doesn't like my credentials.  The domain is setup as above which I think is the issue.

 

I cannot run the hotrollup on the client as it says SCE is not installed, anyone else come across this?

 

Reply:

 

The remote console does not require any hotfix.

 

Please validate that the certificates from the SCE Server install directory "Certificates" folder have been imported to the Trusted Root Authorities store on the remote UI machine.  Also, the WSUSCodeSigningCert.cer should be imported to the Third Party Publishers and Third Party Trusted Root authorities stores.

 

Also, ensure you give the FQDN of the SCE Server when trying to connect to the remote machine, and you are logged in as a user which is an administrator on the SCE server.

 

If this still fails, please post the error the console gives in this thread to help narrow the problem.

------------------------------------
Reply:

Still no luck where can I dump some screen shots?

------------------------------------
Reply:

Please use the following post to send info to the SCE team for review:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1680389&SiteID=17

 

Also, if the console is giving an error message that expands, you should be able to copy the internal text and post it here.

------------------------------------
Reply:

Hi Richard,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!
-----------------------------
Sincerely,
Guozhen Wang
Microsoft Online Community Support

------------------------------------

Microsoft Deployment - Replaces BDD 2007

For those who do not know, BDD 2007 has been replaced/updated with Windows Deployment.

It is similar to BDD 2007, but upgraded with additional features and more in line with Enterprise deployment tools from MS.

 

Download it Here

 

 

Ideas

I have noticede that pople are stating tu use the server O/S as a personal sistem instead of the original products designed for their PC. Because of that I have been thinking that the self upgrade and update of their sistems should be more friendly. For example:

People that have two different internet providers have trouble seting up bridges betwen multiple LAN conecctions,  as well as creating multiple conecctions between two or more computers. Creating utilitary programs for such porpouses might be a good idea.
Something else that has come to my attention is that in small enerpricess when there is a sistem failure to restore it takes longer than it could. All recent sistems have backups for restoring the operation sistem When it would be easier to have a full sistem back up that restarts inmediatly the O/S from  a  diferent  location or hardware. It is easier to start working with the same software with the same actualizations than to restore the old one. To have an executable back up sistem that is totaly independent from the data back up might create a solution even for individul users.
Whith the constant increase of new and better hardware and requirements of softwares to work properly a future solution might be to see a CPU as a single componento of a larger computer. A cheaper solution for the future is not only to increase the performance of the computers by updating the hard ware only. By findig a way to easily fusion more than one CPU for a single program...
The TCP/IP protocols and setings should be something that can be individulay modified, I mean even to the point of modifying the registry values.
(if some one reads this please understand that spanish is my native lenguage) And now that is night time I have to stop day dreaming. Thank You.
 

NOLOCK/ROWLOCK (good or bad guys?)

Reading about avoiding deadlocks in SQL, I have found different opnions about whether using or not NOLOCK/ROWLOCK hints on SELECT/UPDATE/DELETE statements. I have several applications executing transactions on the same databases and tables, including inserts, updates and deletes. I wonder if by using NOLOCK/ROWLOCK I could decrease the chances of having deadlocks. At least using ROWLOCK on my update statements?.  I just need some advice here.

 

Regards.

 

 

Reply:

Well, the advice kind of depends on the need and type of environment you are working in.  You would want to utilize locks if Dirty Reads are absolutely unacceptable, but remember that if you are utilizing a lock on an update that you are actually putting 2 locks in place, one for the delete and another for the insert.  Utilizing rowlocks can help preserve data integrity, but can also cost data access, and the wrong implementation can easily cause Deadlocks, which is what it seems you are trying to prevent.

 

-Jay Soares

------------------------------------
Reply:

A lot depends on why you are having deadlocks.  Rowlock is almost certainly going to do the same things as you are seeing now.  Nolock is just insane in my mind, unless the data is just for a quick overview.  Reading in dirty data as good data makes your programs far less supportable.

 

I don't know your skill level, so this may seem condescending, so forgive me, but before applying real brain power to a broad problem like this, there are a few things to ask:

 

1.  Do your UPDATE and DELETE statements work of Primary or Unique constraints?  Or at the very least well indexed columns, if doing multiple rows?  If the statement doesn't use an index, it will do a table scan, locking more of the table than you probabably want (even the entire table.)  Rowlock would possibly help here, but it would essentially just take longer.

 

2.  How many concurrent users are we talking about.  A few, or hundreds? 

 

3.  How many statements are usually involved in your transactions that deadlock?  Single statements?  Or multiples in a transaction?

 

Once you have done all that you can to avoid deadlocks, the best thing to do is to handle them, by having the application "try again" when that error message is seen.  If you have your calls neatly tied up in transactions, this is easy.  If you are doing multiple statements outside of a transaction, it can be less easy.  But in each case, if you can isolate the transaction that deadlocked, retrying should be easy enough.

------------------------------------

Thanks

Thank You So Much I Was Thinking Of That To

Printer attached to print server

 

Hello,

 

I am currently having a problem getting a printer to work on a machine that I've installed Windows SteadyState on.

 

• I've installed SteadyState on a machine that logs into itself (not a domain). 
• The printer that I wish to map to has a static IP and is managed through a print server that is on our domain. 
• I have mapped to the printer using \\print_server_name\printer_name and printed a test page which worked.
• After ensuring the printer was configured I began to configure the SteadyState restrictions.
  • I've left the Prevent users from add / remove printers option unchecked.
  • I've also left the Remove printers icon unchecked
• When I enable the SteadyState settings I am unable to print and I receive an error message basically telling me that it is having issues finding the printer. 

Is there a setting somewhere that I've over looked?  If anyone has any ideas or requires further information I'd be pleased to hear / provide any additional details.

 

Chris Maddeaux

Reply:

Hi Chris,

 

First of all, please let me know the exact error message and the background infomation if there is.

 

I suggest we change the restriction level of SteadyState to check this issue: Firstly, you can create a new user profile with "No restrictions". If you can print, we can change its level to "Low restrictions"

 

…

 

Until the issue reoccurs, we can compare the differences between two levels and find the root cause gradually.

 

Best Regards,

------------------------------------
Reply:

Hello and sorry for the delay in responding. 

 

The error is as follows:

 

Windows cannot print due to a problem with the current printer setup.

Try one or more of the following:

* Check the printer by printing a test page from Windows.

* Make sure the printer is turned on and online.

* Reinstall the printer driver.

I will reset the security settings and work my way up from low and see if the error still occurs.

------------------------------------
Reply:

Hi Chris,

 

Thank you for your feedback.

 

Usually, security warning/error will be received if the issue is caused by restrictions. Thus, the above error may not be caused by SteadyState. If the issue persists when No Restriction is configured, you may need to obtain further assistance from Windows XP Hardware newsgroup, or the Hardware manufacturer:

 

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.windowsxp.hardware

 

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other customers who read the newsgroups regularly can either share their knowledge or learn from your interaction with us.  Thank you for your understanding.

 

Regards,

------------------------------------

Server Manager update for WSUS 3.0 SP1 available for download

Server Manager is a new feature in Windows Server 2008 that guides administrators through the process of installing, configuring, and managing Windows Server 2008 roles and features. In addition to roles and features that are included with Windows Server 2008 by default, Server Manager enables integration of additional roles and features that are available on the Microsoft Download Center and Windows Update Web sites as optional updates to Windows Server 2008. One role that will be available as an update is Windows Server Update Services 3.0 Service Pack 1 (WSUS 3.0 SP1). An update will also be released that enables full integration of WSUS 3.0 SP1 into Server Manager. This update allows installation, configuration, and management of WSUS 3.0 SP1 by using the Server Manager console and wizards.

 

To test the Server Manager update and obtain customer feedback, Microsoft offers a four-week Beta program for this update, starting November 2, 2007 on the Microsoft Connect site. By participating in the Beta program, you have the opportunity to try the new WSUS 3.0 SP1 role with full Server Manager integration, and provide feedback directly to the Server Manager teams. If you are interested in participating, the download is available at http://connect.microsoft.com/windows/Downloads/DownloadDetails.aspx?DownloadID=9315. For more information or questions, please contact smcpe@microsoft.com.

Exposing a Connected Property on the Data View Web Part (DFWP) to pass in CAML Queries

Hey folks, I wrote up a little blog post on how to get properties into the SelectCommand on the SPDataSource in a data view web part.

The Data Form Web Part (called Data View in SharePoint Designer) is a very versatile web part. While offering an XSLT transform for layout purposes, there are various features such as sorting, filtering and paging. However, when it comes to content management, all of the configuration is in the page layout which requires interaction with SharePoint Designer. This makes it difficult for a content editor to configure things such as filtering from the browser.

 

However, using connections and filters can really enhance the data source of the Data Form Web Part. I've published a technique here that will help you either pass in variables for use in CAML queries in your Data Form Web Part or allow you to pass in entire CAML strings through web part connections!

 

Check it out here:

http://calehoopes.blogspot.com/2007/10/exposing-connected-property-on-data.html

Cale Hoopes
caleh@ascentium.com
http://calehoopes.blogspot.com

Configuring MOSS as a Search Appliance with Keywords and Best Bets against a non-MOSS source

Hey folks, I solved my problems around MOSS searching of a MCMS site with tuning using best bets and keywords. I posted my approach in my blog.

Hopefully it will help someone out!

http://calehoopes.blogspot.com/2007/11/configuring-moss-as-search-appliance.html

Enjoy!

Cale Hoopes
caleh@ascentium.com
http://calehoope.blogspot.com

Windows Explorer Stopped Working.

 

1.Restart the computer with safe mode with Command Prompt.

2.Open User Accounts Window using command "netplwiz".

3.Create new user account.

4.Then log into new user account.

5.Copy all the files from old user account to New user account.

6.Delete the old user account.

 

Issue is Fixed !!!!!!!!!!!!!!!!!!!!!!!

Health service host process error

Hi,

Since yesterday, I always get this error every minutes,

Health Service Host Prcess encountered a problem and needed to close.

This error occured on 11/5/2007 at 10:30:35 AM

Please tell SRV-SCE07_MG about this problem.
We have created an error report that you can send to help us improve
Health Service Host Process. We will treat this report as confidential and anonymous.

I try to find if some services are stop but everything run ok. On this server, I only have Win 2k3 std sp2, SCE 07 et SQL express 05.

It's an IBM X3205 with 4 Gb ram and 75 Gb HDD Raid 1.

Thx for your help !

David

Reply:

 

Would you check the Operations Manager Event Log on the affected host and let us know if you see any error messages there that may give us some insight into root cause?

------------------------------------
Reply:

i don't know if those information are ok....

OpsMgr Connector
Failed to store data in the Data Warehouse.
Exception 'SqlException': Sql execution failed. Error 777971002, Level 13, State 1, Procedure AemEventProcessStaging, Line 313, Message: Sql execution failed. Error 1205, Level 13, State 51, Procedure AemEventProcessStaging, Line 222, Message: Transaction (Process ID 117) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

One or more workflows were affected by this. 

Workflow name: Microsoft.SystemCenter.DataWarehouse.StandardDataSetMaintenance
Instance name: Client Monitoring data set
Instance ID: {1954C50F-063E-ED80-9037-A11D009788A2}
Management group: SRV-SCE07_MG

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

HealthService
The constructor for the managed module type "Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.GroupCalculationModule" threw an exception. This module was running in rule "Microsoft.SystemCenter.WindowsComputer.IPSubnet.PopulateGroup" running for instance "127.0.0.0" with id:"{A1BD10CC-9996-26E1-65A0-8215A58F5B2B}" in management group "SRV-SCE07_MG".  The exception text is: Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.InvalidDatabaseQueryModuleConfigurationException: RelationshipTypeId = 6068f699-56a0-8ce1-f625-701a148a219b
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipSubscription.ValidateRelationshipType(Guid relationshipTypeId, Guid sourceManagedTypeId, Guid targetManagedTypeId)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipSubscription.Create(IXPathNavigable configurationXml, RelationshipQueryResultMethod relationshipQueryResultMethod, NotifyFatalErrorMethod notifyFatalErrorMethod)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.GroupCalculationModule..ctor(ModuleHost`1 moduleHost, XmlReader configuration, Byte[] previousState)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

------------------------------------
Reply:

Hi,

 

I had performed some search on the event logs which you mentioned in your previous post. And it seems not related to health service failure.

 

So could you please help to save the Operations Manager section to *.evt files and capture screen shots of the related symptoms( the "Health Service Host Prcess encountered a problem and needed to close" error message), then send them to scedata@microsoft.com .

 

Note:

Please include the following three lines in the email body:

 

Health service host process error
http://forums.microsoft.com/TechNet/ShowPost.aspx?postid=2371907&siteid=17
Guo-zhen Wang - MSFT

 

Regarding more information about how to send email to SCEDATA@microsoft.com, please refer to:

 

How to send files to the Microsoft SCE team for review
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1680389&SiteID=17

 

Post a quick note in the current thread after sending the email.

 

Thanks!
-----------------------------
Sincerely,
Guozhen Wang
Microsoft Online Community Support

------------------------------------
Reply:

Hi,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!
-----------------------------
Sincerely,
Guozhen Wang
Microsoft Online Community Support

 

------------------------------------

SQL Server 2008 November CTP released

SQL Server 2008 November CTP released.

 

This is one of most significant public Community Technology Preview (CTP) releases for SQL Server 2008.

 

You can download it from.

http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en

 

Short list of the new features https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7003

 

Please make sure you take a look at the Readme to avoid any known problems.

http://go.microsoft.com/fwlink/?LinkId=94485

 

You can post CTP comments, questions on Katmai Analysis Services MSDN forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1615&SiteID=1. Or just post it here if you feel like it.

 

 

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

 

 

SQL Express 2008 November CTP - Come and get it

 

I've posted the pertinent links in the blog at http://blogs.msdn.com/sqlexpress/archive/2007/11/19/what-s-new-in-sql-express-2008-november-ctp.aspx.

 

Regards,

Mike Wachal

SQL Express team

SQL Server 2008 November CTP now available

 

Pertinent links are in the blog: http://blogs.msdn.com/sqlexpress/archive/2007/11/19/what-s-new-in-sql-express-2008-november-ctp.aspx

 

Regards,

Mike Wachal

SQL Express team

driver JDBC

hi Mixxo,
I also am having this problem! if you get an solution,    
send me an answer or add my msn: griciolli@hotmail.com

BUG in KB941649: the return from sleep doesn't work properly, if the power goes off

BUG in KB941649: the return from sleep doesn't work properly, if the power goes off

After I installed this patch KB941649, the sleep doesn't work properly if the power goes off, i.e. the computer doesn't boot when the power return on.    Reproduction steps:  1. press the sleep button and wait until the computer gone to sleep  2. turn off the power  3. turn on the power  ... and the computer doesn't boot, it doesn't return from hibernation, you have to press the reset button in order to be executed the return from hibernation properly.

Without the patch, everything works fine.

User Configurations

 

Hi,

I just downloaded Windows SteadyState and i'm have a hard time configuring the right user configuration. Can anybody please help me or send me a user account file (*.ssu).

 

Thank You,

JoshM321

Reply:

Hi JoshM321,

 

What do you want in your shared user profile?

 

Have you tired different restriction levels? If none of them meet your requirements, please list them first. Otherwise, it's too obscure to provide suggestions.

 

Best Regards,

------------------------------------

The Wizard stole my IDENTITY

Being new to SQL, I started with the basics... using VS2005, it seemed easy enough. Not a single Sql statement was coded by me, but there I was addding, deleting, updating records like a pro. Relations here, bound objects there, The Wizard was my friend. Then I asked him for what I thought was a very simple request: Can I have my @@IDENTITY please? The Wizard grew angry, and hurled error after error at me, null objects were exploding all around me, I tried to reason with him, offering CType's and Try/Catch's but to no avail. I had to seek help for this monster - one after another telling me to SELECT @@IDENTITY, SELECT SCOPE_IDENTITY, but I pleaded with them "I have for the love of god" everywhere possible (if you find yourself wanting to reply now - my answer is YES I tried that), but he would not reviel my identity... Until I took matters into my own hands....

Wizard Says:
Private Sub MarketLogFilesBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MarketLogFilesBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.MarketLogFilesBindingSource.EndEdit()
        Me.MarketLogFilesTableAdapter.Update(Me.EveMarketDBDataSet.MarketLogFiles)
 End Sub

I say:
Private Sub MarketLogFilesBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MarketLogFilesBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.MarketLogFilesBindingSource.EndEdit()
        Dim command As New SqlClient.SqlCommand("SELECT @@IDENTITY", Me.MarketLogFilesTableAdapter.Connection)
        Me.MarketLogFilesTableAdapter.Connection.Open()
        Me.MarketLogFilesTableAdapter.Update(Me.EveMarketDBDataSet.MarketLogFiles)
        Dim i As Integer = CType(command.ExecuteScalar(), Integer)
        Me.MarketLogFilesTableAdapter.Connection.Close()
End Sub

Though this code may be totally wrong, it works. I spent many hours  trying to find a way that didn't involve me writing my own Update commands, or more to the point, I was sure that such a simple task as retriving the last PK of record had to be in the wizards head somewhere. I am sure there is a simple way to do it, that I have so clearly missed, but for those of you who rely on the wizard, the above at least got me one step closer. It seem's in the auto-gen code, the connection is closed after the update command IF the connection was closed BEFORE the update command was issued.

IF ANYONE CAN FIND ME DOCUMENTATION ON THAT FACT, I WILL GIVE YOU ONE MILLION....
Thanks guys, keep up the great work, I love these forums - inspiration and knowledge -

Reply:

Okay, it looks like there are some misunderstandings here. I'm not sure you understand that the @@Identity value is generated on the server AFTER the TSQL UPDATE is execute. EndEdit simply posts the changes from the bound control to the underlying DataTable, it does not call the TableAdapter (or DataAdapter) Update method. If you choose to take this route you need to ask for the @@Identity (actually SCOPE_IDENTITY() is better) AFTER callin the Update method.

 

Take a look at my website.http://www.betav.com/Files/Content/whitepapers.htm or my book for a detailed explaination of this strategy. I think there are still open seats for my workshop in Vancouver, BC on the 26th (www.devteach.com)

------------------------------------
Reply:

It can happen, but you missed a few things; 1) all code NOT in bold IS generated by the bound controls. 2) My command is BUILT before the Update call, but sent after. 3) The real point of the post was to point out the the Update method of the auto-gen code also closes the connection when it's done, making any attempt to *any*Identity fail. This is for people new to the wizard and sql - like myself who spent hours trying to figure it out

Thanks for your reply - and the whitepapers

------------------------------------

printer connection issues with windows XP and vista

 

 

I replaced my old main desktop PC with a new desktop with windows vista home premium, this unit has printer connected to it.  I have three PC's on my net work my office PC, kids PC, and my laptop.  Now the office PC is the new one with windows vista.  The laptop has widows vista also.  the kids PC has XP.  the network is set up and I can see all three pc's just fine and all computers.  trnasfer files between them with no issues.   Working on setting up the network printer works fine on my two vista systems.  On my XP unit i can't even see the printer tried adding network printer it see's my systems but no options for printers.  I installed that LLTD Hotfix with no luck.  Also, my network is a wifi network.

 

Thanks Leon 

BUG in KB941649: the return from sleep doesn't work properly, if the power goes off

 

After I installed this patch KB941649, the sleep doesn't work properly if the power goes off, i.e. the computer doesn't boot when the power return on.    Reproduction steps:  1. press the sleep button and wait until the computer gone to sleep  2. turn off the power  3. turn on the power  ... and the computer doesn't boot, it doesn't return from hibernation, you have to press the reset button in order to be executed the return from hibernation properly.

Without the patch, everything works fine.

Error 0x800705AD "Insufficient quota to complete the requested service." *PROBLEM SOLVED*

 

I see others have had this same problem and it's been know for almost this whole year. You can see my resolution here...

 

I'd be interested to know if this solves the problem for you or no.

 

Thanks,

 

Tom.

BIDSHelper v1.2 released - now with SSIS features

The BIDSHelper team are please to announce that we have just release v1.2 which includes a number of new SSIS features. BIDSHelper is a free add-in for the BI Development Studio that adds a number of useful features.

 

www.codeplex.com/bidshelper

 

For any current users of BIDS Helper, you can see a list of the new features on the download page for this release

http://www.codeplex.com/bidshelper/Release/ProjectReleases.aspx

Accessing SPS2003 User's Database

Code Block

Public Sub ShowGroupsByUser(ByVal LoginName As String)

 

Dim oConn As SqlConnection = New SqlConnection(_SPSconnString), oCmd As SqlCommand = New SqlCommand
     
            oConn.Open()
            oCmd.Connection = oConn ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
            oCmd.CommandText = "SELECT 'Web'= (Select[Title]From Webs where ID = A.[WebID])FROM [WebGroupMembership]A, [WebGroups]B WHERE  [Title] = 'Administrator' And A.GroupID = B.ID AND A.WEBID = B.WEBID AND [MemberID] =(SELECT [tp_id]FROM [UserInfo] WHERE [tp_Login]='" & LoginName & "')"
            Dim oDR As SqlDataReader
            oDR = oCmd.ExecuteReader

 

While oDR.Read()

GroupName = oDR(0).ToString

 End While

 End Sub

 

 

Code Block

Private Function sIsSiteAdmin(ByVal LogIn As String) As Boolean
        Dim oConn As SqlConnection = New SqlConnection(_SPSconnString), oCmd As SqlCommand = New SqlCommand
        Dim oDR As SqlDataReader
        Dim SQLSTR As String
        oConn.Open() : oCmd.Connection = oConn
        SQLSTR = "SELECT tp_siteadmin FROM [UserInfo]WHERE [tp_Login]='" & LogIn & "'"
        oCmd.CommandText = SQLSTR
        Return oCmd.ExecuteScalar

    End Function

 

 

Code Block

Public Function GetGroupsByUser() As Boolean

Dim SPS_Conn As SqlConnection = New SqlConnection(_SPSconnString), SPSCmd As SqlCommand = New SqlCommand
            SPS_Conn.Open()
            SPSCmd.Connection = SPS_Conn ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
            If IsSiteAdmin = True Then
                SPSCmd.CommandText = "SELECT distinct 'Web'= (Select[Title]From Webs where ID = A.[WebID])" & _
                                    " FROM [WebGroupMembership]A"
            Else
                SPSCmd.CommandText = "SELECT 'Web'= (Select[Title]From Webs where ID = A.[WebID])FROM [WebGroupMembership]A, [WebGroups]B " & _
                                            "WHERE  [Title] = 'Administrator' And A.GroupID = B.ID AND A.WEBID = B.WEBID AND [MemberID] =(SELECT [tp_id]FROM [UserInfo] WHERE [tp_Login]='" & AUTH_USER & "')"
            End If

            oDR = SPSCmd.ExecuteReader

            While oDR.Read()
                Dim GroupName As String = oDR(0).ToString

 

Dim oDR1 As SqlDataReader
                    Dim SPS_Conn1 As SqlConnection = New SqlConnection(_SPSconnString), SPSCmd2 As SqlCommand = New SqlCommand
                 SPS_Conn1.Open()
                 SPSCmd2.Connection = SPS_Conn1 ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
                 SPSCmd2.CommandText = "SELECT [tp_Title],[tp_email]FROM [WebGroupMembership]A,[UserInfo] B " & _
                  " Where [tp_id]=[MemberID]And [WebID] = (Select [Id]From [Webs] where [Title] ='" & GroupName & "')"
                    oDR1 = SPSCmd2.ExecuteReader
                    While oDR1.Read()
                        Name = oDR1(0).ToString
                        Name = Name.Replace("'", "''")
                        Email = oDR1(1).ToString

 

         Dim oConn1 As SqlConnection = New SqlConnection(_connString), oCmd1 As SqlCommand = New SqlCommand
                        ' Response.Write("User:" + Name + " --- " + Email + "
")
                        Name = Name.Replace("'", "''")
                        oConn1.Open() : oCmd1.Connection = oConn1
                        SQLSTR = "INSERT INTO [Recipient]([Email],[FirstName],[BodyFormat])" & _
                                    " VALUES('" & Email & "', " & _
                                    "'" & Name & "', " & _
                                    "'" & "1" & "')"
                        oCmd1.CommandText = SQLSTR
                        oCmd1.ExecuteNonQuery()
                        oConn1.Close()
                    End While

End Function

 

 

Code Block

Private Sub AddAdminUsersToList()
        Dim Name, Email, SQLSTR As String
        Dim SPS_Conn As SqlConnection = New SqlConnection(_SPSconnString), SPSCmd As SqlCommand = New SqlCommand
        Dim oDR As SqlDataReader
        SPS_Conn.Open()
        SPSCmd.Connection = SPS_Conn ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
        SPSCmd.CommandText = "SELECT [tp_Title],[tp_email] FROM [UserInfo] B Where tp_siteadmin=1"
        Try
            oDR = SPSCmd.ExecuteReader
            While oDR.Read()
                Name = oDR(0).ToString
                Name = Name.Replace("'", "''")
                Email = oDR(1).ToString

                Dim oConn1 As SqlConnection = New SqlConnection(_connString), oCmd1 As SqlCommand = New SqlCommand
                ' Response.Write("User:" + Name + " --- " + Email + "<br>")
                Name = Name.Replace("'", "''")
                oConn1.Open() : oCmd1.Connection = oConn1
                SQLSTR = "INSERT INTO [Recipient]([Email],[FirstName],[BodyFormat])" & _
                            " VALUES('" & Email & "', " & _
                            "'" & Name & "', " & _
                            "'" & "1" & "')"
                oCmd1.CommandText = SQLSTR
                oCmd1.ExecuteNonQuery()
                oConn1.Close()
            End While
        Catch ex As Exception
            Response.Write(ex.Message.Replace("<", "["))
        Finally

        End Try
    End Sub

 

 

 

 

Exstanding SCE 2007 functionality

 

Hello

 

on the sce management server we can see all softwares running of the managed client systems. But we can't see graphical topology stracture of all softwares and data files of managed client systems on the sce management server.

 

for eample, we develope a tool which can display graphical topology stracture of all softwares and data files of managed client systems.

 

combining both (SCE 2007 and our own tool) the functionality of sce can exstand to meet our requirements.

 

Is it possible to do like this? 

 

or

 

Any other ideas?

 

 

 

any help will be appr.... and txs...

Reply:

Hi,

 

Currently, we can view all installed software of clients via "Software Inventory" in "Essentials Reports" item under Reporting tab on SCE console. For now, SCE server does not provide the graphical topology function of all software and data files of managed clients on the SCE server console, this is by design.

 

Regarding if it is possible to develop a tool which can display graphical topology structure of all software and data files of managed client systems, I am not sure about that so far. And now, I am forwarding your comments to our related team to check if it be done.

 

I will keep you updated here. Thanks for your time and patience.

 

If there is anything unclear, feel free to let me know.

 

Sincerely,

Robbin Meng

Microsoft Online Community Support

------------------------------------
Reply:

Hi Robin,

 

Thanks for your reply.

 

 

I have a few more questions.

 

1. Graphical topology:   In SCCM 2007 Forum, community support team told me that this is possible using sccm with sdk (need to write some scripting). Is there any thing similar way or some thing....?

2. Is there a way to change parameter values in a xml files of managed clients from SCE server?

3. lets assume that, a parameter value in xml file is R = 1200,  unfortunately me or someone changed this value to  1300.  in this case i would like to receive a error report about this issue. How do i make it possible by using Management Packs or any recommandations?  Deatailed explanation please

 

thanks a lot in advance

 

------------------------------------
Reply:

 

Hi atmakuri,

Regarding the Graphical topology, please understand SCE 2007 is very different from SCCM 2007 and the monitoring function also diverse. Currently, I still cannot make sure if it is possible to create such a Graphical topology, may be it will be added in the next version or Service Pack.

 

Regarding the 2 and 3 questions, I am sorry to say we cannot modify the .xml from the client or server. The .xml is only a query result file that generated by the SEC server MP. Modify the .XML file will not affect the monitoring status of agent computer. Therefore, it does not make sense to modify the XML file.

 

For your reference, here is an MP related site:

 

Sample Management Packs 
http://www.authormps.com/dnn/Samples/tabid/56/Default.aspx

Sincerely,
Robbin Meng
Microsoft Online Community Support

------------------------------------
Reply:

Hi Robbin,

 

 

thanks a lot for ur response

------------------------------------

Is Microsoft going to include KB940287 in a Cumulative Update?

Re: KB 940287 - Will it be in a Cumulative Update?

SYMPTOMS:

You use Service Broker in SQL Server 2005. When the initiating service starts a conversation and then sends a message, the initiating service ends the conversation immediately. However, after the target service processes the message, the endpoint on the target server is not deleted when the target service ends the conversation. Therefore, when the initiating service starts a new conversation, the number of the conversation endpoints on the target server keeps increasing.

 

Additionally, you receive the following error message on the initiator server:

An error occurred while receiving data: '64(The specified network name is no longer available.)'
This message could not be delivered because the conversation endpoint has already been closed.

 

 

 

It has several workarounds. I've not been affected by this yet, but KB says it has a hotfix that has been out since July 2007, so it is curious that it has not been put into a Cumulative Update yet, at least as far as documentation in Knowledge Base is concerned. Does anyone know any more about this?

 

Paul

Reply:

This has shipped in CU3, see http://blogs.msdn.com/remusrusanu/archive/2007/08/21/service-broker-leaked-target-conversation-endpoints-fix-ships-in-cumulative-update-for-sql-server-2005-sp2.aspx

------------------------------------

BizTalk Server Enhancement Request/Suggestion

The ability to add Pre-Build and Post-Build Events to BizTalk projects would be much appreciated.

InteractiveHeight in report

I want to report a bug in CTP SQL2008 (SSRS).

I did the DAT87-HOL Authoring Reports Using SQL Server 2008 Reporting Services lab during the IT Forum in Barcelona and found out that the putting the interactiveheight property of the report could not be set to 0 to enable soft page breaks. This worked well in SSRS 2005.

Reply:

Hi Bugs

 

To be clear, setting InteractiveHeight to 0 will "disable" soft page breaks, not enable them.  This is a scenario that should continue to work in SSRS 2008 as it did in previous versions.  I was able to reproduce the problem in an in-house build of Report Designer.  I have filed a bug on your behalf to get this fixed.

 

Many thanks,

Chris B.

 

 

------------------------------------
Reply:

For future reference, the best way to report bugs is via the MSConnect site, http://connect.microsoft.com. These go directly into our bug database.

------------------------------------

Windows Vista IE

I think the guy is saying "Had same trouble until I removed kb885523 t.v media adware, you can also try kb886590 t.v media removal tool...hope it helps you."

 

Anyway, I'm having a similair problem aswell and I've looked into those TV things and have found this I've not actually read through it myself but plan on doing so! Sorry I can't be of much help but I've only just found the problem occuring. When I fix mine I'll let you know what I did

unwillingness to resolve the issues or concerns at large

I find it distressing, that there are probably thousands of end users in the field experiencing the same issues as noted here, and that only a tiny percentage are aware of forums like this to seek answers and comparative views from others in the same scenario.  Microsoft should address in its earliest state without waiting to see an industry wide failure before they react.

Reply:

Dear GlobalGood,

 

Thank you for your feedback. Could you please let me know your concern? I will do my best to address it.

 

If you are talking about the Network List Service issue, please understand that we are always following it up. I know that it is time consuming, but please understand the issue is related to third party product, I am doing my best to reproduce, test and trace the issue and trying to resolve it on our site. However, it still cannot be reproduced in my testing environment until now. As a result, I need your help to test and collect information so that we can identify the cause of the issue in a timely manner.

 

In addition, according to tims10000's update in your thread, there may be an update from AOL which can fix the issue. Please update the AIM and check if the issue can be resolved. 

 

Sincerely,

Joson Zhou

Microsoft Online Community Support

 

------------------------------------

MOSS User Profile Import - Why can't I find Distribution Lists? Why is my AD Import failing?

User Profile Import can be incorrect out of the box. Why? Because of the way they assume the domain name.

Check out my posting on this on my blog:

http://calehoopes.blogspot.com/2007/11/moss-user-profile-import-why-can-i-find.html

This posting will talk about why you need to do an import before being able to use Distribution Lists with Audiences and how your User Profile Import could be failing because of the nature of your active directory domain name.

Enjoy!

Cale Hoopes
caleh@ascentium.com
http://calehoopes.blogspot.com

Accumulating messages in MessageBox, Lifespan of the messages

http://geekswithblogs.net/LeonidGaneline/archive/2007/11/14/116853.aspx

 

 

I hit this problem when were creating the orchestration to periodically poll the outer service. The orchestration was with loop inside.

The problem was I created the message inside this loop. And the instance of this message were not disposed after each cycle. The BizTalk does not have such functionality as explicit deleting the messages inside orchestration.

The orchestration was created for running long time without restart. That means that this orchestration was collecting enormous amount those indisposed messages. And all those messages were inside the MessageBox, of course. It was wrong!

 

After long and very interesting investigation the issue was resolved.

 

The source of the problem was in the transactional scope where I created the indisposable message. This scope was inside the loop. The message was recreated on each cycle of the loop.

It is interesting but a lifespan of the message recreated inside the transactional scope included in the loop and the message recreated outside the  transactional scope in the loop is different. The first one is disposed only after closing the orchestration instance. The second one is disposed after last using. (I think so but could not find a hint in the BizTalk information sea.)

 

After discovering this the fix was simple. I moved the transaction scope outside of the loop.