Tuesday, March 1, 2022

Windows XP clients are unable to talk to an application on Windows 2008 Server

We recently did an Domain and Forest Function Level upgrade from Windows 2003 mix environment to Windows 2008 R2. Since the upgrade the XP client application is unable to connect to the server application the Windows 2008 Server, error message on the server :

Could not connect to DMOutlook: HRESULT = 80070721

FACILITY = FACILITY_WIN32

RPC_S_SEC_PKG_ERROR

A security package specific error occurred.

If we try connecting using a Windows 7 client everything works fine, I also build and Windows 2003 Server and installed the application on it and it works fine. Please help!

Changed type WINSCRIPT Friday, March 2, 2012 7:01 PM

Reply:

Hi,

You posted the question in te wrong forum. This forum is only for Exchange related questions. You could try the Active Directory forum which can be found here: http://social.technet.microsoft.com/Forums/en-us/winserverDS/threads

Regards,

Bart Timmermans

KPN Consulting - Technical Consultant www.bart-timmermans.nl Mark as Answer, if it is answer for your Question. Vote as Helpful, if it is helpful to you.

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

Thank you

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

Need it be this hard?

I have been to the Microsoft Answers site and it is a nightmare over there. I must say I don't envy someone using W8 for the first time. Even so, my installation was not without incident. Try to install and I get "Set up was unable to use the existing partition because it does not contain the required free space". This is when using a freshly formatted 500 Gb drive. Ok, so it's not the install drive that is the problem but the existing W7 System Reserved partition that is too small so that was extended.

I try again and all goes well until suddenly presented with a black screen and a mouse pointer with nothing happening. I turn the second monitor on and hey presto there is the 'Personalise' screen - but no mouse. Get through this with just the keyboard and now I am ready to go.

The mouse, I found, goes off the left of the main monitor and reappears on the right monitor so adjustments are required, but where is the Control Panel. Hidden away in the depths of metro. Any way, it has now been pinned to the taskbar. The drive has been partitioned and user folders redirected to the new partition.

Obviously some work to do yet before W8 is ready for business and a baseline disc image obtained.

Reply:

The only real Problem I see is the not visible mouse.

For the Partition if it is too smal it's too small. But I actually wonder why this did happen to you mine was big enough. I did a upgrade installation.

If I read you right you actually did a fresh install? If that's the case I wonder why it insisted to use your old existing Windows 7 Partition. Doesn't really make sense to force you to use it and not creating it new.

For the screen, how should Windows now you turned the Primary Screen off?

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

When I initially installed the Developer Preview it did create it's own system reserved partition. The Consumer Preview did not. Looking at the W7 sysres partition, it was found to be only 94 Mb compared with the usual 100 Mb so that may have been the cause of the problem.

The monitor connection largely defines which is the default. I have VGA, DVI and HDMI outputs. When I first connected dual monitors (with W7) the main monitor was DVI and the second monitor VGA. What happened was the 2nd monitor assumed the role of default at bootup. The 2nd monitor was changed to HDMI and the main monitor is then the default. So I install W8 and everything is displayed on the main monitor up to the point when W8 is actually opened and then the display shifts to the 2nd monitor. The fault can only be incorrect default 'Display' settings in Control Panel. I am not the only one to have seen this. Many others, including laptop owners, have as well but without another monitor attached have not known what is going on.

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

Ok thanks for the additional Information Makes more sence now.
Wonder why your win7 Partition was only 94 mb. Mine was 100 and I never noticed a System with a smaller one.

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

Time was, you could set up the partitions yourself during installation... Where's that functionality? d r h should have been given the opportunity to wipe whatever partitions were already on the hard drive clean!

Does anyone else here get the impression that setup has been OVERsimplified?

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

Nowl, perhaps I should make it clear that for both the DP and CP I started with the drive cleared of all partitions and formatted.

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

Wow, so it created a partition then immediately reported it could not use it? That's even worse than what I thought you meant.

For what it's worth on a freshly created VM, here's the reserved partition it created for me - a whopping 350 MB. Note that it's used 119 MB of it up already.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

We use the system reserved partition for the boot folder and as an area to move the recovery WIM file in the event that you BitLocker the volume. When BitLockered, the BCD store needs to be readable so we can load the operating system. If you dont want this partition you can create a contiguous partition prior to install and we wont create anything new.

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

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

When I initially installed the Developer Preview it did create it's own system reserved partition. The Consumer Preview did not. Looking at the W7 sysres partition, it was found to be only 94 Mb compared with the usual 100 Mb so that may have been the cause of the problem.

There is still only the one sysres partition (created with W7) which I extended to 282 Mb. Now here is the funny thing. It only contains 80 Mb so why was it not large enough in the first place.

ADDED

Noel, have another look at your sysres. It has 119 Mb free and has used 231.

Edited by d r h Thursday, March 1, 2012 8:52 PM

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

CP should have made its own unless you already had a predefined partition. We'll honor existing disk layout. I'm not sure why you hit the issue you did though because I havent seen it. Your \Windows\Panther\setupact.log might tell us what happened though.

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

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

Hey there, drh, I'd love to know more about why you think Microsoft Answers is a nightmare. If you'd like to give some more specific feedback, please visit me in Answers Feedback forum.

Thanks,

EmilyF

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

CP should have made its own unless you already had a predefined partition. We'll honor existing disk layout. I'm not sure why you hit the issue you did though because I havent seen it. Your \Windows\Panther\setupact.log might tell us what happened though.

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

setupact is 367 Kb. How to I attach it.

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

I am on the desktop

I double click on a photo and it sends me to Metro showing the photo and nothing else. What can I do with it.

I want some background music while multitasking so double click on a track. Again I am in Metro.

Just how much do I have to reset to be able to work on the desktop.

Somehow Windows 7 looks like heaven.

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

You can put the log on a SkyDrive and send me a link for the log.

Metro style applications are full screen, that's why you're seeing the photo displayed as such.

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

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

Metro style applications are full screen, that's why you're seeing the photo displayed as such.

Joseph, first let me say that I for one really appreciate you being here - it shows you have an interest in Windows' future, and it's gratifying to know that we are being heard.

I honestly think d r h understands why he's seeing things full screen, but is really saying that full-screen just isn't appropriate for things like playing music while doing other work. Even a photo being viewed might not be wanted to take over the whole screen. In my image editing work I often want to look at several side by side, or maybe write an eMail to someone while looking at a photo they sent... The list goes on.

But you know these things.

We realize you're toeing the Microsoft line for Metro, but I really don't think the resistance is just a matter of people not yet discovering that they like full-screen apps... Don't forget we have had the ability to Maximize windows forever. Some of us, possibly considered power users, just don't Maximize our windows, and thus would not consider Metro, which forces us to do so, an improvement by any means!

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

Completely understand Noel, trust me, your feedback is being heard.

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

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

Then add mine as well, if I open something from the desktop, it should NOT send me to metro.

Also, line square x should be in metro apps on a desktop, sorry, dragging my mouse across a 24' monitor to close something is not fun, I've been alt-f4'ing I don't have a wall sized touch screen, and I doubt I even will.

where's control panel?

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

Control panel is under Settings-->More PC Settings or by typing Control Panel at the Start Screen.

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

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

i'm seeing a trend, and it tells me microsoft is scared of losing the enterprise to iphones. I don't want my desktop to be a giant ugly phone.

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

where's control panel?

In specific answer to your question, the (temporary replacement Start button tool) ViStart provides a Control Panel entry, and the Control Panel does open on the Desktop. Then you can choose View by Small icons and get this:

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

You can put the log on a SkyDrive and send me a link for the log

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

Joseph

Sorry I have been so long but I have not used Skydrive yet and am having to find out how it all works (haven't needed Windows live either come to that). I do now have the file on skydrive but have yet to open an e-mail account on W8. I saw the Windows blog video (which opened in metro) and that talked about Skydrive on the desktop but I have seen no sign of it. I would also like it on W7 as well as it does seem a good way of sending large files. How can I do this.

BTW for anyone else reading this, R/Click on the metro start menu in bottom left corner of the desktop and there is a context menu.

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

Time was, you could set up the partitions yourself during installation... Where's that functionality?

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

You still can it's right there just like Windows 7, you have to click the Drive Options button and do what you like. You can also hit Shift-F10, as always, and bring up a cmd window to use diskpart if that's your thing.

MS needs to have a tutorial that runs right after installation that describes the mouse and keyboard functionality options for Desktop users. Much like Win 3.x had a tutorial for the mouse and Windows 95 with the Start Menu. [Win key] + X is your friend to get to Control Panel and most things you would get to by right-click My Computer etc.

EDIT " R/Click on the metro start menu in bottom left corner of the desktop and there is a context menu." Nice, that's the same as [win] + x, I'll add that to my cheat sheet.

Edited by dgobe Friday, March 2, 2012 5:24 PM

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

thanks for the help, but this all seems very work aroundy for the enterprise.

I like the idea of the consistent and integrated environments across platforms, but I can't get around metro being a backwards step on the desktop and how it just takes over stuff.

I'm hoping that being a beta it is just an rough spot and that true enterprise functionality is going to be there. I'd hate to have to wait for the next iteration like we did with vista and waiting for win7 for the business world. I have to too many clients and educating a couple thousand users on all of this silliness would be a complete nightmare.

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

You still can it's right there just like Windows 7, you have to click the Drive Options button and do what you like

Thanks. I didn't recall seeing that. I captured all the screens during setup, so I went back and looked at them carefully... Sure enough, I had missed that little link:

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

thanks for the help, but this all seems very work aroundy for the enterprise.

Sure does! In my opinion Windows has been getting more and more like this since Vista. I had to write a whole book on what needs to be done to turn Windows 7 into something reasonable for doing real business work, and you'd better believe I'm already working on the sequel!

We may have to accept that Microsoft is building for the mainstream casual user, because that's where the money (in sheer numbers) is. Perhaps it's still as powerful as it is because they have to continue to develop Windows with something.

Where does it lead? Will businesses need an entirely different OS? Back to Unix maybe? Hugely expensive business systems from a vendor like IBM? Who can say? But as much money as business has, the public who just want to fool around with their little portable devices must have more, that's the only thing I can figure that's driving us down this road.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

Edited by Noel Carboni Friday, March 2, 2012 6:16 PM corrected wording

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

Where does it lead? With businesses need an entirely different OS? Back to Unix maybe? Hugely expensive business systems from a vendor like IBM? Who can say? But as much money as business has, the public who just want to fool around with their little portable devices must have more, that's the only thing I can figure that's driving us down this road.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

I know where it leads, to device agnostic "cloud", everything will be VDI or Software as a Service form the corporate servers. Widnows servers will be alive and well, but they see that the desktop as the traditional starting point is going away, you will get a check from the company to buy the device you like and just RDP/Citrix/ViewClient into a VDI system or run apps delivered over those and never see a true desktop. When, 5 years, 10? 15? but it's coming. the touch muti window multi tasking isn't there yet, but with the new arm and tegra chips it's not to far out. The GUI's just need to catch up. I "get" the ideas behind windows 8, I just can't agree with the first iteration of the implementation. There isn't enough "desktop" left for the regular user.

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

Am I the only person left who fundamentally dislikes the idea of trusting the integrity of a "cloud" of resources not even remotely under my control to run my business?

Perhaps I'm a dinosaur; I still have Windows verify with me before installing updates.

I wonder what we will all do when the "cloud" just up and refuses to work for us one day... It might be good to have a lot of gold (and bullets) at that time...

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

I think we could be friends.. I'm a paper book guy, so they can't change the words of my books. :P

my cloud: my servers and services to my clients through my network is trust worthy :P it's still a "cloud" service though.

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

Created temp tables to move Source to Desitnation

I am having different sources say(oracle, ms sql, share point, excel etc) and altogether 50 tables. I have created 50 temp tables on ms sql (my local database) to move data from these sources to destination (temp tables). None of these tables having primary or foreign key relation ships. I am using packages here to move data from sources to temp tables.

I have 50 main tables (of type sources) having all proper relationships. I am using sql script to move data from the temp tables to master using scripts.

Now suggest me is this good process to move data from sources to temp using packages then move data from temp to master using sql?

Reply:

when all the sources you mentioned can be used in SSIS as source(oracle, ms sql, share point, excel etc) why are you using

temp tables and sql in between

source - SSIS - temp tables -SQL- destination

when you can do

source --SSIS -- destination

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

1st a heads-up: your post is an informational message.

2nd - I guess you did not use the actual ##temp notation tables, but rather a staging kind of a table, so it is OK, as designed, but perhaps for encapsulation purposes you could do it all in SSIS.

Arthur My Blog

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

he might be using the temp tables to do some processing or comparison matching, but honestly i agree, you should just do it all in ssis, no need to touch the database until you're ready to write into it, i would even go a step further and say that you don't even need to declare the source in ssis at all, just use a script component in the data flow task to read all the necessary data using c# and then do whatever manipulations you need to do in the c# code and then write to the database like that you wouldn't have to deal with the headaches of using a lot of the components that might require using a lot of different types of tools

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

I have not used ##temp notation tables. Instead of temp tables, I would say staging tables. This will make my work easy becuase I have lot of primary key & foreign key relationships in the DB. My packages will run weekly, daily etc. What I thought of all bringing data into temp and by using sql script move temp data to main data. Is it good idea? And also the reason for using temp tables, if we have any issues with source data it will not impact on destination tables. On top of this I will validate the data before I move this to destination tables.

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

This is an excellent approach!

Good luck.

Arthur My Blog

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

Proposal for a new installation option in Windows Server 8

I think that in Windows Server 8 would be interesting to have three installation option:

Core
Full Classic
Full Metro

Full is usefull for server that have RDS Roles and publish Metro applications, or in which you use the configuration tool based on WinRT.

In situations where you need the GUI, but you are only using tools based on Win32/.NET the Full Clasic option is it is preferable especially if you have to manage the server via KVM console with integrated low quality mouse.

Ermanno Goletto - Sysadmin.it
MCTS - MCSA - MCP - MCBMSP - MCBMSS
I miei progetti su CodePlex: Hyper-v Guest Console - RDRemote - SysInfoHTA - User Profile Cleaner

Changed type Bruce-Liu Tuesday, March 6, 2012 4:10 PM

Reply:

Thanks for the suggestion Ermanno.

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

Exchange 2003 support

Do the built-in Windows 8 mail and calendar app support Exchange 2003? I can create the account but it doesn't sync.

Reply:

Do the built-in Windows 8 mail and calendar app support Exchange 2003? I can create the account but it doesn't sync.

Yes, I need to know too. I can't even get it connected. We are using internal CA and I have it imported into the trusted CA store

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

I'm able to connect with exchange 2003 but only partially. I know I'm only suppose to get the last 14 days mail but I'm missing the past 7 days.... weird. My calendar does not sync at all. I also get errors that the xxxx@exhangeaccount.com account is not available once in a while.

If you found this post helpful, please give it a "Helpful" vote. If it answered your question, remember to mark it as an "Answer".

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

There are now threads open for Exchange 2007 and 2010 about not beeing able to connect with the mail program.

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

I'd also like to know if the mail program is connecting through http, definitely need that for access to exchange outside of our business LAN.

Edited by prophotoc Friday, March 2, 2012 8:36 PM

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

some vms are not running in Hyper-v

Hi,

Based on subject and following link as address of snapshots of problem,I am faced to the problem after disable the DVD Drive in 5 my vms and after S/D and re-start the machines are not running and when I was to shutting down the some error occured that I show in the following link.

Integration services are enable and before the change the driver of DVD to none the everything were okay.

https://skydrive.live.com/?cid=a4735368f2ad41e4&id=A4735368F2AD41E4%21110

Thanks in advance foe any help and guide.

Peyman

Edited by peyman razmjoo Sunday, February 26, 2012 7:31 PM
Edited by Vincent Hu Monday, February 27, 2012 1:31 AM upload the screenshot

Reply:

Hi,

Please login into the virtual machine, proceed to Services to see whether you have Hyper-V Guest Shutdown Service enabled.

By the way, what's the version of the operating system running within the problematic virtual machines?

Vincent Hu

TechNet Community Support

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

Dear Mr.Hu,

Many thanks for your reply.

For your attention I made two vms server R2 in Hyper-v ,so one of them is okay but another one after restart and is not running and when I was to shutdown the vms the above error occured.

But it is noticeable that after the finishing the R2 and disable the DVD Rom this problem I was faced.Also in some before cases,I was faced to this case,but I did not find any solution.Despite of this,the host situation R2 is okay and all the services is running.

I am very glad if you and anybody to help me for solving this problem.

Many Thanks.

Peyman

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

The VM must be on and running to support shutdown.

If the VM is in a Saved or powered off state it cannot be shut down.

To remove an ISO from a DVD drive the VM can be running, but to remove the DVD drive all together, the VM must be powered off.

I am not clear what you mean by 'disable dvd drive' and I have no context for what "S/D" means.

Brian Ehlert (hopefully you have found this useful) http://ITProctology.blogspot.com
Learn. Apply. Repeat.
Disclaimer: Attempting change is of your own free will.

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

Hi,

It seems that I missed something in your first thread. According to the screenshot, the virtual machine was running, however, it failed to boot into Windows system. So the Integration Service was not running and you will not be able to perform a "Shut Down" which need Integration Services support. In this way, you can click the "Power Off" button to power off the virtual machine.

So now the problem is that the virtual machine is not running properly.

I would like to collect some information about your description: "But it is noticeable that after the finishing the R2 and disable the DVD Rom this problem I was faced"

1. Did you see the desktop when you finished the installation of R2?
2. I suspect that the "disable the DVD Rom" here meant checked the box "None" in DVD drive items under Virtual machine's settings, so the ISO file or CD/DVD was not running.

Please try to power off the virtual machine and then start it again to see whether you can start it properly.

Vincent Hu

TechNet Community Support

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

Hi,

I mean that after installation of R2 ,I dismounted the DVD drive because you know that for setup another vms it is necessary to disengage the DVD DRIVE for setup other vms.

For S/D It is mean Shut Down.

Okay I was proceed to your comments as glance.

Thank you.

Peyman

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

Hi,

I mean that after installation of R2 ,I dismounted the DVD drive because you know that for setup another vms it is necessary to disengage the DVD DRIVE for setup other vms.

For S/D It is mean Shut Down.

Okay I was proceed to your comments as glance.

Thank you.

Peyman

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

hi Mr Hu

Many thanks for yours pleasant guidelines,My problem is solved and exatly because of yours mentioned reason.

Thanks again and more for your attention.

Peyman

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

Counter in emai ID

when an email ID is being created of similar name i.e. Ali Abid and there are four Ali Abid but their email IDs are being created as

1. ali.abid

2. abid.ali

3. a.abid

4. aliabid

these ID is being created with counter e.g. aliabid4@example.com

Reply:

Since there are no responses, I will take a stab here. So the question is what version of Exchange do you have? What is your email address polcy? Let's start with that and see if we can come up with an answer. My guess is that your alias is based off of the first name combined with the full last name. However, your third item does not match as there is a single letter there. Is there any reference to ali in that one?

As for the counter, this is normal. All email addresses in Exchange must be unique otherwise there are issues. There is internal logic in Exchange to help prevent duplicates.

JAUCG

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

Dual-boot Bonuses

Let's say W7 & W8. Let's say there's a Sys drive& a Data drive & maybe others, too. When > Computer in the W7, see all the drives. AND... when in W8 > Computer AND still see & can access ALL the same drives... nice bonus to dual-boot, can get @ & use everything you already have from BOTH OSs. If, you don't have a spare machine & can dual-boot (have drive availability), it's a great method & sure beats a VM. Also, since you can see both OSs, it an easy Drag-n-Drop to copy wanted Favorites, Favorites Bar, Documents, Pictures & so on over from 1 OS to the other.
A tip - when switching OSs, Log Off from the one you will not be using. Cheers,
Drew

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Edited by Drew1903 Saturday, March 3, 2012 11:54 AM

Reply:

Already have the main user folders redirected to another drive. Also, in the library folders, add the W7 folders and it is all in one place. Easy to drag & drop from one to the other.

Also added downloads as a library item so I can easily get hold of those in W7.

Edited by d r h Friday, March 2, 2012 1:25 PM

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

WSP

HI,

i have created a wsp through sharepoint 2010, and this is directly deployed globaly. This happens when i right cilck on the project and click on Deploy. but i want this wsp to be deployed to a particular web app.. how do i do it

Reply:

Hi,

By navigating to the properties of the project file in Visual Studio (select the project in solution explorer and press F4 to go to properties) you can set the site url that where your WSP should get deployed. But if its the case that you don't have anything specific to be deployed to a particular web application only, then your solution get deployed globally. Its not something to do with Visual Studio deployment, its the behavior of sharepoint. Even if you try to deploy it using Central administration, using manual steps, it will say you that it can be only deployed globally.

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

If you are using native Visual Studio 2010 functionality then you can simply open up the "Package Designer" and select your deployment options from there . for that you need to modify the manifest.xml

if you want to do it for a web application do it like this.

stsadm.exe -o addsolution -filename "C:\yourwsp.wsp"
stsadm.exe -o execadmsvcjobs
stsadm.exe -o deploysolution -name yourwsp.wsp -immediate -allowgacdeployment -allowCasPolicies -force
stsadm.exe -o execadmsvcjobs
stsadm.exe -o activatefeature -filename "yourwsp\feature.xml" -url "webappurl" -force
iisreset

or use powerhell scripts:

http://patrickboom.wordpress.com/2010/05/31/using-powershell-to-deploy-sharepoint-solutions-wsp-2/

MCTS,MCPD Sharepoint 2010. My Blog- http://sharepoint-journey.com

If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful

Edited by Devendra VelegandlaMVP Wednesday, February 6, 2013 12:18 AM

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

Thanks ,,, i have added the solution through stsadm command,, but when i go to central admin and try to deploy it, i do not get the option to select the webapp,.

do you mean to say i have t deploy the wsp through stsadm command only so that i can deploy it to any particular webapp.

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

check this below link it will give clear idea:

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/e2463b9f-28f6-4788-8b50-9cff1e3d74c4/

MCTS,MCPD Sharepoint 2010. My Blog- http://devendra-sharepoint.blogspot.in
If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful

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

Advanced Topics in Biztalk Server 2009

Hi all,

I am working on Biztalk for the past 6 months as a fresher and i have good knowledge in the below by the practical Experience.

Mapping, Schema, Orchestration, Custom Pipelines, Custom Functoids, Pre and Post Processing Scripts, calling the Helper Libraries (c#?.Net),

Adapters (SQL,SAP), Rules Engine, Custom XSLT(Custom Mapping), WCF basics.

Now i like to grasp some more additional Knowledge in Biztalk Server 2009.

Please guide me by directing me to learn the Advanced Topics in Biztalk that i am not aware of.

Thanks

Don't forget to mark the post as answer or vote as helpful if it does, Regards - Rajasekhar.R

Edited by Rajasekhar.R Friday, March 2, 2012 4:23 AM

Reply:

Hi Rajshekhar,

Please go through the Technet article from Steef-Jan

http://social.technet.microsoft.com/wiki/contents/articles/2240.biztalk-server-resources-on-the-technet-wiki.aspx

This link covers most of the things common across all BizTalk versions also there links for advanced topics as well.

I think this will give you direction and you can choose to learn topic of your interest.

Thanks With Regards,
Shailesh Kawade
MCTS BizTalk Server
Please Mark This As Answer If This Helps You.
http://shaileshbiztalk.blogspot.com/

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

Hi!

Knowledge comes with learning. I would recommend you to read books and participate on forums to learn more! ;)

The TechNet Wiki as Shailesh referes to have a lot of intresting articles regarding BizTalk. I would recommend you to check the following;

BizTalk Server Books

BizTalk 2010: Training Materials

You can also take the MCTS BizTalk Server 2010 exam. You can read more about it here

Always try to follow best parctice when creating applications.

Best regards

Tord Glad Nordahl
Bouvet ASA, Norway
http://www.BizTalkAdmin.com |@tordeman

Please indicate "Mark as Answer" if this post has answered the question.

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

Good suggestions by Tord and Shailesh!

However, I would like to suggest your one more link , which is all about coding and design guidelines for BizTalk server solutions. Please refer following link to understand some advance concepts of development in BizTalk

Review of Solution Design

There are other contents as well in the article, Might be helpful for future!

HTH,Naushad (MCC/MCTS) http://alamnaushad.wordpress.com,My New Technet Wiki Article "BizTalk Server: Performance Tuning & Optimization"

If this is helpful or answers your question - please mark accordingly! Please "Vote As Helpful" if this was useful while resolving your question!

Edited by Naushad.AlamModerator Friday, March 2, 2012 8:35 AM spell

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

Hi Rajasekhar,

as i can see you covered almost of the core BizTalk Server foundations in technical terms.

BizTalk Server yet is an integration platform, made to connect in almost any EAI process and capable to handle a large variety of business processes.

Therefore i'd recommand to have a glance at the typical EAI challenges which inlcude also message patterns and solution design. Despite the backend B2B processing there's also scenarios, witch comprise clients, e.g. MS Infopath. You can find various information about SOA topics related to BizTalk Server as well, more or less generic. One of my all time favs:

http://my.safaribooksonline.com/book/software-engineering-and-development/soa/9781847195005

hth

Paul Endras

Edited by Paul Endras Friday, March 2, 2012 12:55 PM

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

WATK\Labs\HPCParametricSweep bug

Just to report a simple bug on the Jan refresh of WATK\Labs\HPCParametricSweep.

namespace CPUSpinner  {   class Program   {   static void Main(string[] args)   {   Spinner.Spin(args[0]);   }   }  }

Should have some protection over Spin(), in case user forgot to give parameter.

Reply:

Thank you for sharing experiences. I will help to report this problem to relative team.

Thank you.

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com Microsoft One Code Framework

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

Controlling Permissions on Enterprise Wiki

I have an Enterprise WIki site setup for one of the departments in the my organization. I have modified the Enterprise WIki Page Layout and added a Noteboard on it so that users can leave comments on the articles. Now I want control the editing rights on the Wiki site. In my case I want that only the members of the department can edit the wikis whereas other users in the organization can only Read the pages and add comments in the Noteboard. Is such a kind of functionality possible without coding? else if coding is required how to achieve it?

Sub report visibility

SQL 2008 R2

I have built a report using Report Builder 3, and this report has sub reports. The sub report has two tablix on it and are shown / hidded dependant on a value passed to it from the main report. When running this in report builder 3, the showing / hidiing of the tablix works fine, however when running from a web application the show / hide expressions dont work.

I am at a loss as to why this might be. I am presuming it is to d with the report ad the report has an embedded dataset, so I know the data being used is constant

Dont ask me .. i dont know

Med-V implementation for Windows 7 with SCCM 2007

Hello,

We are planning for implementing Med-V 2.0 for Windows 7 machine using SCCM.. So can someone please guide me through the necessary steps for the same & if possible please share the implementation guide as well.

AMIT

Reply:

you can use configmr product to deploy VHD files (please read the document what i meant VHD http://www.google.co.in/url?sa=t&rct=j&q=med-v%202.0%20guide&source=web&cd=1&ved=0CCsQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2Fa%2F4%2Fe%2Fa4ef20e1-763c-4cbe-8eb7-f541a95ac092%2Fmed-v%25202.0%2520trial%2520guide.docx&ei=OYxQT8WQE4TJrAeY0NzfDQ&usg=AFQjCNGfvTyBzzQ2ZJ6acdDu7YSJRlIrGw)

To get VHD file,you will have follow the document given above to prepare compressed file and then distribute it to the clients to make the applications compatible .

reference guide for medV 2.0 http://social.technet.microsoft.com/wiki/contents/articles/2384.aspx

as this is configuration manager forum,suggest you post it on correct forum to get implementation plan etc,

Please click on "vote as Helpful" if you feel this post helpful to you.

Eswar Koneti | My Tech blog: www.eskonr.com | Linkedin: Eswar Koneti

Edited by Eswar konetiMVP Friday, March 2, 2012 9:06 AM

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

Unable to add user in FBA site !!! :(

Hello,

Scenario :

I have configured FBA , but unable to get login through FBA user as when I try to login it throws "Access Denied" error.

I need to set permission to sharepoint fba site with fba user.

Issue :

Can anyone please let me know what are the approaches to Add FBA user in sharepoint groups ike "Owners" , "Members" and "Visitors" ?

Dipti Chhatrapati

Reply:

Access denied means that user is authenticated but not authorized . Are you sure you have provided permissions for the user ? Check all the list on which access rights are provided or not.

For example you have access to the site but on the page you have webpart which do some activity on list , and list do not have access than also you will get access denied error.

Regards,

Milan Chauhan

LinkedIn | Twitter | Blog | Email

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

yet I have not added users in any group because when I try to add it it throws "No Exact match was found...." I tried to add programmatically but doesnt work yet...as it throws "Specified user could not be found".

Dipti Chhatrapati

Edited by Dipti Chhatrapati Friday, March 2, 2012 8:06 AM

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

I resolved it through programmatically.

thanks,

Dipti Chhatrapati

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

How to access uploaded files and data entered via web-form from a 'SharePoint Internet' site to a 'Sharepoint Intranet' site?

I have a requirement where I need to get the data from Intrernet site to an Intranet site. This may have uploaded document or the data entered by the Internet users via a web-form. The login credential of the internet users will not be from Active Directory as in case of Intranet users.

Please help me give solution, an architecture as to how this can be done in an easiest possible way!

Reply:

I have a requirement where I need to get the data from Intrernet site to an Intranet site. This may have uploaded document or the data entered by the Internet users via a web-form. The login credential of the internet users will not be from Active Directory as in case of Intranet users.

Please help me give solution, an architecture as to how this can be done in an easiest possible way!

Not necessarily an architecture, but any solution towards achiveing this goal will be helpful. I came to know about Extranets, as this could be used to get a solution for an above scenario. Is this is the right thing to do..if yes, then what is the minimum infrastructure, in which this can be done. Appreciate response with respect to SP 2010.

Thanks in Advance!

Edited by AmarendraK Monday, February 27, 2012 7:13 AM grammar

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

Hey Amarendra,

Basically, once you create the site for Intranet, you can probably extend it to the internet zone for making it available to Internet users. You can have a separate sets of front end pages for both types of users which shares the common data repository. Content DB will remain same for both sites.

I hope this makes sense.

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

Thanks for your reply Dipesh. I want internet users to access only few pages and not the entire site...It should be just available to upload few docs or enter personal details as requried in forms and the rest of the site should remain to Intranet only.

Can this be done? Please give few hints for accomplishing this.

Thanks!

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

Definitely it can be done... You can have separate library which contains pages for internet users specific. You can grant permission on those pages to anonymous users. You need to set anonymous access at List and Library level on the extended site (Internet Site).

There are many blogs where you can get information about how to set anonymous access on the site.

Dipesh

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

Thanks Dipesh ..I will try it out !

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

How to add multiple counters in a single Windows performance rule in SCOM 2007 R2

Hello,

I an new to SCOM. I am basically connecting to SCOM server remotely (through EnterpriseManagement APIs). I want to get the performance data for all the Windows computers configured in SCOM server.

In order to collect the performance data, first I need to create rules specifying the counters. Is there any way by which I can configure multiple counters in a single Rule.

e.g. Can I create a rule names "testRule" having category Process and counters %processor time, I/O Data bytes/sec... ?

Edited by Prasad Tendulkar Tuesday, February 28, 2012 7:20 AM

Reply:

Hi,

I would like to suggest you refer to the method in the following thread:

Can I create a monitor based on the sum of two performance counters?

http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/01e0be35-bd7b-4dd7-9661-6ef3c3571ec5

Hope this helps.

Thanks.

Nicholas Li

TechNet Community Support

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

I'm not sure I understand your requirements - are you looking to pull all of the data out of SCOM into another application to view it there?

Or are you looking to collect this data from monitored windows servers into SCOM? There are many rules out of the box that collect performance data for SCOM so I'm not sure why you are looking to create more rules unless it is for items not covered by the management packs? % Processor time and disk IO are covered by the windows management pack.

SCOM is a scripting engine so you depending on the scripting skills available to you, most things "can be done". There are some major considerations if you are trying to collect data from objects which have multiple instances which are covered here:

http://blogs.technet.com/b/kevinholman/archive/2007/12/14/how-do-i-collect-data-from-a-multi-instance-object-like-a-sql-db-instance.aspx

http://blogs.technet.com/b/kevinholman/archive/2009/11/24/writing-monitors-to-target-logical-or-physical-disks.aspx

One monolithic rule covering a lot of counters is likely to be a big hit on the monitored system every time it runs and it will be difficult to set overrides as you could only override for the rule, not the individual stream of data. It really isn't the way to go with SCOM, it isn't good practice and is likely to be a performance problem on both the monitored server and on scom.

Cheers

Graham

New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/
View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

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

Allow me to share...

This is pulled out of context from another tech forum. Basically, it followed some positive comments & bits to which, I added this that I trust y'all will allow me to share w/ you.

Well, y'all knew I'd toss my 2 cents in here Yes, I, too, knew the numbers, the specs, even the motivators & goals, in advance AND what it all suggested... hell, I even sat through a whole morning of listening the Steve rant about its greatness & appeal... I muddled about w/ the DP. We are not there yet, folks but, now we have a beta. It's still early!!...I don't hear my machine running!!! That is notthe case when it's on Windows 7. I have gauges on my screens… the activity & levels are not the same!! Period. W/ Windows 8 it's freaky how low the values are. No wonder things are fast; point here is, to see it hands-on, that's when it becomes concrete & impressive. Damn machine is hardly working... doing the same stuff as would be in Windows 7. However, ppl will balk & fight it tooth & nail unless the majority buy into comments like these. MS has hit a homer, by the looks of it, so far. Will most ppl buy into it, not only as a purchase but, conceptually. I will be bold enough to say MS has turned a corner in what IT & computing is & is becoming, where it's going. This should have appeal... BUT, will the (Metro) Start be a turn off, the lack of Start Menu, ppl thinking it requires Touch and "What??!! I have to go new, again, already??!!"... will these 3 be obstacles? Will all the timely sense it makes, all the performance it offers, outshine all that? Between the number devices upon which this thing is happy & the number of End Users who could be very happy w/ it... it is worth learning it & w/out a chip on one's shoulder OR being pissed about a learning curve... why wouldn't there be a learning curve? Ah, but, no call for panic... MS gave it to the world @ a time ppl would be so bloody curious they would try or play w/ the damn thing, right now, Beta or not, for free... and, gosh, what happens if, even, most of them think it's screamin' cool, too? Maybe, MS lures & hooks folks... Ya think?? Anyway, all factiousness aside, even w/ some things in the DP I thought, this is how is should have always been; then you realise what actually exists now, technically, how Windows 8 positions itself & the IT road ahead... faster, smaller, more powerful & capable, lighter on resources & easier to understand & use. So far, this OS looks like it may be a hit that's going out of the park & lots of folks will applaud. Regards, Drew

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Rename attribute flow error status does not cause sync error when provisioning disabled

When troubleshooting a provisioning rename failure today with a colleague, we noticed that while the pending rename was detected on the FIM MA full sync, the pending export to AD was not being applied to the AD CS. With a bit of digging we found that while there was no error reported in the synchronization step (either on the CS as a whole, or individually using a preview on the FIM MA connector), by inspecting the preview results a little closer we could see an "Error" value for the status of the EAF. This is similar to other observations logged on this forum here:

Unlike the above scenarios, in our case the exception was to do with a rename of the DN such that there was a clash with an existing CS object (which ALSO was pending a rename). This caused some confusion, until I reasoned that because we were still in the "initial match" phase the provisioning checkbox was presently turned OFF, it occurred to me that perhaps this was how the FIM sync engine is now designed to work in this scenario (when provisioning is disabled, since renames are a performed in the provisioning phase of synchronisation). My theory is that if provisioning WERE to be enabled then this scenario SHOULD cause the generation of an overall sync error - as opposed to an overall success status (despite the individual EAF error for the dn flow).

We are attempting to reconstruct this scenario in a lab - because we can't test this theory in Production - however while we do this can anyone else confirm my above theory? Or do we get the same result with provisioning enabled?

Thanks.

Bob Bradley (FIMBob @ http://thefimteam.com/) ... now using Event Broker 3.0 @ http://www.fimeventbroker.com/ for just-in-time delivery of FIM 2010 policy via the sync engine

Changed type UNIFYBobMVP Sunday, May 20, 2012 12:51 AM Can't seem to get any response on this - probably will raise this in Connect

Skype

FYI:

Where there were issues w/ Skype on the DP it works fine on the Beta.

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Reply:

Thanks for the feedback Drew.

--Joseph [MSFT] http://blogs.technet.com/b/joscon/

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

Are you not getting the "Stop running this script?" error on the skype home tab? If I click "Yes" then Skype just locks up.

Thanks,
Bobby Cannon
BobbyCannon.com

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

In the DP I was getting "Skype has stopped working". On the Beta it is just fine. But, I'm in Windows 7 @ the moment. When I go back to Windows 8 (soon) I'll check it, again, for you...

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

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

Ok, I'm back in Windows 8. Everything & anything I do w/ Skype including, I think, the things you mention gets no errors, snags, messages or snags of any kind. Sorry. But, I did say I'd check into it for you.

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

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

Links

Links on the Taskbar, equivalent of Favorites Bar, did not work properly in the DP. It does work properly in the Beta.

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Reply:

Hi,

Thanks for sharing. We really appreciate your time and efforts. Hope your experience will help other community members facing similar problems.

Leo Huang

TechNet Community Support

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

Thanks, again; me, too.

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

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

Software Updates

Hi,

I have created a software update deployment.

this deploys 4 bulletin idms to a collectio nand works fine

the problem I have is that I can locate when I can have a status of this like I can do with any other advertisement.

ie. how can i get a status of software updates ?

I have no bother in getting a status of a non software update

Reply:

Apologies, to correct the grammar mistakes.

I have inherited a collect with runs a software update deployment, it works fine , For the life of me I can not see the advertisement where I can get a status of who has got it etc etc.

All other advdertisements I can get a status

This is driving me crazy

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

Check the report, Enforcement state for a Deployment and select the Deployment.

Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

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

Kent,

thanks for your reply.

Two ?????

Is that the only way to check for a status on a software deployment ?

Am I correct in saying that there is not an option to right click and get a status of this deployment as SCCM buries that advertisement within ?

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

When tracking Software Updates, reports is the feature to use. YOu can also create collection/queries, but a report is the easiest feature to use.

Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

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

SUP Deployment limitations

I know that best practices say you shouldn't have more than 500 updates in a single deployment package.

But I can't find any information about having more than 500 updates in a single deployment (by deployment I mean the object under Software Updates > Deployment Management). Is is also best practice that a deployment should have less than 500 updates or doesn't this apply to the deployment object?

cogu

Changed type Sabrina Shen Friday, March 16, 2012 9:44 AM

Reply:

Hi,

You can have more than 500 updates in an update list and deployment management no problem. Just spilt them up into multiple deployment packages as it is only the Software Updates apckages that has the 500 updates limitiation.

Regards,
jörgen

-- My System Center blog ccmexec.com -- Twitter @ccmexec

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

Though... Microsoft say something that is a little bit conflicting in their best practice documentation.

http://technet.microsoft.com/en-us/library/bb932162.aspx

"To avoid possible performance issues, we recommend that you do not add more than 500 software updates to a single software update deployment or deployment package."

I take it that by "single software update deployment or deployment package" they mean the deployment management object and the deployment package. If that's the case, it goes against what you said Jörgen. Can you clarify please?

cogu

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

Apparently as of at least 1st April 2011 the best practice has changed from "less than 500 updates to a single software update deployment" to "less than 500 updates to a single deployment package or software update deployment", as seen on both the following documents:

http://technet.microsoft.com/en-us/library/bb932162.aspx

http://technet.microsoft.com/en-ca/library/bb693754.aspx

Thank you.

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

Hi,

yes you are correct, I have had more thtn 500 in a deployment amny times, but is not Best Practice as you say.

I normally divide the updates per operating system or product to limit the number of updates per deployment/ deployment package. In some cases I move the update to a 2010 package as well so I have update deployments and packages per year to limit the number as well.

There are many different ways.

Regards,
Jörgen

-- My System Center blog ccmexec.com -- Twitter @ccmexec

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

I think dividing them by years makes it a little more managable: ensures you don't accidently leave out any updates that you're not quite sure which product to place them in and lets the workstation do the job of deciding what to install, not you. It does make it slightly harder to look at though, I'll admit to that.

Another question about deployments: I know it's not a good idea to "re-use" deployments as the reporting might then be a bit wierd. I can see how that would be the case if you're removing updates from the deployment. However, is that also the case if you are adding more updates to a deployment or advertising it to more workstations?

The idea was to have a monthly deployment which gets deleted at the end of the month and never re-used, and an yearly deployment which contains all updates for the current year excluding the monthly patches. As we move into a new month, the updates from the previous month would then be added to the current year deployment and a new deployment created for the new month. That way, we'd have a current year deployment that contains all current year updates except the ones for the current month but that would imply constantly adding more updates to a deployment.

cogu

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

Need the paid services of a SQL expert - where should I go??

Not sure if this is the right place to ask this question, so apologies if I should be asking somewhere else.

I need to find a SQL expert, to look at our SQL databases, and investigate performance issues, indexing, see if the setup of the databases is appropriate/correct, etc etc. General maintenance I suppose. The company who installed SQL for us, well I have lost faith in them a long time ago, as all they seem to be interested in is making money but not providing a quality service. The database is used by our enterprise application, Microsoft Dynamics AX, and also used for Reporting Services. I had to set up Reporting Services myself in the end, as they were willing to 'look at it', but for an ridiculous fee. So I suppose I need that checked out as well, as we are get issues with Reporting Services report manager website timing out a few times a day and needing an IISRESET.

Any ideas of where I can go, where I can look for someone? Ideally someone based in north west of manchester, but anywhere UK based should be okay I suppose. Thanks for any and all help.

Naz

Reply:

Naz , can you provide your email address?

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

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

How to disable the Save Embedded Files Dialog

Hi all.

I need to turn off Save Embedden Files dialog.

I have set "Set Action" to "Don't Save this file. Use the current file on disk.". Unfortunately, SPD asks me the same question each time I save the file again. I'm using links to images (from my other website, format http://img.jpg), and i don't want to save images to my new project.

in Expression Web 4 I can do that with Registry key:

HKEY_CURRENT_USER\Software\Microsoft\Expression\Web\4.0\SaveEmbeddedFilesDisabled

but in SPD that doesn't work for me.

Anybody can help me with this problem?

[Solved] Troubles with Routing and IP-Spoofing

Hi,

I have a virtual cluster of UAG working with unicast NLB (Sp1 update 1). They are in a DMZ and Each node has only two interfaces: intern and extern (both through the firewall).

I can observe the following problem:

While accessing an UAG portal (https connection) from some external connection (like 178.x.x.x or 84.x.x.x for instance), the TMG firewall sees the packets as coming from outside but considers them as being spoofed, and thus drops them.

Obviously, those IP ranges are not defined in the intern network object. Furthermore, the issue doesn't happen when I access the portal from 3G connection.

As a workaround, I can add the IP ranges as a static route with the default gateway (extern). Still, it is a really unclean solution, does anybody have any idea?

Here's a screenshot of the "workaround" for a specific subnet, which should normally be included in the 0.0.0.0 route.

Thanks,

Pierre

Edited by PierreMonier Monday, March 5, 2012 11:16 AM

Reply:

Hi,

Please check this link,

http://www.msserverpro.com/view/1015

I hope this will help you.

Thanks,

Best Regards, ----Naresh Man Maharjan,Nepal---- www.msserverpro.com

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

Hi Naresh,

first thank you for your answer, I'm sorry I answer that late, just didn't had a lot of time to work on that case.

Truth is, we solved the problem. The whole issue came from the configuration of the interfaces: the external interface was coming before the internal (advanced configuration of the adapters), provoking this absurd behaviour.

Thank you for your help.

Pierre

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

Create a degenerate dimension

Hi all,

I want to create a degenerate dimension using a column from my fact table. How can i do that in BIDS?

Thanks in advance,

Anish Tuladhar

Anish Tuladhar -Do not forget to mark as answer, only if helpful.:)

Reply:

Search for factdimension

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

hi Anish,

we can create a degenerate dimension from the dimension usage tab in the cube.

Click on create new dimension option , then the same dimension wizard opens.

Then we can do as we need...

regards ,

dhwani

PLEASE MARK AS ANSWER IF IT RESOLVES.

s dhwani

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

Web pages slow to load with TMG 2010 acting as Proxy

Hi Everyone,

I've run into an interesting problem with a new installation of TMG 2010. Basically everything seems to work fine; however, several websites load very slowly (slowly meaning they could take up to 5 minutes to load on a 100-Mb internet line). However, when we take TMG 2010 out of the equation the sites run smooth and quite snappy. Has anyone seem something similar with other installations?

Here's the configuration

·     Windows 2008 R2 All Updates Applied
·     Microsoft TMG 2010 with SP1 and Rollups installed "up to date windows updates"
·     Front-End to Back-End Configuration
·     Backend Server has single NIC
·     Frontend Server has dual NICs, one nic internal and one external
·     Frontend Server has DNS entries only on the internal NIC per best practice and no DNS entries on the external
·     Backend server forwards proxy requests to front end through standard Web Proxy Chaining configuration
·     Base rule set for Web Filtering with URL Categories "base configuration meaning wizard built - Default"
·     Web Caching is Disabled
·     Malware Inspection is disabled for testing purposes
·     HTTP compression is turn off
·     Web Chaining points at the internal network card inside the DMZ
·     Normal web traffic passes however the below websites just load extremely slow

Sites in question which seem to load really slow

Thanks

Michael Cronin

Edited by Michael T. Cronin Wednesday, February 23, 2011 11:35 PM Addition of more information
Changed type Michael T. Cronin Monday, February 28, 2011 2:25 PM

Reply:

Hi Michael

I have the Same issues with TMG 2010, i have got all the rollup and updates installed till now but i still have the same internet slow browing issue.

Hope this link is to any help for you. http://technet.microsoft.com/en-us/library/ff358607.aspx

If you have found the solution to the above issues you have please let me know as well. I ahve about 4 sites, ia m experiencing the same issues.

Thanks

Ronald

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

Metadata Column mapping and values missing in Publishing farm

Hi,

We have a Authoring farm and Publishing farm. There exist a custom list from which items are moved from Authoring farm to Publishing farm through content deployment. This custom list contains a column of Managed Metadata type. However, recently we found that, the mapping for this column was missing in Publishing farm.

We remapped the column in Publishing farm, added some items with value in this column in Authoring farm and moved these items to Publishing farm through Content Deployment. Now everything works fines, except for the items that existed before remapping was done, Some of these items do not show values in the Metadata column. We tried editing one such item in Authoring farm and then moving it to Publishing farm through Content Deployment. This item now shows value in the Custom Column. However, this is not a feasible solution, the number of such items being huge and also as the issue is occurring in Production environment.

Can anyone help us to know what could be the reason why this mapping was lost on Publishing farm, or steps that we need to take in order to ensure that this does not happen again? Also is there any other solution to above issue instead of editing, checking in and then moving all such items again to Publishing farm?

How to omplement google map locator webpart in sharepoint

Hey, I want to implement google map locator webpart in sharepoint and this webpart should not be based on lattitude and longitude. I have found many solution on this. But my requirement is to develop a webpart which will search on "My Places".

Means i want to provide a text box and it will take a string(place name) and which will point to the location directly.

Any suggestion on this ?

"The Only Way To Get Smarter Is By Playing A Smarter Opponent"

Reply:

Hi,

You can you google API on this link http://code.google.com/apis/maps/documentation/geocoding/ which help you in loacating the lattitude and longitude based on your input.

Thanks

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

Hey Ravi,

you can use Google Map V3 JavaScript API

http://code.google.com/apis/maps/documentation/javascript/reference.html#MapTypeControlOptions

Sample:

http://code.google.com/apis/maps/documentation/javascript/examples/index.html

Ismail Al-Kiswani

Ismail Kiswani

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

Windows updates + controls

Windows update arrange lots of updates nicely like a package. It's better than having all kinds of individual system parts looking for updates now and then. So maybe it is possible to include none microsoft products like fx. when you click control-panel -> admin -> Systemconfiguration | Services you see all those services that will launch at system startup and you can click Hide all Microsoft-services because other products are allowed calls on system startup also.

So maybe windows update could have a similar button to show other products. Because that would be a better user interface if seperate programs like graphics card drivers, thx truestudio, etc etc just with the press of one button together with windows update would look for updates ...

Reply:

It seems that you not so much have a question as you have a suggestion on how to improve the Windows interface. I would recommend that you post your suggestion at the Windows Team website. You have a better chance on anyone actually involved with the development of Windows reading your post. Although I would rate it unlikely that any changes such as those you are describing will be implemented in Windows 7 at this time in its release cycle.

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

TCP loss under load?

Hi, i have a tower running windows server 2008, and it is a media/storage server.

When i am writing to the server, which has a 2TB external drive attached via USB, the server drops connection alltogeather. If i ping the server (ie ping 192.168.2.2) i receive a 100% success. When i am attempting to write to the shared storage, i get a 100% packet loss! and the transfer sticks on time remaining: Calculating.

This has never happened. I have replaced the switch but with very little experiance troubleshooting network failure im not sure where i can trace the packet loss or if its the server itself.

I have a NIC and a wireless card installed on the server, the NIC (192.168.2.2) and wifi (192.168.2.254) both loss connection. (unable to ping) until i cancel the file transfer, then the server, both addresses are reachable again!

Thanks!

Reply:

Add a persistent route from your machine to the server bounding it to the hard wire NIC.

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

Hi deanfourie,

Thanks for posting here.

So will system responses properly if we write to the shared folder where stored on its local storage ?

Try to disable one of active NIC on this server ( wireless NIC maybe )and set it single homed , after that please try to see if we can still reproduce the phenomenon.

Expected Behavior of Multiple Adapters on Same Network

http://support.microsoft.com/kb/175767

Thanks.

Tiger Li

TechNet Community Support

Edited by Tiger LiMicrosoft employee Monday, March 5, 2012 8:27 AM

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

Distrib.exe error

According to http://msdn.microsoft.com/en-us/library/ms147343.aspx I need to provide -PublisherLogin as one of my command line parameters when using SQL authentication. However, it get the following error:

Agent message code 20030. A syntax error occurred near parameter '-PublisherLogin'.

According to http://msdn.microsoft.com/en-us/library/ms147328.aspx there is no -PublisherLogin parameter ...

Any ideas on how to solve this?

Regards Des Norton

Reply:

You don't need publisher login, you need distributorlogin. PublisherLogin is an invalid parameter for the distrib agent.

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

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

I removed the Publisher Login and got another error:

SET Publisher=PPWAPPSRV01
SET Publication=VHS
SET PublicationDB=HBH_VHS
SET PublisherLogin=sa
SET Publisherpass=******
SET Subscriber=HBH\VHS
SET SubscriptionDB=VHS

"C:\Program Files\Microsoft SQL Server\100\COM\DISTRIB.EXE" -Publisher %Publisher% -PublisherDB %PublicationDB% -Publication %Publication% -Distributor %Publisher% -DistributorLogin %PublisherLogin% -Distributorpassword %Publisherpass% -DistributorSecurityMode 0 -Subscriber %Subscriber% -SubscriberDB %SubscriptionDB% -SubscriberSecurityMode 1 -SubscriptionType 1 -OutputVerboseLevel 2 >> InitVHS.log

2012-02-21 13:46:25.038 OLE DB Distributor 'PPWAPPSRV01': execute sp_server_info 18

2012-02-21 13:46:25.084 ANSI codepage: 1
OLE DB Distributor 'PPWAPPSRV01': select datasource, srvid from master..sysservers where upper(srvname) = upper(N'PPWAPPSRV01')
2012-02-21 13:46:25.194 OLE DB Distributor 'PPWAPPSRV01': select datasource, srvid from master..sysservers where upper(srvname) = upper(N'HBH\VHS')
2012-02-21 13:46:25.256 Agent message code 20053. Server 'HBH\VHS' is not registered at server 'PPWAPPSRV01'.
2012-02-21 13:46:25.365 ErrorId = 8, SourceTypeId = 2
ErrorCode = '20053'
ErrorText = 'Server 'HBH\VHS' is not registered at server 'PPWAPPSRV01'.'
2012-02-21 13:46:25.428 Adding alert to msdb..sysreplicationalerts: ErrorId = 8,
Transaction Seqno = , Command ID = -1
Message: Replication-Replication Distribution Subsystem: agent (null) failed. Server 'HBH\VHS' is not registered at server 'PPWAPPSRV01'.OLE DB Subscriber 'HBH\VHS': exec dbo.sp_MSupdatelastsyncinfo N'PPWAPPSRV01',N'HBH_VHS', N'VHS', 1, 6, N'Server ''HBH\VHS'' is not registered at server ''PPWAPPSRV01''.'

Regards Des Norton

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

You need to create an alias for this subscriber. Go to SQL Server Configuration Manager and create an alias to this subscriber. Expand the SQL Native Client Configuraton , right click on alias, for server enter HBH and for alias name enter HBH\VHS.

Then try again.

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

Thanks Hilary

I created the alias on the subscriber machine, and get the following errors:

Protocol = TCP/IP ... PortNo = [blank]

2012-02-22 06:48:33.628 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 06:48:33.628 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 10061
Message: TCP Provider: No connection could be made because the target machine actively refused it.

Protocol = TCP/IP ... PortNo = 0

2012-02-22 06:51:00.440 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 06:51:00.440 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 87
Message: SQL Server Network Interfaces: Connection string is not valid [87].

Protocol = TCP/IP ... PortNo = 1433

2012-02-22 06:53:41.167 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 06:53:41.167 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 10061
Message: TCP Provider: No connection could be made because the target machine actively refused it.

Protocol = Named Pipes ... Pipe Name = \\HBH\pipe\sql\query

2012-02-22 07:01:01.181 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 07:01:01.181 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 2
Message: Named Pipes Provider: Could not open a connection to SQL Server [2].

My topology is as follows.

PUBLISHER/DISTRIBUTOR
Windows Server 2008 R2 Standard (x64) - Workgroup
SQL Server 2008 R2 Enterprise (x64) - Mixed Mode
Public facing with Static IP

SUBSCRIBER
Windows 7 Professional (x64) - Workgroup
SQL Server 2008 R2 Developer (x64) - Mixed Mode (Inst = HBH - Unable to uninstall)
SQL Server 2008 R2 Express (x64) - Mixed Mode (Inst = HBH\VHS)

Regards Des Norton

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

Working directly with Microsoft Technical support, it turns out that DISTRIB.EXE is not used with merge replication.

Regards Des Norton

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

Mouse works in one VM but not the other - Keyboard does work

I'm trying to run a Hyper-V network on a Windows Server 2008 R2 Standard machine. I have two VMs running these respective OSs: Windows Server Core 2008 and Windows 7. The Windows Server Core is operating with no problems, but I cannot get the mouse to work inside the Windows 7 VM. The keyboard works fine [tab, space, arrow keys, enter, etc.], but I cannot get the mouse to work properly.

When I click on the Windows 7 desktop or a window, any open windows will disappear. When I click again the windows reappear.

Running Integration Services doesn't correct the problem.

Any troubleshooting step or recommendations would be appreciated.

Changed type Vincent Hu Thursday, March 8, 2012 10:36 AM

Reply:

Hi,

Please help me to collect the following information:

1. What's the version of the Windows 7 running within the virtual machine?
2. Please check the Event Viewer within the problematic Windows 7 virtual machine to see whether you can find any errors.
3. Please check the Event Viewer within the Hyper-V host machine to see whether you can find any Hyper-V related errors.

Vincent Hu

TechNet Community Support

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

Multiple Playback Devices

Multiple or Dual Playback Devices - Seriously. You cannot use 2 playback devices simultaneously? That's nonsense. I LOVE Windows 7... except for this one reason. People NEED this feature of the old XP very badly. To tell you the truth, this is such a basic feature, I'm really surprised Microsoft missed it!!

Windows 7 Microsoft people, you need to fix this with the next update.

This is absolutely crucial to me because I use my computer for an HTPC (home theatre PC) & I'm a dj / producer also.
In order for me to switch between headphones or headset for talking and listening using Realtek AND HTPC output.... I have to restart my computer. ANNOYING. I don't need to switch at all, I need them both to play at the same time!
Lets just keep it simple here and say I wanted to play iTunes to three different devices at once (1 default playback device & 2 additional devices)
Using only 1 communication device. Windows 7 can't do that. This is BASIC stuff to audio noobs, but especially sound mixing professionals. Are we forced to go Linux? Mac? Really? I applaud Windows 7, it's really really great. This is my only problem with it, but it's a big one. Even if it was a maximum of TWO playback options with ONE communication device I would be ok with it. But ONE dedicated playback device is extremely limiting for this stage of technology. I mean come on guys.
PLEASE UPDATE WINDOWS 7 FOR MULTIPLE PLAYBACK DEVICES!!!

Does anyone know of a workaround for this?

Edited by mrscottybizzer Wednesday, September 14, 2011 11:04 PM
Changed type Miya Yao Friday, September 16, 2011 6:32 AM

Reply:

Hi mrscottybizzer,

I noticed you've already seen this thread: http://social.technet.microsoft.com/Forums/en-US/w7itpromedia/thread/d6644d1b-c660-437c-aa52-b73c2ee3900b

We've reported this and appreciate your patience.

Thanks for your understanding and cooperation!

Regards,

Miya

This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

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

While I think Win 7 should have a feature built in to control which application gets output on which audio device it doesn't. How ever it does allow it to be application controlled. Unfortunately the only application I can find that allows this is Win Media Player:

While in WMP press ALT -> Tools -> Options -> Devices -> Speaker -> Select Audio Device

This allows WMP to playback on and alternative device instead of Default Playback Device. So Music or Video can be on another sound device while you game or watch YouTube on default.

I found that DivX Player could be trick by setting Default Playback to Device you want to here the sound on and after DivX is up and running change Default to another Device for all other sound. Doesn't work for iTunes and most other applications.

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

Server 2008R2 stops authenticating to domain, cannot browse, Cannot map, Can ping by hostname, Reboot fixes it for a day

Hello, I have a real annoying problem with a VMWare Virtual 2008R2 server that really needs to go into production.

After anywhere from an hour to a day the server seems to lose SMB completely, it cannot browse the network or the internet, It can ping by hostname, I can VNC to it (RDP fails to authenticate), existing mapped drives say "An error occurred while reconnecting: Microsoft Windows Network:The local device name is already in use (which is not the case) There are other network services which continue to function, the big issue is it's inability to talk to the domain (group policy obviously fails also).

Application & System logs show nothing of any use

Security logs show event 4656 twice every 2 seconds. I have disabled RSS Scaling & Chimnet offload to no avail.

I have replaced the virtual NIC, removed & rejoined the domain, ran all windows updates. Still nothing.

I just ran the "Microsoft Products Support Reports" tool while the problem is occurring, where do I upload the output for somebody smarter than me to look at? I've been doing this stuff for 15 years, never have I seen this problem and I am baffled.

I hate computers, That's why I'm in I.T.

Edit: The "RPC Dump Utility has stopped working" error message while the MS Diag tool is running, this is not going to help me...

Edited by Timothy Cox Friday, March 2, 2012 1:51 PM New Info
Moved by Tiger LiMicrosoft employee Monday, March 5, 2012 6:59 AM (From:Network Infrastructure Servers)
Changed type Tiger LiMicrosoft employee Wednesday, March 7, 2012 2:20 AM

Reply:

Tried disabling the antivirus and the Windows Firewall?

Was this machine created from a cloned, non-Sysprep image?

Is the time service on the VMWare host disabled? It must be disabled. The following is about DCs, but it applies to any guest machine in a VM host.

Virtualizing Domain Controllers and the Windows Time Service
http://msmvps.com/blogs/acefekay/archive/2011/08/23/virtualizing-domain-controllers-and-the-windows-time-service.aspx

Kerberos has a 5 minute skew tolerance. Check the time to see if it matches the DC that logged it on (echo %logonserver%). If it's they're skewed more than 5 minutes, it will cause numerous problems.

I would suggest re-enabling RSS.

Ace Fekay
MVP, MCT, MCITP Enterprise Administrator, MCTS Windows 2008 & Exchange 2007 & Exchange 2010, Exchange 2010 Enterprise Administrator, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This posting is provided AS-IS with no warranties or guarantees and confers no rights.

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

Hi,

Thanks for posting here.

Is this VM domain controller or just a member host? is it multihomed ? have we recently modified any settings on this VM ?

Please try to restart netlogon service and see if it will go to normal:

Net stop NetLogon

Net start Netlogon

Things to consider when you host Active Directory domain controllers in virtual hosting environments

http://support.microsoft.com/kb/888794

Thanks.

Tiger Li

TechNet Community Support

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

Autogrow of file 'SharePoint_Config_log' in database 'SharePoint_Config' took 91047 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

sql server 2005 64 bit sp1

How to fix the problem

Changed type supportsib Saturday, March 3, 2012 11:51 AM

Reply:

Hi, the message is informational and advising that the 'SharePoint_Config_log' log file took 91 seconds to grow.

The reason the message is raised, is that while the log file is growing, no modifications e.g. deletes, updates or inserts can be made in the database.

You have a couple of options

1. as per the message you could review the current autogrowth of the 'SharePoint_Config' log file (look at database properties, files page) and set the autogrowth to a smaller number. and/or

2. review the initial size of the log file and set to be larger, (max size it gets to) so that it doesn't grow as often and typically grows only when the SQL Server starts. and/or

3. If the database 'SharePoint_Config' is using the Full or Bulk-logged recovery model, look at reducing the transaction log backup interval and this may help keep the log file growths down.

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

Thanks

I did a transcation log backup , but it seems the log is not truncating after the backup

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

To be clear, when you perform a transaction log backup it allows committed transactions in the log file to be overwritten. It doesn't shrink the log file, but does allow transactions to use the current uncommitted space in the log file after the log backup. The more often you perform log backups, the more often there is free space in the log file and this helps minimises log growth.

You can check how much space is free in the log file by using DBCC SQLPERF(LOGSPACE)

You can shrink the log file using http://support.microsoft.com/kb/907511

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

Autogrowth is a option which sets the increment level for the files to grow. Shrinking the database is not the solution here. You should revisit the sizing and check if the current disk and database properties such as max size , and autoincrement are sufficient to meet to the additional number of transactions being performed on your database.

If you shrink the database you will simply increase fragmentation and the database will still throw the same error when a large number of transactions are being performed and it needs to grow again. Check fill factors on tables as well as perform bulk operations by switching the recovery model to reduce the impact of such operations.

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

Corrupt Windows Server 2008 R2 Standard, Enterprise, Datacenter, and Web with Service Pack 1 Debug/Checked Build (x64) - DVD ?

I recently downloaded above iso from MSND website.
<label class="detailtitle">File Name: </label><label id="filenameLabel">en_windows_server_2008_r2_standard_enterprise_datacenter_and_web_with_sp1_debug_checked_build_x64_dvd_619600.iso</label>
<label class="detailtitle">Languages: </label><label id="languagesLabel">English</label>
<label class="detailtitle">SHA1: </label><label id="sha1Label">B525BA6B34C7F3701907AE7FAE70D244B5591B70</label>
<label class="detailtitle"></label>

I installed it inside a VM on Hyper-V but I'm getting Ie8 carsh error due to mshtml.dll library.

The program iexplore.exe version 8.0.7601.17514 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
Process ID: 484
Start Time: 01ccf75fb32b5bbe
Termination Time: 31
Application Path: C:\Program Files (x86)\Internet Explorer\iexplore.exe

I'm also getting other weird errors. Looks like ISO is corrupted (based on some responses on web) but I could be wrong here. Any suggestion to resolve this?

Changed type Niki Han Friday, March 9, 2012 8:23 AM

Reply:

Hi,

Please understand here is Windows 7 forum. I notice the issue is related to Windows Server 2008 R2, to get better assistances, I suggest posting in Server Forum.

http://social.technet.microsoft.com/Forums/en-US/category/windowsserver

Niki Han

TechNet Community Support

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

Open provisioninng stantard like SPML

Hi,

Is FIM 2010 support Open provisioninng stantard like SPML if yes please prvide valid link.

Thanks

khalid

Moved by Brent Serbus Wednesday, February 29, 2012 11:48 PM fim q (From:Forums Issues (not product support))
Changed type Markus VilcinskasMicrosoft employee Sunday, March 17, 2013 8:31 AM

Reply:

Wrong forum. Let me know if you want me to move this into a specific forum.

Thanks!

Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)

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

I don't think it can do it directly, as my understanding of SPML implementations is that they are done as a push, but FIM works via a pull from the data source. I'm not that familiar with ECMA 2.0, but I don't believe that fundamental behavior has changed. If you are talking file format processing, FIM does do DMSL 2.0 but that's as close as it would get and that's not necessarily what you've got in SPML.

What we've done with ILM (and likely FIM when we are able to upgrade) is the SPML from the ERP vendor's system is sent to a custom web service which writes the data into an AD/LDS instance that the sync engine reads from. It may sound sort of Rube Goldberg-ish but it's worked well for us in the production environment for nearly two years. It lets the ERP system remain transactional and send updates as it has them, and the sync engine can run in its scheduled way and we don't have to do any special effort to calculate deltas.

Chris

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

Is it a general question regarding capabilities of FIM 2010 or do you have a need to integrate with systems talking SPML?

Because from my point of view, you should not invest in SPML direction if you don't have to.

Check the new SCIM protocol who is promising as Google, SalesForce, Cisco (Webex), Sailpoint, PingIdentity, Courrion, UnbundID, (and us) are all looking at this direction and implementing SCIM.

Just my point of view...

Cordialement,
Emmanuel Dreux
http://www.bcpsoft.fr
Formation FIM 2010

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

Thanks for reply.

Regards

khalid

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

get error for my store procedure

Hi, I got the error message says that "

Msg 245, Level 16, State 1, Line 127

Conversion failed when converting the varchar value 'Systemation' to data type int.

I attached the code

USE [dbMarketing]  GO  /****** Object: StoredProcedure [ui].[spNationalTESReportVerbatimsFacilitator] Script Date: 03/02/2012 09:55:04 ******/  SET ANSI_NULLS ON  GO  SET QUOTED_IDENTIFIER ON  GO  --This is the main details for the SP for the NPS report  /*Name: spNPSReportSummaryDetails  Description: SP for the AD listing on the NPS Summary Report  Author: Mark Poirot  Description     Date   Changed By  ALTERd procedure   2/7/2009 Mark Poirot  */  /*  Exec [ui].[spNPSReportSummaryDetails] @CommaDelimitedString = 'New Psychology of Selling-NPOS', @CourseStartParameter= '1/1/2009', @CourseEndParameter = '4/1/2009'  *//*  ALTER PROCEDURE [ui].[spNationalTESReportVerbatimsFacilitator]  --DECLARE @CourseNameParameter VARCHAR(200)  @CommaDelimitedString VARCHAR (max),  @CourseStartParameter SMALLDATETIME,  @CourseEndParameter SMALLDATETIME,  @StartValueScore TinyInt,  @EndValueScore TinyInt,  @SupervisorLevelParameter VarChar(Max),  @NTIDArea Varchar(20)  AS  SET NOCOUNT ON  */  DECLARE @CommaDelimitedString VARCHAR (max)  DECLARE @CourseStartParameter SMALLDATETIME  DECLARE @CourseEndParameter SMALLDATETIME  Declare @StartValueScore TinyInt  declare @EndValueScore TinyInt  declare @SupervisorLevelParameter VarChar(Max)  DECLARE @NTIDArea Varchar (20)  DECLARE @NationalTESEmployeeCourseVarSUP TABLE (SurveyFacilitatorName INT, SurveyLocationName VARCHAR(200))  DECLARE @NationalTESEmployeeCourseVarCalc TABLE (CalcFacilitator varchar (20), CalcCourseDate SMALLDATETIME, CalcCourseName VARCHAR(200), CalcCommentScore VARCHAR(10), CalcLocationName VARCHAR(200), CalcManagementScore Varchar(10), CalcPresentationScore Varchar(10), CalcEngagementScore Varchar(10), CalcExplanationScore Varchar(10), CalcJobSkillsScore Varchar(10), CalcImprovementScore Varchar(4000), CalcLearningObjectives Varchar(10),/* CalcLogicallyOrganized Varchar(10),*/ CalcLearningEffectiveness Varchar(10), CalcTimeToLearn Varchar(10), CalcJobEffectiveness Varchar(10), CalcIncreasedSuccess Varchar(10) )  SET @CommaDelimitedString = 'Fraud Awareness: Classroom Training'  SET @CourseStartParameter = '2/1/2012'  SET @CourseEndParameter = '2/24/2012'  SET @StartValueScore = '1'  SET @EndValueScore = '5'  SET @SupervisorLevelParameter = '110975'  SET @NTIDArea = 'foxga'  Declare @AreaFilter Varchar(20)  set @AreaFilter = (select AreaID from dbEmployee.Summary.tblEmployeeSnapshot WITH (NOLOCK) where networkID = @NTIDArea)  DECLARE @FacilitatorEmpID INT  SET @FacilitatorEmpId = (Select EmployeeID from dbEmployee.Summary.tblEmployeeSnapshot where   							NetworkID = @NTIDArea)  /* Test Section for the comma delimited string */  DECLARE @CharCount INT   DECLARE @CommaDelimitedResults TABLE (CommaDelimitedString VARCHAR (max))  --SET @CommaDelimitedString = 'Blackberry Storm,Foundations for Business'  -- Add a comma to the end if it is not there already:  IF (SELECT SUBSTRING (@CommaDelimitedString, LEN (@CommaDelimitedString), 1)) <> ','   BEGIN   SET @CommaDelimitedString = @CommaDelimitedString + ','   END  -- ALTER a table to hold results after the data is parsed:  -- Loop and parse the comma delimited string(s):  WHILE (SELECT LEN (@CommaDelimitedString)) >= 1   BEGIN   SET @CharCount = CHARINDEX (',', @CommaDelimitedString, 1)   INSERT INTO @CommaDelimitedResults    SELECT     REPLACE (SUBSTRING (@CommaDelimitedString, 1, @CharCount), ',', '')   SET @CommaDelimitedString = SUBSTRING (@CommaDelimitedString, @CharCount + 1, 50000)   END  --SELECT * FROM @CommaDelimitedResults  ----------------------------------------------------------------------------------------------------------  /* Test Section for the comma delimited string of Supervisor Ids*/  DECLARE @CharCountIDs INT   DECLARE @CommaDelimitedResultsIDs TABLE (SupervisorID VARCHAR (max))  --SET @CommaDelimitedString = 'Blackberry Storm,Foundations for Business'  -- Add a comma to the end if it is not there already:  IF (SELECT SUBSTRING (@SupervisorLevelParameter, LEN (@SupervisorLevelParameter), 1)) <> ','   BEGIN   SET @SupervisorLevelParameter = @SupervisorLevelParameter + ','   END  -- ALTER a table to hold results after the data is parsed:  -- Loop and parse the comma delimited string(s):  WHILE (SELECT LEN (@SupervisorLevelParameter)) >= 1   BEGIN   SET @CharCountIDs = CHARINDEX (',', @SupervisorLevelParameter, 1)   INSERT INTO @CommaDelimitedResultsIDs    SELECT     REPLACE (SUBSTRING (@SupervisorLevelParameter, 1, @CharCountIDs), ',', '')   SET @SupervisorLevelParameter = SUBSTRING (@SupervisorLevelParameter, @CharCountIDs + 1, 30000)   END  --SELECT * FROM @CommaDelimitedResultsIDs  /* This is the code that will determine the distinct facilitator that has taught class X, this will   determine the comparison for the rest of the information*/  INSERT INTO @NationalTESEmployeeCourseVarSUP (SurveyFacilitatorName, SurveyLocationName)  (SELECT DISTINCT Facilitator1, LocationName  FROM Detail.tblNationalTESSurvey as A, @CommaDelimitedResults as B   WHERE (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION   (SELECT DISTINCT Facilitator2, LocationName  FROM Detail.tblNationalTESSurvey as A, @CommaDelimitedResults as B   WHERE (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION   (SELECT DISTINCT Facilitator3, LocationName  FROM Detail.tblNationalTESSurvey as A, @CommaDelimitedResults as B   WHERE (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))   --select * from @NationalTESEmployeeCourseVarSUP  /* This is the code that will determine the facilitator score for course X and just for the specific instance, this will   determine the comparison for the rest of the information*/  INSERT INTO @NationalTESEmployeeCourseVarCalc (CalcFacilitator, CalcCourseDate, CalcCourseName, CalcLocationName, CalcManagementScore, CalcPresentationScore, CalcEngagementScore, CalcExplanationScore, CalcJobSkillsScore, CalcImprovementScore, CalcLearningObjectives,/* CalcLogicallyOrganized,*/ CalcLearningEffectiveness, CalcTimeToLearn, CalcJobEffectiveness, CalcIncreasedSuccess)  (SELECT Facilitator1, CourseDate, CourseName, LocationName, FirstFacilitatorManagement, FirstFacilitatorPresentation, FirstFacilitatorEngagement, FirstFacilitatorExplanation, FirstFacilitatorJobSkills, FirstFacilitatorImprovement, CourseLearningObjectives,/* LogicallyOrganized,*/ LearningEffectiveness, TimeToLearn, JobEffectiveness, IncreasedSuccess   FROM Detail.tblNationalTESSurvey as A inner Join @CommaDelimitedResults as B ON   /*WHERE*/ (a.CourseName = b.CommaDelimitedString) AND (a.CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION all  (SELECT Facilitator2, CourseDate, CourseName, LocationName, SecondFacilitatorManagement, SecondFacilitatorPresentation, SecondFacilitatorEngagement, SecondFacilitatorExplanation, SecondFacilitatorJobSkills, SecondFacilitatorImprovement, CourseLearningObjectives,/* LogicallyOrganized,*/ LearningEffectiveness, TimeToLearn, JobEffectiveness, IncreasedSuccess   FROM Detail.tblNationalTESSurvey as A inner Join @CommaDelimitedResults as B ON  /*WHERE*/ (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION all  (SELECT Facilitator3, CourseDate, CourseName, LocationName, ThirdFacilitatorManagement, ThirdFacilitatorPresentation, ThirdFacilitatorEngagement, ThirdFacilitatorExplanation, ThirdFacilitatorJobSkills, ThirdFacilitatorImprovement, CourseLearningObjectives,/* LogicallyOrganized,*/ LearningEffectiveness, TimeToLearn, JobEffectiveness, IncreasedSuccess   FROM Detail.tblNationalTESSurvey as A inner Join @CommaDelimitedResults as B ON  /*WHERE*/ (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))   --Select * from @NationalTESEmployeeCourseVarCalc  /* This is the block of code that determines the heirarchy of the dataset by AD/Sup/Fac  */     Declare @BaseCalcTable table (  BaseCalcDirector VARCHAR(300),  BaseCalcFacilitator VARCHAR(300),   BaseCalcFacilitatorID VARCHAR(20),   BaseCalcDirectorID VARCHAR(20),   BaseCalcADName VARCHAR(300),   BaseCalcADID VARCHAR(20),   BaseCalcManagerID VARCHAR(20),   BaseCalcManagerName VARCHAR(300),   BaseCalcSupID VARCHAR(20),   BaseCalcSupName VARCHAR(300),   BaseCalcCourseName VARCHAR(300),   BaseCalcCourseDate SMALLDATETIME,   BaseCalcLocationName VARCHAR(300),  BaseCalcCourseLearningObjectives Varchar(10),  --BaseCalcCourseLogicallyOrganized varchar (10),  BaseCalcCourseLearningEffectiveness varchar (10),  BaseCalcCourseTimeToLearn varchar(10),  BaseCalcCourseJobEffectiveness varchar (10),  BaseCalcCourseIncreasedSuccess Varchar (10),  BaseCalcFacilitatorManagementScore Varchar(10),  BaseCalcFacilitatorScoreCount Varchar(10),  BaseCalcFacilitatorPresentationScore Varchar(10),  BaseCalcFacilitatorEngagementScore Varchar(10),  BaseCalcFacilitatorExplanationScore Varchar(10),  BaseCalcFacilitatorJobSkillsScore Varchar(10),  BaseCalcFacilitatorImprovementScore Varchar(4000)  )  Insert into @BaseCalcTable(  BaseCalcDirector,  BaseCalcFacilitator,   BaseCalcFacilitatorID,   BaseCalcDirectorID,   BaseCalcADName,   BaseCalcADID,   BaseCalcManagerID,   BaseCalcManagerName,   BaseCalcSupID,   BaseCalcSupName,   BaseCalcCourseName,   BaseCalcCourseDate,  BaseCalcLocationName,  BaseCalcCourseLearningObjectives,  --BaseCalcCourseLogicallyOrganized,  BaseCalcCourseLearningEffectiveness,  BaseCalcCourseTimeToLearn,  BaseCalcCourseJobEffectiveness,  BaseCalcCourseIncreasedSuccess,  BaseCalcFacilitatorManagementScore,  BaseCalcFacilitatorScoreCount,  BaseCalcFacilitatorPresentationScore,  BaseCalcFacilitatorEngagementScore,  BaseCalcFacilitatorExplanationScore,  BaseCalcFacilitatorJobSkillsScore,  BaseCalcFacilitatorImprovementScore  )  SELECT Level24Name,   dbo.udfEmployeeIDtoEmployeeName(SurveyFacilitatorName) AS FacilitatorName,   SurveyFacilitatorName,   Level24ID,   Level20Name,   Level20ID,   Level16ID,   Level16Name,   Level04ID,   Level04Name,   CalcCourseName,   CalcCourseDate,   CalcLocationName,      CalcLearningObjectives,   --CalcLogicallyOrganized,   CalcLearningEffectiveness,   CalcTimeToLearn,   CalcJobEffectiveness,   CalcIncreasedSuccess,  -------------------------------------------------------------------------------------------------------------  --New Questions  -------------------------------------------------------------------------------------------------------------  CalcManagementScore,  Case When CalcManagementScore != 0   Then 1    Else 0   End as FacCount,  CalcPresentationScore,  CalcEngagementScore,  CalcExplanationScore,  CalcJobSkillsScore,  CalcImprovementScore  FROM @NationalTESEmployeeCourseVarSUP AS a   inner join  (Select   Employeeid,    Level24ID,   Level24Name,   Level20Name,   Level20ID,   Level16ID,   Level16Name,   Level04ID,   Level04Name,   AreaID   from   dbEmployee.Summary.tblEmployeeSnapshot WITH (NOLOCK),  @CommaDelimitedResultsIDs as d   Where ((Level24ID = d.supervisorID) Or (Level20ID = d.supervisorID) OR (Level16ID = d.supervisorID) Or (Level04ID = d.supervisorID))   Group by Employeeid, Level24ID,Level24Name ,Level20Name,Level20ID, Level16ID,Level16Name,Level04ID,Level04Name,AreaID) as b  on a.SurveyFacilitatorName = b.EmployeeID  inner join @NationalTESEmployeeCourseVarCalc as c on a.SurveyFacilitatorName = c.CalcFacilitator  Where c.CalcLocationName = a.SurveyLocationName And b.AreaID = @AreaFilter  --select @AreaFilter  --select * from @BaseCalcTable  Declare @AveTable table (  AveCalcDirector VARCHAR(300),  AveCalcFacilitator VARCHAR(300),   AveCalcFacilitatorID VARCHAR(20),   AveCalcDirectorID VARCHAR(20),   AveCalcADName VARCHAR(300),   AveCalcADID VARCHAR(20),   AveCalcManagerID VARCHAR(20),   AveCalcManagerName VARCHAR(300),   AveCalcSupID VARCHAR(20),   AveCalcSupName VARCHAR(300),   AveCalcCourseName VARCHAR(300),   AveCalcCourseDate SMALLDATETIME,   AveCalcLocationName VARCHAR(300),  OverallAveScore int,  OverallAveCourseScore int,  AveCalcCourseLearningObjectives Varchar(10),  --AveCalcCourseLogicallyOrganized Varchar(10),  AveCalcCourseLearningEffectiveness Varchar(10),  AveCalcCourseTimeToLearn Varchar(10),  AveCalcCourseJobEffectiveness Varchar(10),  AveCalcCourseIncreasedSuccess Varchar(10),  AveCalcFacilitatorManagementScore Varchar(10),  AveFacilitatorScoreCount Varchar(10),  AveCalcFacilitatorPresentationScore Varchar(10),  AveCalcFacilitatorEngagementScore Varchar(10),  AveCalcFacilitatorExplanationScore Varchar(10),  AveCalcFacilitatorJobSkillsScore Varchar(10),  AveCalcFacilitatorImprovementScore Varchar(4000)  )  Insert into @AveTable (  AveCalcDirector,  AveCalcFacilitator,   AveCalcFacilitatorID,   AveCalcDirectorID,   AveCalcADName,   AveCalcADID,   AveCalcManagerID,   AveCalcManagerName,   AveCalcSupID,   AveCalcSupName,   AveCalcCourseName,   AveCalcCourseDate,   AveCalcLocationName,  OverallAveScore,  OverallAveCourseScore,  AveCalcCourseLearningObjectives,  --AveCalcCourseLogicallyOrganized,  AveCalcCourseLearningEffectiveness,  AveCalcCourseTimeToLearn,  AveCalcCourseJobEffectiveness,  AveCalcCourseIncreasedSuccess,  AveCalcFacilitatorManagementScore,  AveFacilitatorScoreCount,  AveCalcFacilitatorPresentationScore,  AveCalcFacilitatorEngagementScore,  AveCalcFacilitatorExplanationScore,  AveCalcFacilitatorJobSkillsScore,  AveCalcFacilitatorImprovementScore  )  select   BaseCalcDirector,  BaseCalcFacilitator,   BaseCalcFacilitatorID,   BaseCalcDirectorID,   BaseCalcADName,   BaseCalcADID,   BaseCalcManagerID,   BaseCalcManagerName,   BaseCalcSupID,   BaseCalcSupName,   BaseCalcCourseName,   BaseCalcCourseDate,   BaseCalcLocationName,  (cast(BaseCalcFacilitatorManagementScore as int) + cast(BaseCalcFacilitatorPresentationScore as int) + cast(BaseCalcFacilitatorEngagementScore as int) + cast(BaseCalcFacilitatorExplanationScore as int) + cast(BaseCalcFacilitatorJobSkillsScore as int)) / 5 as AveScore,  (/*cast(BaseCalcCourseLogicallyOrganized as int) + */cast(BaseCalcCourseLearningObjectives as int) + cast(BaseCalcCourseLearningEffectiveness as int) + cast(BaseCalcCourseTimeToLearn as int) + cast(BaseCalcCourseJobEffectiveness as int) + cast(BaseCalcCourseIncreasedSuccess as int)) / 6 as AveCourseScore,  BaseCalcCourseLearningObjectives,  --BaseCalcCourseLogicallyOrganized,  BaseCalcCourseLearningEffectiveness,  BaseCalcCourseTimeToLearn,  BaseCalcCourseJobEffectiveness,  BaseCalcCourseIncreasedSuccess,  BaseCalcFacilitatorManagementScore,  BaseCalcFacilitatorScoreCount,  BaseCalcFacilitatorPresentationScore,  BaseCalcFacilitatorEngagementScore,  BaseCalcFacilitatorExplanationScore,  BaseCalcFacilitatorJobSkillsScore,  BaseCalcFacilitatorImprovementScore  from @BaseCalcTable  --select * from @BaseCalcTable  select * from @AveTable where OverallAveScore between @StartValueScore and @EndValueScore  /*  select AveCalcDirector,  AveCalcFacilitator,   AveCalcFacilitatorID,   AveCalcDirectorID,   AveCalcADName,   AveCalcADID,   AveCalcManagerID,   AveCalcManagerName,   AveCalcSupID,   AveCalcSupName,   AveCalcCourseName,   AveCalcCourseDate,   AveCalcFacilitatorScore,   AveCalcLocationName,  OverallAveScore,  case when OverallAveScore <= 6  Then 1   Else 0  End as OverallDetractor,  case when OverallAveScore > 6 and OverallAveScore <= 8  Then 1   Else 0  End as OverallPassive,  case when OverallAveScore > 8  Then 1   Else 0  End as OverallPromoter,  AveCalcCourseScore,  case when OverallAveCourseScore <= 6  Then 1   Else 0  End as OverallCourseDetractor,  case when OverallAveCourseScore > 6 and OverallAveCourseScore <= 8  Then 1   Else 0  End as OverallCoursePassive,  case when OverallAveCourseScore > 8  Then 1   Else 0  End as OverallCoursePromoter,  AveCalcCourseLearningObjectives,  AveCalcFacilitatorManagementScore,  AveCalcFacilitatorBalanceScore,  AveCalcFacilitatorPracticeScore,  AveCalcFacilitatorApplicationScore  from @AveTable  -----------------------------------------------------------------------------------------------  -----------------------------------------------------------------------------------------------  -----------------------------------------------------------------------------------------------*/  --select * from @NEATNPSEmployeeCourseVarSUP  --select * from @NEATNPSEmployeeCourseVarCalc  --WHERE   --(a.SurveyFacilitatorName = (b.EmployeeID)) AND (c.CalcFacilitator = (b.EmployeeID)) AND (a.SurveyFacilitatorName = (c.CalcFacilitator))   --ORDER BY SurveyFacilitatorName  --Attempts at getting the count for the faciltators, passives, and detractors  /*  SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc   WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '0' AND '6')   SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc   WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '7' AND '8')  SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc as a, detail.tblSurvey as b   WHERE (a.CalcCourseName=b.CourseName) AND (CalcCourseDate = b.CourseDate) AND (CalcFacilitator = b.Facilitator1) AND (CalcFacilitatorScore BETWEEN '0' AND '6')  /*SELECT DISTINCT Level16ID, Level16Name  FROM @NEATNPSEmployeeCourseVarSUP AS a, dbEmployee.Summary.tblEmployeeSnapshot AS b WITH (NOLOCK)  WHERE   (a.SurveyFacilitatorName = (b.EmployeeID)) AND (b.Level20ID = ('199394'))*/  */  --Select * from #NEATNPSEmployeeCourseVar  --Select *  --from detail.tblsurvey  --where coursename='test 3'  /*  @CourseNameParameter VARCHAR(200),  @CourseStartParameter SMALLDATETIME,  @CourseEndParameter SMALLDATETIME  AS  DECLARE @NEATNPSEmployeeCourseVarSUP TABLE (SurveyFacilitatorName INT, SurveyFacilitatorCourseName VARCHAR(200), SurveyFacilitatorCourseDate SMALLDATETIME, SurveyFacilitatorLocationName VARCHAR(200))  DECLARE @NEATNPSEmployeeCourseVarCalc TABLE (CalcFacilitator INT, CalcCourseDate SMALLDATETIME, CalcCourseName VARCHAR(200), CalcFacilitatorScore INT, CalcCommentScore INT)  /* This is the code that will determine the distinct facilitator that has taught class X, this will   determine the comparison for the rest of the information*/  INSERT INTO @NEATNPSEmployeeCourseVarSUP (SurveyFacilitatorName, SurveyFacilitatorCourseName, SurveyFacilitatorCourseDate, SurveyFacilitatorLocationName)  (SELECT DISTINCT Facilitator1, CourseName, CourseDate, LocationName  FROM Detail.tblSurvey  WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION   (SELECT DISTINCT Facilitator2, CourseName, CourseDate, LocationName  FROM Detail.tblSurvey   WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION   (SELECT DISTINCT Facilitator3, CourseName, CourseDate, LocationName  FROM Detail.tblSurvey  WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  /* This is the code that will determine the facilitator score for course X and just for the specific instance, this will   determine the comparison for the rest of the information*/  INSERT INTO @NEATNPSEmployeeCourseVarCalc (CalcFacilitator, CalcCourseDate, CalcCourseName, CalcFacilitatorScore, CalcCommentScore)  (SELECT Facilitator1, CourseDate, CourseName, FirstFacilitatorScore, ContentScore  FROM Detail.tblSurvey  WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION ALL  (SELECT Facilitator2, CourseDate, CourseName, SecondFacilitatorScore, ContentScore  FROM Detail.tblSurvey   WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))  UNION ALL  (SELECT Facilitator3, CourseDate, CourseName, ThirdFacilitatorScore, ContentScore  FROM Detail.tblSurvey  WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter))   --Select * from #NEATNPSEmployeeCourseVar  /* This is the total query block that will determine the overall dataset*/  /*SELECT DISTINCT SurveyFacilitatorName,   CourseName,   CourseDate,   ContentComment,   (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorCount,   (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '9' AND '10') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS PromoterCount,   JobEffectivenessComment,   --(select count() from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorFacilitatorCount,   --(select count(ContentScore) from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS PromoterFacilitatorCount,   DeliveryMethodPreferred,   AdditionalComments  FROM @NEATNPSEmployeeCourseVarSUP AS a, detail.tblSurvey as b  WHERE (((a.SurveyFacilitatorName = b.Facilitator1) OR   		(a.SurveyFacilitatorName = b.Facilitator2) OR   		(a.SurveyFacilitatorName = b.Facilitator3)) AND    ((b.CourseName = 'test 2') AND (b.CourseDate = '1/19/2009'/*BETWEEN '1/1/2009' AND '3/1/2009'*/)))*/  /* This is the block of code that determines the heirarchy of the dataset by AD/Sup/Fac  */   SELECT DISTINCT Level36Name,   dbo.udfEmployeeIDtoEmployeeName(SurveyFacilitatorName) AS FacilitatorName,   SurveyFacilitatorName,   Level24ID,   Level20Name,   Level20ID,   Level16ID,   Level16Name,   Level04ID,   Level04Name,   SurveyFacilitatorCourseName,   SurveyFacilitatorCourseDate,   SurveyFacilitatorLocationName,   CalcFacilitatorScore,   Case When CalcFacilitatorScore <= 6   Then 1    Else 0   End as FacilitatorDetractor,   Case When CalcFacilitatorScore >6 and CalcFacilitatorScore <=8   Then 1    Else 0   End as FacilitatorPassive,   Case When CalcFacilitatorScore >8   Then 1    Else 0   End as FacilitatorPromoter,   CalcCommentScore,   Case When CalcCommentScore <= 6   Then 1    Else 0   End as CourseDetractor,   Case When CalcCommentScore >6 and CalcCommentScore <=8   Then 1    Else 0   End as CoursePassive,   Case When CalcCommentScore >8   Then 1    Else 0   End as CoursePromoter  -- (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorCount,  -- (select count(ContentScore) from detail.tblSurvey where ((ContentScore Between '9' AND '10') AND (coursename = 'test 2') AND CourseDate between '1/1/2009' and '2/3/2009')) AS PromoterCount  --(select count(CalcFacilitatorScore) from @NEATNPSEmployeeCourseVarCalc AS where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorCount,  -- (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '9' AND '10') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS PromoterCount  FROM @NEATNPSEmployeeCourseVarSUP AS a,     dbEmployee.Summary.tblEmployeeSnapshot AS b WITH (NOLOCK),  	 @NEATNPSEmployeeCourseVarCalc as c  WHERE   ((a.SurveyFacilitatorName = (b.EmployeeID)) AND (c.CalcFacilitator = (b.EmployeeID)) AND (a.SurveyFacilitatorCourseDate = c.CalcCourseDate))   --Attempts at getting the count for the faciltators, passives, and detractors  /*  SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc   WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '0' AND '6')   SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc   WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '7' AND '8')  SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc as a, detail.tblSurvey as b   WHERE (a.CalcCourseName=b.CourseName) AND (CalcCourseDate = b.CourseDate) AND (CalcFacilitator = b.Facilitator1) AND (CalcFacilitatorScore BETWEEN '0' AND '6')  /*SELECT DISTINCT Level16ID, Level16Name  FROM @NEATNPSEmployeeCourseVarSUP AS a, dbEmployee.Summary.tblEmployeeSnapshot AS b WITH (NOLOCK)  WHERE   (a.SurveyFacilitatorName = (b.EmployeeID)) AND (b.Level20ID = ('199394'))*/  */  --Select * from #NEATNPSEmployeeCourseVar  --Select *  --from detail.tblsurvey  --where coursename='test 3'  */

Reply:

I presume you are getting this error when you are passing parameters from a report to this stored procedure...

Check the data types of the parameters you have for the report to be matching correctly with the mapped parameters of the dataset.

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

Tuesday, March 1, 2022

Windows XP clients are unable to talk to an application on Windows 2008 Server

Windows XP clients are unable to talk to an application on Windows 2008 Server

Need it be this hard?

Created temp tables to move Source to Desitnation

Proposal for a new installation option in Windows Server 8

Exchange 2003 support

some vms are not running in Hyper-v

Counter in emai ID

Dual-boot Bonuses

WSP

Advanced Topics in Biztalk Server 2009

WATK\Labs\HPCParametricSweep bug

Controlling Permissions on Enterprise Wiki

Sub report visibility

Med-V implementation for Windows 7 with SCCM 2007

Unable to add user in FBA site !!! :(

How to access uploaded files and data entered via web-form from a 'SharePoint Internet' site to a 'Sharepoint Intranet' site?

How to add multiple counters in a single Windows performance rule in SCOM 2007 R2

Allow me to share...

Rename attribute flow error status does not cause sync error when provisioning disabled

Skype

Links

Links

Software Updates

SUP Deployment limitations

Need the paid services of a SQL expert - where should I go??

How to disable the Save Embedded Files Dialog

[Solved] Troubles with Routing and IP-Spoofing

Create a degenerate dimension

Web pages slow to load with TMG 2010 acting as Proxy

Metadata Column mapping and values missing in Publishing farm

How to omplement google map locator webpart in sharepoint

Windows updates + controls

TCP loss under load?

Distrib.exe error

Mouse works in one VM but not the other - Keyboard does work

Multiple Playback Devices

Server 2008R2 stops authenticating to domain, cannot browse, Cannot map, Can ping by hostname, Reboot fixes it for a day

Autogrow of file 'SharePoint_Config_log' in database 'SharePoint_Config' took 91047 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

Corrupt Windows Server 2008 R2 Standard, Enterprise, Datacenter, and Web with Service Pack 1 Debug/Checked Build (x64) - DVD ?

Open provisioninng stantard like SPML

get error for my store procedure

Setup is Split Across Multiple CDs