indeed !

if you need to have several culture/language/internationalisation (I18n!) then sobeit

- but the database engine needs to know how to interpret input from client-side

you can override an individual session (initialised...

You say there must be an easier way, and of course there is

- use the standard, no-cost, MSSQL utilities and tools that normal mortals use

MSSQL does cater for VLDB's and...

presuming this to be a regular SQL Standard Edition or better (not Express or other OEM/crippled version), I would assume that you have some corruption (whether database, registry or service)...

doubtless the RedGate fraternity will have some clever and witty solution to all parameter values

- this is just the simple version from the coal-face

you can use SQLCMD plus FC or...

there are catalog views that you can use to browse table/column/datatype

- you should use INFORMATION_SCHEMA.* views, but example below deviates to use tables

you might assume that MS has a "clean"...

you are using SqlCEv3.1 and this came out before Vista

suggest you try v3.5 (released Nov 2007 I think)

read these URLs too

http://blogs.msdn.com/stevelasker/archive/2008/01/09/connectivity-cross-version-compatibility-of-merge-replication-and-sql-server-compact.aspx

http://blogs.msdn.com/sqlservercompact/archive/2007/12/19/connectivity-cross-version-compatibility-sql-server-compact-3-5.aspx

HTH

Dick

presumably you can setup the publication on the Publisher (SQL2005) and Distributor (SQL2005).

- you can script this to produce the sproc calls to drop+create that pub

in such scripts you will...

Erik Bitemo is correct that you can only have one [first-level] Distributor, and rbarryyoung has already suggested the republish option to cascade Distributors, so that SHOULD be your solution for...

remember that if you split your table articles across multiple pubs that there should be no hierarchy overlap, eg don't have Customers on pub1, Orders on pub2 and OrderDetails on...

we have both repl from pub A to several subs S1,S2 etc and also Log-Shipping to DR

- works fine

all our Pubs are actually also Distributors, but it is possible to...

if you have independent regions (eg NYC, London, Tokyo) it is commonplace to have IDENTITY blocks so these don't overlap/conflict. But often you will want the NFR functionality you've already...

I have a transactional replication with central publisher and 10 subscribers. The replication runs pretty smooth. Now I want to add a new stored proc as an article to the...

Hi Lynn ,

should be no problems doing transactional repl from SS2K to SS2K5 (or vice-versa)

as with most DBA operations, simplest to use the SEM in SS2K (or SSMS in SS2K5)...

Erik makes very valid points contrasting mirroring, tranlogging, replication

- I agree that L-S is a non-starter because applying the *.TRN would need A2 offline

mirroring is also good in that you...

my point is that it extremely UNLIKELY that all your FK's are REQUIRED

it is possible to temporarily disable a FK (for example to stuff in 200K rows)

- but when you...