Why so complicated? Can't you just attach the mdf file directly. SQLServer will automatically create a new ldf.

M

The SQL Server executes your code it sees each print statement as and the select as a separate query. Since there is no flow control, there's no guarantee in which...

Sub A won't get any of the changes being uploaded from Sub B. The reason is that SQL Server first has to upload all the data from the subscribers and...

If you need just the Id and the ACCTname you can do a simple group by.

select max(id) as ID,AcctName from Table1 group by AcctName

In case you need all the columns...

I've seen this happening with SQL 7.0 several times and the reason usually was that the SQL Server Service account wasn't a member of the local Administrators group.

Check your service...

I've seen that message a couple of times myself and as far as I know it's a locking issue. The mergeagent tries to read some records at the subscriber which...

You might want to check out this article

http://www.mssqlserver.com/replication/bp_manual_replication_cleanup.asp

The short answer is Yes.

Always remove the subscriptions first, otherwise you can end up with a very annoying situation because SQL Server sees the database still as part of...

To be honest I don't know exactly what your problem is because I can't find either the error number 20598 nor the stored procedure you name. Which version are you...

cch,

I've seen these messages lot's of times when initializing a replication with (large) text or image columns. Especially if you initialize over a slow WAN link you can expect to...

David, you were asking about a stress tool. Try database hammer, it's part of the SQL Server resource kit.

About 1) I meant that you have to check that your application uses these statements including the WITH LOG clause.

2) This was just an advice in case you have...

Actually you can replicate text fields using transactional replication, but because WRITETEXT and UPDATETEXT are by default not logged you might have to check your application. Another problem using text/image...

Actually you can't. The only way of accesing resources on the network is by using a DOMAIN USER as your service account.

Depending on the size of the database and if it's possible to take the DB offline I often use sp_detach_DB, then copy the files and sp_attach_db to connect the Db...