Hello again , as posted in the past I bought SQL Server 2000 Transactional and Snapshot Replication by Hilary Cotter ISBN 0-9749736-0-2. I found it a brilliant...

Hi Ian, First of sincere all apologies in relation to Homebrew01. When I am busy I reply to this newsgroup sometimes in a hurry !! Apologies once again.

Our current...

Hi Addict, indeed everything you say is correct. However in our case we run a service ( not SQL Server replication ) which selects from a production database and inserts...

Hi are you replicating between 2 boxes, ie is the distribution database on the publisher ( you do not use a central distributor ). Also you can specify where to place...

Hi, we have a similar setup here. I scripted our replication setup and set @del_cmd = N'NONE'. Similar if you enter NONE in the commands Tab for deletes it should work....

Hi, The maintenance plans ultimately create a job in SQL Server agent. First of all go to the Reporting Tab for the maintenance plan for the transaction log backup and...

Hi, I'll certainly test this against one our servers. Thanks a million and I'll update the thread later with how I got on. Thanks again, Derek

Hi, open Query Analyser and try this and see how you get on. Rgds Derek

DECLARE @InstallPath NVARCHAR(128),

 @DatabaseName NVARCHAR(128),

 @parms   NVARCHAR(256),

 @Report   NVARCHAR(128),

 @returncode  INT,

 @cmd   NVARCHAR(4000)

SET @DatabaseName = 'YourDataBase'

SET @Report = 'Where you want to put the output'

 SELECT @parms =

  '-D '...

Hi here is an extract of what I use. I still need to amend it to report available space. Hope it's of use. Any suggestion most welcome etc and I...

Hi, I am the dba for a large site, clustered SQL etc, etc. We don't intend moving to SQL 2005 until may next year or later. I get a little...

Ah your very welcome. I've got lots of help from people on this forum. Even on this thread the tip from veteran was great. Best of luck in the future...

Hi, below is the T-SQL I run to resync logins. You need to run it against each user database as required etc. In this case your suspect database. Hope it...

Hi, this works for me when replacing the database.

-- Get locations of existing mdf and ldf

use <database>

select * from sysfiles

GO

-- Get LOGICAL and PHYSICAL names from a .BAK file.

-- --------------------------------------------------------------------

use...

I would agree with Prakash, despite my comments on DBCC CHECKDB. Rgds Derek

Hi, I find SQL Server Query and Performance Tuning Distilled by Sajal Dam a very good resource. isbn 1-59059-421-5. Rgds Derek.