Browsed by
Year: 2011

Enabling editing of SQL 2000 DTS in SSMS 2008 R2

Enabling editing of SQL 2000 DTS in SSMS 2008 R2

We have some old SQL 2000 DTS Packages that we still maintain, and I’m not continuing to install SQL Enterprise Manager on future versions of my OS just to edit these things, I should be able to edit them in SSMS right?  Well, yes, but it requires a couple of steps, that so far in my Google research is never complete…it’s always a part of the entire solution. (PINTA) Well, here’s the entire solution: First, go to http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11988 and download/install the SQLServer2005_BC.msi…

Read More Read More

Custom presence in Lync 2010

Custom presence in Lync 2010

I enjoyed using custom presence in Communicator 2007, but when our enterprise switched to Lync 2010 a few months ago, my custom presence migrated through until I switched to a new PC, then the old method of enabling custom presence failed.  Why?  One registry entry… Here’s how to do it: Create a string key in HKCUSoftwarePoliciesMicrosoftCommunicator called CustomStateURL and give it a value of the path to an OCS presence XML file, such as file:///c:/program files/Microsoft Office Communicator/OCSPresence.xml Now, also…

Read More Read More

SharePoint 2010 Workflow Status filtering

SharePoint 2010 Workflow Status filtering

Since MOSS 2007, SharePoint workflow statuses display with a text value such as “Canceled”, “Completed” or “In Progress”, but behind the scenes are stored as a key with an integer value.  So in a view when you want to filter based on the workflow status you must use this key value, and not the display text. As an example, here’s what the Filtering section would look like if I were filtering out items where the workflow status were either “Completed”…

Read More Read More

Customizing the Request Access page in SharePoint 2010

Customizing the Request Access page in SharePoint 2010

Our organization, like many others, handles access requests for all applications through our IT Support desk. Additionally, documentation is required and must be approved by the user’s department manager before the access can be granted. After just recently migrating the entire company’s intranet over to SharePoint 2010, I wanted to allow users to request access, so I made sure the Manage Access Requests was selected by default for all resources. However, within a week of moving it over I’m getting…

Read More Read More

Remove “Recently Modified” from Quick Launch in SharePoint 2010

Remove “Recently Modified” from Quick Launch in SharePoint 2010

While messing around with SharePoint 2010 pages today, I remembered I wanted to find a way to remove the “Recently Modified” section from the Quick Launch area.  This was a very easy fix, as explained by John Dandison. Add a Content Editor Web Part to any section of the page and put this in the HTML: <style> .s4-recentchanges { DISPLAY:none; } </style> Now THAT was easy!  Sure you can also do this in SPD, but for me this was a…

Read More Read More