Monday, 15 October 2012

View user permissions in SQL SERVER

Hi, To check your permissions just run the following queries and you'll get a list of assigned permissions SELECT * FROM fn_my_permissions(NULL, 'SERVER'); USE YourDatabaseName; SELECT * FROM fn_my_permissions (NULL, 'DATABASE'); GO

Tuesday, 10 April 2012

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. (0xC0209303)

Whenever this error happens

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.   failed with error code 0xC0209303


Check you connection string if the provider is
;Provider=sqlncli10.1

In my case the was because I had a connection string with Provider=SQLNCLI.1 from Integration 2005 and when I upgraded to 2008 didn't change it.

It took me along time to find this out hope it helps

Tuesday, 12 April 2011

Error when workflow is running in publishing page

I had a custom workflow associated with a content type  used by a publishing page, that gave this error

[NullReferenceException: Object reference not set to an instance of an object.] Microsoft.SharePoint.Publishing.Internal.WorkflowUtilities.GetAssociationDataValue(CachedWorkflow workflow, String xmlNodeName) +124


Digging throught the web I found a solution.


We need to had this association data to the workflow


<my:myFields xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:my=\"http://schemas.microsoft.com/office/infopath/2003/myXSD\" xml:lang=\"en-us\"><my:ItemChangeStop>false</my:ItemChangeStop></my:myFields>


Apparently Sharepoint is looking for node called "ItemChangeStop"


Thanks to Julien C (http://www.sharepointdev.net/sharepoint--workflow/sharepoint-error-when-editing-documents-with-custom-content-types-44343.shtml)


Somewhere else people talked about and hotfix from microsot that isn't available on the web ...

Thursday, 17 March 2011

Error using TextAlignment="Justify"

When using TextAlignment="Justify" in a  TextBlock a windows phone application unexpectedly exits.

After some digging apparently this alignment isn't supported on this control. Although appear as an option is a bug.

Saturday, 6 November 2010

How to Configure Simple Network Time Protocol (SNTP)

Just run the following commands


NET TIME /SETSNTP:time.windows.com
NET STOP W32TIME
NET START W32TIME
W32TM /config /reliable:YES
W32TM /resync /rediscover

Just replace time.windows.com with closest atomic clock address

For instance for Portugal the address is "ntp02.oal.ul.pt"

Wednesday, 20 October 2010

SQL Server 2000, 2005 intellisense and snippets

In SQL Server 2008 there's a cool feature that improves productivity alot, intellisense or code completion as some people call it. But in the early versions there's nothing. In my daily work I use a lot SQL Server 2000 e SQL Server 2005.

I found the following aplication that does the trick, unfortunately there only a trial version,

SQL Prompt

Digging through I found out that old version 2.0.0.59 is free.For me it's good enough.

Download it for free HERE

Saturday, 16 October 2010

Content Management Server 2002 stand-alone template explorer

Several peolpe told me that they couln't load the template explorer even with cmsEnable="1" in the  Vwd.webinfo file when opening a MCMS 2002 Project in Visual Studio 2005.


After some digging I found out that there was a stand alone MCMS template explorer available


Check the site Tools for Content Management Server 2002