.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Does VS 2010 SP1 resolve any SQL/CLR issues?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I'm really hoping it does, because there are a few nasty ones:

1. Whenever I click on a test .sql script in the IDE (e.g. to invoke a managed proc or force a trigger to run) the Visual Stduio IDE insists on running a deploy, which takes ages, even though I have made no chnages at all since my last debug session.

2. Even once I have got past this stage (patiently waiting for the deploy) the debug session runs very slow, even single stepping through simple variable assignments takes a second or two each.

3. The [SqlTrigger] attribute is implemented poorly, I always get errors when I use thus because it has buggy handling of schema names.

4. In my solution, each time I deploy the system gens a ALTER ASSEMBLY command to upgrade the assembly binary. However this always fails (error code 6541) with: "ALTER ASSEMBLY failed because assembly 'SqlClrAssembly' has more than one file associated with it. Use ALTER ASSEMBLY DROP FILE to remove extra files."

5. This is just getting worse! I was able yesterday to use Attach To Process, set a breakpoint in my trigger src code (C#) and then run a query in SQL Server Mgmt Studio, this cased the breakpoint to get hit and I was able to debug reasonably well. Today

View Complete Post

More Related Resource Links

Issues with Visual Studio 2010 editor


hi all,

I am having a weird problem with VS 2010. I am using the premium edition.

It seems that none of the asp controls <asp:..> tag are recognized by the editor. I keep getting a green underline under each control name. To check this, I have created a brand new web site targeting .NET framework 4.0 and even in the auto-generated pages, none of the asp controls is recognized. I am also unable to see the properties of any control if I click inside the tag (at an attribute). All I get is the ID of the button and the tag <HTML ELEMENT>! Furthermore, when I drop an ASP control from the toolbox, the attribute "ID" is not generated. Only when I switch to the design view that I can get to see the properties of the control and the ID is set automatically. The message for the green underline says: Element 'Button' is not a known element. This can occur if there is a compilation error in the Web Site, or the web.config file is missing.

Does anyone know what is going on?





Issues with SharePoint 2010 Installation


Hi All,

I have got error while installing sharePoint 2010 as follows and answer also present below,but i could not able to find the patch as mentioned in the solution below I.e: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\UpdateExeVolatile"

I my machine is not the base machine its a VM running with Windows Server 2008 standard and SQL Server 2008 R2......

ANy help much appreciated...

ISSUE #3:  when running Setup.exe for Microsoft SharePoint Server 2010 you may experience the error:

Setup is unable to proceed due to the following error(s):
A system restart from a previous installation or update is pending. Restart your computer and run setup to continue.
For the list of pre-requisites needed to install the product please refer to:
Correct the issue(s) listed above and re-run setup.

Check the value of the following Registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\UpdateExeVolatile - if the value of the UpdateExeVolatile Registry key is anything other than 0 you will see this message.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Pendi

VS 2010 and data source issues

I've been banging my head against the wall for the past 4 hours on this one and think I'm going to need a little help here. I must be missing something. I'm in VS 2010 on Windows 7. I've got a web project which has been going fine, but no matter what I do I can't get a data source to show up in the Data Source window. I've added a data source using Data > Add New Data Source, and the "wizard" appeared to complete successfully. I have a data source showing in my solution explorer, and if I open the .xsd file I see all my tables from a remote SQL 2005 database. I have a good data connection to the database server showing up in the Server Explorer window. But no matter what I do I cannot get anything to appear in the Data Sources window, which is greyed out (the commands at the top are grayed out and there's gray text in the middle of the window reading "There are no data sources to show for the selected project"). Under the main Data menu at the top of VS, the "Show Data Sources" and "Add New Data Source" commands are missing. I can sometimes get them to reappear if I restart Visual Studio or reboot the OS, but not consistently. I've been all over Google on this and have tried every suggested solution I can find, to no avail. Anybody have any ideas? Thanks.

Sharepoint 2010 - RSS Viewer Web Part has some AJAX issues

Hi, I've this problem in RSS Viewer. If you select the "Enable Asynchronous Automatic Refresh?" checkbox, the Web Part will not render properly, but will give an error: "An unexpected error occured while rendering the webpart." Anybody ever had this problem? Tks,

SharePoint 2010 install issues with english 1033

Hi,Im running into searious issues installing the SP2010 foundation, error im getting is :Microsoft Sharepoint Foundation 2010 1033 Lang Pack cannot install one of its requierd products. Contact your technical support group.I ran out of ideas,The server is localized to EN-US, evreything is standard, running with Win2008 SP2 + SQL 2008, all the rest of the prerequierd setups passed sucesfullyPlease Advise!The log file writes the following: MSI(INFO): 'Property(S): LogonUser = spadmin' MSI(INFO): 'Property(S): UserSID = S-1-5-21-776561741-1085031214-1177238915-48444800' MSI(INFO): 'Property(S): UserLanguageID = 1033' MSI(INFO): 'Property(S): ComputerName = RVIL-MOSS2010' MSI(INFO): 'Property(S): SystemLanguageID = 1033' MSI(INFO): 'Property(S): ScreenX = 1024' MSI(INFO): 'Property(S): ScreenY = 768' MSI(INFO): 'Property(S): CaptionHeight = 19' MSI(INFO): 'Property(S): BorderTop = 1' MSI(INFO): 'Property(S): BorderSide = 1' MSI(INFO): 'Property(S): TextHeight = 16' MSI(INFO): 'Property(S): TextInternalLeading = 3' MSI(INFO): 'Property(S): ColorBits = 32' MSI(INFO): 'Property(S): TTCSupport = 1' MSI(INFO): 'Property(S): Time = 18:41:31' MSI(INFO): 'Property(S): Date = 11/17/2009' MSI(INFO): 'Property(S): MsiNetAssemblySupport = 2.0.50727.4016' MSI(INFO): 'Property(S): MsiWin32AssemblySupport = 6.0.6001.18000' MSI(INFO): 'Property(S): RedirectedD

Issues when booting SP 2010 Microsoft Preconfigured VHD with Sun VirtualBOX

guys, Environment : host OS : windows 7 pro 64 bit sun virtual box 3.2.8 (latest with windows 2008 64 bit support0 Sharepoint 2010 I dont have windows 2008\ HyperV so i am trying to load the sharepoint 2010 preconfigured VHD on my windows 7 box using sun virtualBOX. i downloaded all the 20 files for option "a" from the microsoft site( http://www.microsoft.com/downloads/en/details.aspx?FamilyID=751fa0d1-356c-4002-9c60-d539896c66ce&displaylang=en) , extracted the files, started up VirtualBox, allocated it around 4GB RAM or more, selected windows 2008 64 bit as the OS then when i try to boot the SP 2010 VHD VirtualBOX shows me a blue screen of death, restarts, show me two optons "launch startup Repair" and "start normally", starting nomarlly shows blue screen of death but when i select startup repair it asks me for Recovery CD which ofcourse there is none after selcting the keyboard type which is "US" . Question is what am i doing wrong, i heard that lots of people have used VHD in virtualBox and it seems to be working fine? Any help is appreciated, i have downloaded all the vhd files twice and also extracted them twice, what could go wrong? thanks sameer

Issues with updating Lists with Manager Names and User Profile Imports in SharePoint 2010 Server

I am having a curious problem with SharePoint 2010 Server. I have imported all the user profiles of our organization into SharePoint User Profile Service Application from our Active Directory. When the Manager name imports it comes in as domain/login. The organizational browser seems to work for MOST people, but not all. I believe this is contributing to my second problem, which is, I have setup a very simple workflow in SharePoint Designer that simply looks up the persons Manager, then places that information into a field called "Approval 1". After that it looks at Approval 1 and get the Manager name and populated "Approval 2" with that information, and so on. I have used an Impersonation Step as the Farm Administrator in the workflow and I have done it without the impersonation step. Both results in the same problem. When I enter my name into the list and run the workflow it runs beautifully give every manager up the chain to the top. However, if I put any other person's name in there it gives me the error "Workflow failed to get user profile for user: ____". I went to my supervisor's office and asked him to run the workflow. Using his login he had the exact same result--if my name was in there it worked great, otherwise, it gave an error. Any help with this strange error would be greatly appreciated.  Thanks

format-number issues with the Data View Web Part in SharePoint 2010

I have a number column named @Year_x0020_1_x0020_Revenue in the data view web part in SharePoint Designer 2010. In the Xpath expression builder - @Year_x0020_1_x0020_Revenue previews "500,000" If I use the format-number in the Xpath expression builder ==> format-number(@Year_x0020_1_x0020_Revenue, '$#,##0.00;-$#,##0.00'), it returns NaN. Is there any reason? 

SharePoint 2010 Profile Synchronization Issues

Hi Guys, I hope you can give me a hand on this. I am having a synchronization issue and it has me puzzled.  I have my moss server up and running without any issue.  It is even being used by departments already…which is great…documents are being uploaded…my sites created…department pages…etc.  Around mid-July I set up the user synchronization with AD…which worked fine.  I was able to set up profile synching without any issues…  The issue I am having now is that the profile syncing is no longer running for some reason.  When I click on Configure Synchronization connections, my old connection isn’t there anymore…so I click new and get the following message.   "Cannot navigate to the requested page while user profile synchronization is running.  Please wait for the current Synchronization to finish"   when i check my Profile Sync Settings, i see that User profile sync is not currently provisioned...and the incremental sync schedule is disabled.   And when I check the running jobs…I do not have any jobs running.   And finally, when I check the services running on the MOSS server, my User Profile Synchronization Service is sitting on stopped…and when I click start…it stays on starting for about 15 mins…and then goes back to stopped

create task edit form issues for sharepoint 2010 workflow using visual studio 2010

I use infopath 2007 created a task edit form and I use VS 2010 to create a sequential workflow.I want to use the custom tash edit form in the workflow.The problem I got is the InfoPath form doesn't get deployed to sharepoint. I'm able to upload the infopath form to sharepoint though central admin app. here is the element.xml :<Elements xmlns="http://schemas.microsoft.com/sharepoint/">  <Workflow     Name="WorkflowProject4 - Workflow1"     Description="My SharePoint Workflow"     Id="e6aa6cdb-667f-456a-b216-7639a1dcd3c7"     CodeBesideClass="WorkflowProject4.Workflow1.Workflow1"     CodeBesideAssembly="$assemblyname$">    <Categories/>    <MetaData>      <AssociationCategories>List</AssociationCategories>            <Task0_FormURN>urn:schemas-microsoft-com:office:infopath:TaskForm:-myXSD-2009-12-10T22-33-23</Task0_FormURN>      <StatusPageUrl>_layouts/WrkStat.aspx</StatusPageUrl>    </MetaData>  </Workflow></Elements>and here is the feature1.template.xml<Feature xmlns="http://schemas.microsoft.com/sharepoint/">  <Properties>    <Property Key="GloballyAvailable" Value="true" />    <Property Key="RegisterForms" Value="*.xsn"/>  </Properties></Feature>anything

Issues connecting SharePoint Workspace 2010 with SharePoint 2010

Has anyone tried using sharepoint 2010 client with networksolutions sharepoint 2007 server? i recently updated to office 2010 and also decided to start using sharepoint as it seems to be a great way to get things done with the team i manage internationally. Problem is that when i signed up for the sharepoint server service with network solutions it turns out that they are using sharepoint server 2010. every time i try to connect to the server using sharepoint 2010 from my desktop i get the following error message "sharepoint workspace cannot sync with the specified sharepoint site because its server version is not supported". I'm using office 2010 14.0.4760.1000 (32-bit). Can you guys let me know what i can do (besides downgrading sharepoint 2010 to 2007) to actually connect? surely i don't have to downgrade what i just bought to get this done? Any help appreciated.

Sharepoint Server 2010 issues


Hi, I am trying to implement these recommendations on a Sharepoint 2010 farm. I cannot get it to work. I have created a test site manually and got that to work however.

Has anyone else been able to get this working with Sharepoint 2010? 

The only deviation from the published instructions is that I have tried to edit the system.webserver.httperrors section in case this has some bearing but it doesnt seem to have made any difference. I just keep getting 404 errors.



SharePoint sync with Project 2010 - issues


I am having some issues with syncing project 2010 and sharepoint.

The following scenario works well...

Create plan.
Sync to sharepoint list.
Save Project file.

However the following scenario  does not work well...

Create plan.
Sync to Sharepoint list.
Forget to save project file.

When i re-open project file and sync, i get the error...

The task list was last synchronized to a different project plan. If you continue the task list will be appended to the project plan.
If I continue at this stage then i get a naming error.

One workaround is to delete all the project plan tasks and re-sync.
This brings all the sharepoint tasks back into the project file..
However, I cannot use the existing milestone field in SharePoint to sync with the project file.

Is there any way to sync project fields into existing columns in SharePoint?

I do not want to create a new column as i have a number of views with the old milestone column as part of a filter.

Any ideas?

What compatibility issues present with MOSS 2007 and Office 2010?

We have been running MOSS 2007 for a year now and recently upgraded office workstations to Office 2010.  I am trying to research what compatibility issues might be experienced with this match of products.  Thank you for any examples.

Issues Exposing Excel Contents and SharePoint 2010


I have an Excel spreadsheet and I want to use it to trigger a work flow ... BUT ... I don't want to just use the creation or modification of it to trigger the work flow ... I want some data in the sheet to trigger it. 

I followed some How-To's and was able to get to the point where I set up a Site Column and associated it to a Custom Content Type (i.e.: my Excel sheet) and when someone creates a new document this is loaded with the ability to manually enter the value in the Document Properties bar that appears.  Great ... but why would I want to manually enter the value again when I have already have it in a cell below.  I thought, OK a little more work to do and I am done.

So, after some research, I learned that I have to create, and link, a Named Cell Range and Custom Field in my Excel document and then expose that to SharePoint. I was referenced to this article (http://tinyurl.com/29l98rl) and performed the steps as outlined ... and thought, "Great that was easy ... I am done !!"

Well ... that wasn't quite true.  After testing this out I soon realized that the data in the cell was not being populated into the Site Column and thus was not being populated back to SharePoint.  So I went back and double checked it and am pretty sure that I d

Outlook 2010 Discussion Board integration - Synchronization issues


I have experienced the following situation:

  1. "Connect to Outlook" a discussion board from ClientPC1
  2. Change (add/delete) items discussion board entries from ClientPC2
  3. Back at ClientPC1 , ensure all folders are synchronized.

All items are not, for example, 'Removed' from the SharePoint information store list on Outlook on ClientPC1

The items are correctly reported on the SharePoint site.

WSS 3.0

Outlook 2010

SharePoint 2010 Upgraded database Issues


Hi all,

I am having SharePoint 2010 upgraded database, I have already enabled workflow service in web application features page. But I can view default workflow templates, like approval workflow.. etc. But new web application got this feature. Please advice.

Thank You

A. Shilambuselvan

A. Shilambuselvan
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend