try denying access better

check the error log file of the instalation

If in the temp table you also have the email adreess, you could create a cursor with the email adreess, and execute the xp_cmdshell command.

For example:

DECLARE @cmd AS VARCHAR(1000)

DECLARE @email...

CREATE tmp_Table

(ID INT IDENTITY(1,1) NOT NULL,

PatientName VARCHAR(2))

GO

INSERT INTO tmp_Table

EXEC ('select substring(PatientLastName,1,2)

from dbo.Staging_Master

order by substring(PatientLastName,1,2) asc'

GO

SELECT * FROM tmp_Table

I think the problem is in here:

Logical Scan Fragmentation ..................: 0.00%

Never saw a % so low. I guess it can't be 100% fragmented.

You shouldn't have any problems in creating the server as a distributor. What version of SQL 2000 do you have and is NT4 a Server or a workstation)

You shouldn't have any problems in creating the server as a distributor. What version of SQL 2000 do you have and is NT4 a Server or a workstation?

lots of questions? I think that you are wrong with the concept of log reader and the use of ftp.

The desicion of using transactional replication is ok, remember that is...

jjeffwe is right, to view the transactions in the log you need a third party tool. Try Log Explorer by Lumigent (www.lumigent.com).

If you want to know, how many log files...

DBREINDEX is more effective, but also cost more in performance. I would run INDEXDEFRAG for all index, and where the index is still fragmented, run DBREINDEX.

Try:

select * from openquery(server,'select col1,count(*) from test..test_table where col1 = ''I'' group by carriermemid')

Are you appending your differential backups? Maybe you have many backups inside your backup device.

On what schedule you are doing your diff backups?

There is not a general rule for almost anything in db world, and space allocation is not an exception.

Anyone call tell that correctly. You should know what are you going...

I can't think of another way. Maybe you can create an insert stored procedure that can save the date in another table, but it is much the same as a...

You could also create differents master jobs grouped according to the time zone, and add different target servers.

This is what I did with my 74 target servers replication jobs.