Viewing 15 posts - 1,636 through 1,650 (of 1,654 total)
You changed the service account of the SQL Agent to a domain account but not the MSSQLService account. While notifications for operators are handled by SQL Agent Mail, xp_startmail, xp_sendmail...
May 12, 2003 at 3:56 am
I'd go for merge replication since several updates of the same record will result in just one update at the subscriber. Transactional replication would create a lot more traffic.
About the...
May 9, 2003 at 1:41 am
Why so complicated? Can't you just attach the mdf file directly. SQLServer will automatically create a new ldf.
M
May 9, 2003 at 1:32 am
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...
May 8, 2003 at 1:59 am
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...
May 8, 2003 at 1:42 am
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...
May 2, 2003 at 8:48 am
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...
April 25, 2003 at 1:32 am
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...
April 7, 2003 at 1:38 am
You might want to check out this article
http://www.mssqlserver.com/replication/bp_manual_replication_cleanup.asp
April 3, 2003 at 5:04 am
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...
April 3, 2003 at 12:24 am
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...
March 20, 2003 at 3:04 am
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...
March 19, 2003 at 1:45 am
David, you were asking about a stress tool. Try database hammer, it's part of the SQL Server resource kit.
March 18, 2003 at 4:11 am
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...
March 18, 2003 at 4:05 am
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...
March 17, 2003 at 8:19 am
Viewing 15 posts - 1,636 through 1,650 (of 1,654 total)