SQL Server 2005

From SkobbaPedia

Jump to: navigation, search

[edit] Merege Replication Setup

  1. Install MSI 3.2
  2. Install .NET 2.0
  3. Install SQL Server Components
  4. Allow remote conntection to SQL server (SQL Surface Manager)
  5. Install SQL Server Compact 3.5 Server tools ENU
  6. Setup merge replication (subscription)
  7. Setup Web Synchronization

iSupply C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\server\

The web syncronization did not work without directory browsing enabled on IIS.

http://websrv/iSupply/sqlcesa30.dll?diag


[edit] datetime

Ref.: http://www.karaszi.com/SQLServer/info_datetime.asp 

SELECT * FROM MYTABLE
WHERE MYTIMESTAMP >= '20010101 23:59:00'
GO
SET NOCOUNT ON
DECLARE @startdate datetime, @adddays int
SET @startdate = '1/10/1900 12:00 AM'
SET @adddays = 5
SET NOCOUNT OFF
SELECT @startdate + 1.25 AS 'Start Date', 
   @startdate + @adddays AS 'Add Date'
Retrieved from "http://gjermund.skobba.net:8080/index.php/SQL_Server_2005"
Personal tools