Browse by Tags

Scripting a SQL Server database to be compatible with SQL Server Compact Edition

Out of necessity, I created this template to help me move a SQL Server 2005 database to SQL Server 2005 Compact edition. This saved me a LOT of manual entry for all the DDL for the CREATE TABLE stuff. Right now all it does is the basic create table with primary key (if any). It doesn't do foreign...

Posted to Template Share (Forum) by Hector on 07-07-2007
Filed under: SQL, SQL Server Compact Edition, SQL Server
Update locks table.

Although I think my problem has mainly to do with my connection settings, I try my luck here anyway. I have a table in which I want to update various records. The update statements take ages to complete. My test database is very small. The biggest table has 50 records. When the update statement is 'running'...

Posted to .netTiers - General Support (Forum) by W0ut on 07-16-2007
Filed under: update, lock, slow, SQL Server, table
SQL Server Audit Tables and Triggers

CreateAuditTablesAndTriggers.cst creates audit tables and triggers for the selected tables. Uses a one audit table per source table strategy. Timestamp columns are ignored. <cheese>To get around a SQL Server issue with text and ntext columns in the "inserted" and "deleted" tables...

Posted to Templates (FileGallery) by Jamison on 08-24-2007
Filed under: SQL, sql server, auditing, audit table, audit trigger
Another n00b here - please help! *code inside*

First of all, thanks and great work to all for this fantastic tool! I've been using .nettiers for about 2 months now and recently came across this problem. Scenario I have a table 'Person' and another 'RelatedPersons'. A 'Person' can have 0 or more 'RelatedPersons'...

Posted to .netTiers - General Support (Forum) by kushal18 on 09-13-2007
Filed under: .netTiers, ManyToManyListRelationship, ManyToMany, ManyToManyListRelationship GridView CheckBox EntityRelationshipMember, C#, .net 2.0, SQL Server, beginner
Dynamic Search Stored Procedure Creation

It creates a most efficient dynamic stored procedure Create Procedure dbo.SearchRP_Demand @HCID int = 0, @OPPID varchar(20) = '', @StartDate datetime = '', @EndDate datetime = '', @HeadCount int = 0, @JobID int = 0, @DomainId int = 0, @DomainName varchar(100) = '', @EmpJAILevel...

Posted to Templates (FileGallery) by kumar106 on 02-26-2008
Filed under: sql server
NEW: Database Explorer API (DB Schema API) Released!

Greetings If you've been looking for a Database Schema API that is a bit more intuitive than the one that ships with Code Smith and one that handles relationships such as 1:1, 1:M, M:1, M:M and recursion and also has a built in expression parser, then do yourself a favour and check this new API out...

Posted to Template Share (Forum) by dotNetProfessional on 03-17-2008
Filed under: DAL+, DAL, SQL, SQL Server, .Net 2.0
Consuming a FOR XML Proc

I am in the process of converting a site (written by someone else) to use .net tiers on the back end. We have a number of stored procs which return XML. The reasoning behind generating the XML within a proc is solid and is the most efficient way getting the desired data. I've been searching the forums...

Posted to .netTiers - General Support (Forum) by picasso566 on 06-16-2008
Filed under: ASp.NET, XML, C#, .net 2.0, SQL, SQL Server, .netTiers 2.3.0
Generated SQL: ANSI NULLS : SET TO OFF BY DEFAULT

Hi, By default .nettiers generates all stored procedures with ANSI NULLS set to OFF. e.g SET ANSI_NULLS OFF We are using a SQL Server 2005 Indexed View, which must use SET ANSI_NULLS ON for any CRUD operations. I understand that using ANSI_NULLS OFF specifies SQL-92 compliant behavior of the Equals ...

Posted to .netTiers - General Support (Forum) by james.smith@adactus.co.uk on 06-26-2008
Filed under: .netTiers, SQL View 2005, ANSI_NULLS, stored procedures, ansi nulls, sql server
Moving a database from SQL Server 2005 to SQL Server 2005 Compact edition

I created this template to convert SQL Server DDL syntax to SQL Server CE syntax. It does primary keys, but no foreign keys. If anybody wants to add foreign keys, feel free. Enjoy!

Posted to Template Share (Forum) by Hector on 07-07-2007
Filed under: SQL, SQL Server Compact Edition, SQL Server
Sync Database Collation Settings

The following template will sync the databases collation settings. If you find any bugs let me know.

Posted to Template Share (Forum) by blake05 on 05-08-2008
Filed under: SQL Server, Collation

Page 1 of 2 (11 items) 1 2 Next >