If you have a non-central site down and intend to perform disaster recovery and are doing snapshot replication, maybe the following will work.

Set us a subscriber pull option to the...

Distributed transactions use four part names.

Don't know if this will work, but give it a try.

SELECT * 

FROM DeptSQLSrvr.Northwind.dbo.Employees

Select *

From servername.databasename.ownername.tablename

I believe ommision of servername will default to local server.

GaryA

What happens when you try to retrieve the data without CF?

GaryA

 

Too the best of my knowledge, SQL Server 2000 client tools work with SQL Server 7.

GaryA

 

For us newbies, please describe the problem you are encountering.

TIA

GaryA

IMO

First, ideally each table column should explictly define NULL or NOT NULL nullability attribute.

Second, queries may have to deal with several servers who nullability attributes are not all defined the...

Thank you James!

 

In regards to off-site storage of backups.  I suppose the backup files could be encrypted prior to sending offsite.

One can password protect backups.  While this would not prevent your data...

Where you want to get rid of backup history not needed, the following is an alternate solution.

USE msdb

EXEC sp_delete_backuphistory '12/31/1999'

This would delete the records older...

Books On Line (BOL) says:

sp_who

Provides information about current Microsoft® SQL Server™ users and processes. The information returned can be filtered to return only those processes that are not idle.

Please...

Additional thoughts are:

Since there is a one to one relationship between tables, it seems to me that to use an identity column (for a key) implies that the same identity...

Jack seems right on to me.

My take is as follows:

It's SQL Server which needs to have read/write access to the files holding the database(s).  It's SQL Server which needs to run...

It seems to me the following are issues in determing the answer to your question.

I call using two or more columns to make up a primary key a "composite key".

First,...

I am curious as to why you find it necessary to stop and start SQL Server every night?

GaryA

 

I am a newbie, but based on what I know the following seems to be true.

Short Answer. If your SQL Server does not need access to other machines (to store...