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

Article View: comp.databases.ms-sqlserver

Article #129

Back to comp.databases.ms-sqlserver Previous Next

#129

From: 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
>
>

Technical Details

Message-ID: <#ZGfbzyG$GA.226@cppssbbsa05>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7ul023$oet$1@newso.ctimail.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10e6bb,59dd19234b52d8d,start
X-Google-Attributes: gid10e6bb,public
X-Google-Thread: ff490,59dd19234b52d8d,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 10f695,59dd19234b52d8d,start
X-Google-Attributes: gid10f695,public
X-Google-Thread: 104de1,59dd19234b52d8d,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 1139e2,59dd19234b52d8d,start
X-Google-Attributes: gid1139e2,public
X-Google-Thread: 115df1,59dd19234b52d8d,start
X-Google-Attributes: gid115df1,public
X-Google-Thread: 10bbfe,59dd19234b52d8d,start
X-Google-Attributes: gid10bbfe,public
From: "Jerry Spivey" <jerry.spivey@aris.com>
Subject: Re: Help!! Help!!! Newbie Of SQL 7
Date: 1999/10/20
Message-ID: <#ZGfbzyG$GA.226@cppssbbsa05>
X-Deja-AN: 538527153
References: <7ul023$oet$1@newso.ctimail.com>
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.clients,microsoft.public.sqlserver.datawarehouse,microsoft.public.sqlserver.odbc,microsoft.public.sqlserver.server,microsoft.public.sqlserver.setup
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Reply to Parent Message