Money is not really Decimal (19,4). It is actually implemented as an 8 byte number (similar to a BIGINT) and has a max value of 922,337,203,685,477.5807 which is less...

The distribution agent for a pull subscription runs on the subscriber. For it to be able to read any file in the snapshot (which is on the publishing server),...

bcp is only used for the delivery of snapshots. For the on-going transactional feed, standard t-sql statements are used (either stored procs or INSERT/UPDATE/DELETE statements depending on how you...

Assuming that the servers are connected by a high speed network, you would normally expect latency to be pretty low (maybe a few seconds). If the network speed is...

Sounds like you are running SQL 2000 Personal Edition - this does not support Transactional Replication (http://msdn.microsoft.com/en-us/library/aa175266(SQL.80).aspx has details of features supported by each edition).

I would be a little...

To recap your scenario, you have

- tables that are updated in Florida that are replicated to Montreal and are never updated in Montreal

- tables that are updated in Montreal that...

I assume that your question is about getting 2 errors.

If I understand your package, it looks like the 3 "Execute Package" tasks will start running in parallel....

Edit the connection manager for the file. There is a UNICODE checkbox near the file name. If that is not checked, does the code page you are using...

I suspect that your destination may not be allowing multi-byte characters. Is the flat file destination UNICODE ?

Not sure what the reasoning but if it is so that you don't need to add everyone AD names to the server you could either

- add everyone to a single...

You can create directories for reports within reportings services - no need for IIS to get involved. Just click on the 'New Folder' button.

Once created, you can assign permissions...

The short answer to your original question is no on both counts. Both mirroring and clustering rely on the physical structures of the database and logs - these change...

Has the login been granted access to master ? This is separate from creating the login

Granting permission to public for these sprocs is a potentially huge security problem just waiting to happen. The sp_OA sprocs allow a user to call the methods of the...

Both are the same. The first is the name of the dimension member and the second is the key of the dimension member (this is what the & means)....