While removing Site Content Type you got the error that "The content type "My Content Type" is part of an application feature". The fix is rather easy and simple.
There are at least 2 ways to find physical path of shared folder in Windows (server or client OS – not important) – from command line console or from Snap-In "Shared Folders" in MMC.
Usage "Application configuration file" is very good in creating simple applications. It's very good to store in it values like path, string for database connection or something like this. I use it for a long time. But not so long ago I have noticed that Studio highlights string where configuration file used: (more...)
Managed metadata is very good and powerful tool in SharePoint. But it has some not very comfortable specialties during migration data from one farm to another, for example, from test environment to productive. You can export your managed metadata from one site and import it into another one. But here's the problem that each termset and term has its own GUID. After you import managed data into the new farm, new GUID’s will be assigned to managed data items.
Using class System.Environment you can get paths of special Windows folders such as Program Files, My Documents and others. The list of available values is stored in enum object Environment.SpecialFolder (Fugure 1).
To receive quantity of rows of the returned records of SQL query, you should use function @@ROWCOUNT. Function @@ROWCOUNT returns the quantity of rows, which were used in a query.
How to get as SQL query result the list of databases in SQL server.
select name, database_id from sys.databases
When you modify columns of a table in MS SQL management studio, you got the message "Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created … " (Figure 1). The reason of this is re-creating of table. It's really important for productive environment but not very for test ones.
Rename table in MS SQL Server:
sp_rename 'old table name', 'new table name'
For a massive update of a SharePoint list items I didn't want users, who subscribed for alerts about changes in the SharePoint list, got the messages about it. There were 2 ways to do it: 1 - temporary to disable SMTP server (change SMTP settings to wrong ones) and delete files from Queue folder after; 2 – temporary to disable alerts for a list. This story is about the second way.
