Of course there are so many monitoring tools amnd it really depends on what is important to you. But I like the NetIQ tools a  lot, even though most of...

Which Service pack is installed ? I once saw this error at a customer and the reason was that SQL server was looking for a stored procedure which comes with...

Hi Sylvain

in order to check your backup for the last good one, you could have used the RESTORE HEADER_ONLY command. This should give you all the information needed.

About your other questions

1)...

Hi Reddy,

First, you're right in some cases (tables with lots of columns) the conflict viewer won't show all the columns an gives an error.

What you can do to compare the...

Sounds like your in trouble. I had my own experiences with removing repications and sometimes it happens that not all the information is removed from the system tables. Especially if...

Hi Steve,

if I understand you right, you make backups of your datafile (.mdf) and transaction log backups, but once the datafile is lost you'd like to make another transaction log...

Hi Jjen,

to answer your questions

1) Yes, it's not unusual to take that long on a large table. Also it will depend on the options you choose whith DBCC CHECKTABLE.

2) I...

There are several tools and scripts to find a sa password. Check out these to links as a starter:

http://www.sqlservercentral.com/columnists/jgama/sqlserverpasswordauditing.asp

http://www.nextgenss.com/sqlcrack.htm

About the queries using the sa account you might...

Check out this article

http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp

M

Hi James,

what do you mean with the database is corrupted ? What error does it give. Can you access the database ?

If the status of the database is loading, check...

If you want to change an existing column you have to remove replication. If you want to add a column or drop a column SQL2000 has two store procedure sp_repladdcolumn...

Generally you should leave it to SQL server to decide which indexes will be used. If you'd like to force the usage of a specific index look in BOL for...

Hi Angela,

by default there's no encryption involved but you could use IPsec to create a encrypted transfer between the two replication partners. There's another possibilty if you use multiprotocol. Check...

Hi Vince

Check the error details for the merge agent. It should give you the exact script which fails. When check the script. I've seen cases that a script is calling objects...

Hi Jens,

about the "orphaned" agent you can try running the "distribution clean up" agent under Miscelleanous agents. This might solve the issue but personally I think the you have to manually...