Viewing 15 posts - 601 through 615 (of 1,790 total)
Lynn Pettis (5/21/2009)
May 21, 2009 at 9:22 am
I would run a trace with a filter on application name that would be something like %YourDBName% against the subscriber instance. Watch for the rollback statement and then grab the...
May 21, 2009 at 6:48 am
robert_daniel (5/15/2009)
thx... hence the "syntax error" clue...
Glad to help. Always nice to have another set of eyes to see stuff like that. I have many dents on my...
May 15, 2009 at 2:54 pm
Try this;
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'NTSVR1 Mail',
@recipients = 'joe@web.com',
@query = 'SELECT count(*) from JDE_Production.proddta.f4211',
@subject = 'Mismatch',
@body = 'The stored procedure finished successfully.',
@attach_query_result_as_file = 1 ;
You forgot the comma after the...
May 15, 2009 at 2:32 pm
Because that is in the string you have to use double single quotes around text strings such as SQ. So, you would actually have ''SQ'' (those are two single quotes,...
May 15, 2009 at 2:04 pm
Luke L (5/15/2009)
Grant Fritchey (5/15/2009)
Luke L (5/15/2009)
For all you folks out in Mass, I'm planning a trip trough Boston up to the Cape this summer. Any...
May 15, 2009 at 1:21 pm
One other thought to add to NoelD's suggestions, would be to use independent agents for those articles that need to be given "priority" in your replication scheme. To explain further,...
May 15, 2009 at 12:04 pm
Interestingly enough, I am working with MS to assess that right now. I have been assured that the DMV's should be accurate in the Virtual environment as they use the...
May 14, 2009 at 8:18 am
From what I read the @min_distretention value is hours so, your above assumption should be correct and that it would indeed wait for 12 hours to delete a command that...
May 13, 2009 at 12:03 pm
First of all it really shouldn't be taking that long. We do a ton of replication and the cleanup agent does pretty well in keeping up. It does tend to...
May 13, 2009 at 10:13 am
No, it should work on same versions as well but it can be flaky. What are you trying to do?
May 12, 2009 at 12:58 pm
Was hoping that it was scanning the new drive differently. 😉
May 12, 2009 at 12:14 pm
The other thing that shows up in a search for that error is that a virus scan may be actually locking the log file. Virus scan should be disabled for...
May 12, 2009 at 12:06 pm
Are you validating that the permissions for the files / folders move over as well. I would verify that really well prior to attaching. Looks like a potential permission issue....
May 12, 2009 at 12:04 pm
Jonathan Kehayias (5/11/2009)
May 12, 2009 at 9:55 am
Viewing 15 posts - 601 through 615 (of 1,790 total)