Tag Archives: SQL server

Conversion on datetime fail on Where clause

http://stackoverflow.com/questions/7263501/conversion-to-datetime-fails-only-on-where-clause projection ok where clause fail if conversion/casting more than once. crazy!

Change SQL Server default date format

Default is US date format : MM/dd/yyyy Also, the login given default language will affect the dateformat. Sounds need to change both of them. SQL server ref.: http://support.microsoft.com/kb/173907 SQL server express ref.: http://www.sqlservercentral.com/Forums/Topic1004359-146-1.aspx#bm1004496 EXEC sp_configure ‘default language’, ’23’ — british_english ? GO RECONFIGURE;

SQL Server replication requires the actual server name to make a connection to the server

solution: http://www.cryer.co.uk/brian/sqlserver/replication_requires_actual_server_name.htm

SQL replication articales

Basic + Push and pull http://blog.slalom.com/2011/01/19/sql-server-replication-push-vs-pull-what-is-the-difference/ Multiple publisher replication + center subscriber http://www.sql-server-performance.com/2005/multiple-publishers-replication/ MSDN: Snapshot replication http://technet.microsoft.com/en-us/library/ms151832.aspx