Error : Saving Changes in not permitted.

I like how SSMS takes stance of displaying warning message and stops user from going further to do operation, thereby preventing hanging of SSMS. However, this feature can cause inconvenience in a situation when one is required to save table using SSMS. If such situation arises, then this feature ca... [More]

Tags:
Categories: Development
Permalink | Comments (0) | Post RSSRSS comment feed

Connecting Visual Studio 2008 BIDS to TFS 2010 and 2012

Not all of us are so lucky that we can work with the latest bits at all time. Especially the folks that are in the Microsoft BI area always seem to be behind a release or two. This has always resulted in issues connecting to TFS from their version of Visual Studio.For quite some time there has been ... [More]

Categories: Development
Permalink | Comments (0) | Post RSSRSS comment feed

Conditional formatting of negative numbers SSRS

Formating text depening on its value - sql server reporting services The formula below will format a field to red if it is a negative number. The formula goes into the reports Font color property for the field you are highlighting. =IIF(Fields!FieldName.Value<0, "Red","Black") Don't forget the... [More]

Tags:
Categories: Development
Permalink | Comments (0) | Post RSSRSS comment feed

Passing URL parameters to Reports in SharePoint

Passing URL report parameters directly to a report in a SharePoint Document Library is enabled in the SQL Server Reporting Services 2008 Integration with SharePoint Add-in. Why? Key intent is to allow specifying non-default report parameter values when rendering of a report in full-page view in Sh... [More]

Tags:
Categories: Development
Permalink | Comments (0) | Post RSSRSS comment feed

How to Programmatically Upload files and folders to a SharePoint Document Library and Update and Delete Files from SharePoint Sites.

using System; using System.Data; using System.Configuration; using System.Web; using System.IO; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using Microsoft.SharePo... [More]

Tags: ,
Permalink | Comments (0) | Post RSSRSS comment feed

Back Up Content Database For Upgrade - TSQL

Specifying a Backup File by Using Its Physical Name The basic BACKUP syntax for specifying a backup file by using its physical device name is: BACKUP DATABASE database_name    TO DISK = { 'physical_backup_device_name' | @physical_backup_device_name_var } For example: Copy... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Adding an Assembly to Safe Controls in SharePoint Tools for Visual Studio 2010

Using SharePoint Tools for Visual Studio 2010 allows you to build SharePoint solution packages very easily. When you create a SharePoint project, Visual Studio allows you to specify if the assembly for that project should be included in the package and, in case it does, where you want it to be deplo... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Sharepoint Active Directory Migration - SID's

Ever migrate your SharePoint site to a totally new environment and discover that your efforts to re-create your Active Directory were all for nothing, since all the users got new SIDs? Symptoms like: The administrator of the server can log in, but nobody else can, even though you're SUR... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Usage Reports longer than 30 days - SharePoint Log Parsing

I recently had a client that wanted metrics on sharepoint usage in their farm.  Of course I already knew about the out-of-box (OOB) usage reporting capabilities of SharePoint 2007.  But the limitations with the OOB reports is that they only show a rolling 30 day picture of usag... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Displaying the Web Site ID and the Description for Kerberos

This script will show you the W3SVC Web Site ID and the description. With IIS 6 the Web Site ID is a randomly generated number for each site that is created other than the Default Web Site which has an Web Site ID of 1) For example: W3SVC1W3SVC719499532W3SVC383732556 Knowing which web site these... [More]

Permalink | Comments (0) | Post RSSRSS comment feed