Interessante articolo per la creazione e gestione dei content database di SharePoint riporto gli script dovesse mai spartire l’articolo Creating a Content Database CREATE DATABASE WSS_Content_MSSQLTIPS
ON PRIMARY
( NAME = MSSQLTIPS_01_data,
FILENAME =
'F:\data\MSSQLTIPS_01_data.mdf',
SIZE = 20,
MAXSIZE = 40,
FILEGROWTH = 5 ),
( NAME = MSSQLTIPS_02_data,
FILENAME =
'G:\data\MSSQLTIPS_02_data.ndf',
SIZE = 20,
MAXSIZE = 40,
FILEGROWTH = 5 )
LOG ON
( NAME = 'MSSQLTIPS_log',
FILENAME =
'c:\data\MSSQLTIPS.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB );
go
alter database WSS_Content_MSSQLTIPS
set single_user with rollback immediate
go
alter database WSS_Content_MSSQLTIPS
collate Latin1_General_CI_AS_KS_WS
go
alter database WSS_Content_MSSQLTIPS
set multi_user
go
Using the Content Database in a...
sintassi di update CAML XElement updateFields = new XElement("Batch", new XAttribute("OnError", "Continue"), new XElement("Method", new XAttribute("ID", "1"), new XAttribute ("Cmd", "Update"), new XElement("Field", new XAttribute("Name", "ID"), item.Id), ...