Help!! Help!!! Newbie Of SQL 7

Thread View: comp.databases.ms-sqlserver

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by CTINews Thu, 21 Oct 1999 00:00

#130

Author: CTINews
Date: Thu, 21 Oct 1999 00:00

15 lines
1710 bytes

We are currently migrating to SQL server 7.0 and found some unsolved
problems

Several Questions:

1.)  Can 7.0 acts as the subscriber/publisher/distributor of SQL Server 6.0
or vice versa

2.)  What is default checkpoint of transaction, Can I modify it manually.

3.)  How to create relationship link between  tables in the diagrams

4.)  What is the maximum database/log size?

z

Re: Help!! Help!!! Newbie Of SQL 7

#129

Author: Jerry Spivey
Date: Wed, 20 Oct 1999 00:00

29 lines
2083 bytes

For #1:  see 'Replicating Between Different Versions of SQL Server' in BOL.
For #2:  The checkpoint is for the db not the transaction.  see 'recovery
interval Option' in BOL.
For #3:   Drag from the FK column in the referencing table to the PK column
in the referenced table in the database diagram tool.
For #4:   See 'Maximum Capacity Specifications' in BOL for maximum database,
data file and log file theoretical limits.

HTH

Jerry
CTINews wrote in message <7ul023$oet$1@newso.ctimail.com>...
>We are currently migrating to SQL server 7.0 and found some unsolved
>problems
>
>Several Questions:
>
>1.)  Can 7.0 acts as the subscriber/publisher/distributor of SQL Server 6.0
>or vice versa
>
>2.)  What is default checkpoint of transaction, Can I modify it manually.
>
>3.)  How to create relationship link between  tables in the diagrams
>
>4.)  What is the maximum database/log size?
>
>z
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads