SQL Server
8 posts in this category
- Step 3: Create the outgoing link reportThis article is part 3 of Sitecore How To: Track Exteral links with DMS series. Before starting with this step you need to be finished with Step 2. Otherwise…May 14, 20123 min read
- Converting .mrt reports from OMS to DMSIn this article I'm going to explain how to convert .mrt reports from the Sitecore Online Marketing Suite Sitecore 6.4 to the Sitecore Digital Marketing…Nov 15, 20115 min read
- Linq to Sql: Retrieve properties from related data (LoadWith)You have to specify which related data you want to retrieve from a object so you can access them outside the Linq data context. You can achieve this by using…Jan 15, 20091 min read
- MSSQL: Database diagram support objects cannot be installed because this database does not gave a valid owner.For a customer I needed to do a review their database MSSQL 2000 database . For this I wanted to create some database diagrams. When I tried to create a…Dec 13, 20081 min read
- Linq to Sql: Change connectionstring to load from Web.configUpdate 20 may 2009: New easy solution Set the Connection > Application Settings property True. This will generate a connection string in your app.config.…Sep 2, 20081 min read
- Microsoft SQL Server Database Publishing Wizard 1.1When I was trying to publish a database to my shared hosting provider I encountered some problems with backup and restoring my database. To restore a…Sep 2, 20081 min read
- MsSql: How to enable clr (to run c# / vb code in SQL)Execute the next query to enable CLR. \ code:c \ // Turn advanced options on EXEC sp\configure 'show advanced options' , '1'; go reconfigure; go EXEC…Jun 26, 20081 min read
- Dynamic load whereparameters for linqDatasourceWhen using an Linq Datasource linq to sql for a datagrid Gridview, ListView, etc you don't always want all rows from a table. To exclute data you can use the…Apr 1, 20081 min read