Viewing 15 posts - 601 through 615 (of 1,790 total)
Lynn Pettis (5/21/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 12:58 pm
Was hoping that it was scanning the new drive differently. 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 12:04 pm
Jonathan Kehayias (5/11/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 12, 2009 at 9:55 am
Viewing 15 posts - 601 through 615 (of 1,790 total)