by Nish » Sat, 06 Mar 1999 04:00:00
Qn : How do I sort my data when I create a view in SQL 7.0?
a) I have tried using ORDER BY but SQL says I need to use it together with
TOP.
Thanks in advance.
1. Give this newbe easy answers on easy questions!
Hi Reppies.
These questions are bothering me:
1. I use replication for fault tolerant purposes. When the primary
(sending) server fails. Is it allowed to switch clients to the
subscribing server and let them alter the data ?
2. It seems like the command 'truncate table' is not allowed when the
table is published to another server. Is 'delete from' the only
alternative to accomplish a full delete ?
3. For existing data to be published, do I first have to transfer/copy
the database to another server before I switch on replication for it ?
In other words: initial replication does not synchronise the database
in a way that the destination database is being synced so that it is
an exact copy of the publishing database ?
4. Only data in published tables is replicated, not the permissions
and database properties, right ?
So, every option (i.e. select bulk into or truncate on checkpoint) for
the publishing database must be manually set on the destination
database, right again ?
Thanks for you time and happy sync'ing
Ray Arts
The Netherlands.
2. CDML - SetCookie - Set to [FMP-Link]
4. XML API Standards, do they exist?
6. Raising Events from SQL Server - Event Handling from .NET
7. 1 very hard and 1 very Easy question
8. Migration, Informix to SQL 7.0
9. This should be an easy question regarding Triggers
10. Easy question on sql profiler
11. Easy question
12. SQL Server on a LAN (easy question)
13. Easy Question - Copying images into a database