Thursday, 2 April 2015
Regular Expression Tester
Check out https://regex101.com
Great Online Regular Expression Tester, with a full reference help and awesome explanation of the regular expression that you're building.
It's specially helpful when the regular expression starting getting big and it's hard to find mistakes
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
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
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 ...
[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.
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"
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
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
Subscribe to:
Posts (Atom)