Viewing 15 posts - 1,171 through 1,185 (of 5,103 total)
you need to enable the server as a distributor. I believe you have not done so, right?
June 13, 2008 at 7:11 am
avipenina (6/12/2008)
i didn't understand anything from your answer.
OK sorry about that. Let's go step by step.
Alerts are fired if the message in sysmessages is "logged"
The Alert Engine checks for...
June 12, 2008 at 4:16 pm
What you got are "WARNINGS" nothing to do with "ERRORS".
This tend to happen on jobs that were re-ordered or modified at some point but is usually not an issue.
June 12, 2008 at 4:11 pm
Lynn Pettis (6/12/2008)
Unfortunately, it doesn't look like the OP has been on SSC since yesterday morning. Hope he checks this thread and let's us know what's happening.😎
I think that...
June 12, 2008 at 4:08 pm
This looks like a "data" problem to me.
June 12, 2008 at 3:56 pm
avipenina (6/12/2008)
if i setup alert in SQL Server Agent for lets say severity 24,when i query the sys.messages for severity = 24, i see that there are 9 rows with...
June 12, 2008 at 2:35 pm
Maybe the join was spooling a large amount of data to tempdb ?
Did you check the execution plan ?
June 12, 2008 at 2:32 pm
Jeff Moden (6/12/2008)
Lynn Pettis (6/12/2008)
Jeff Moden (6/12/2008)
The real fact of the...
June 12, 2008 at 2:30 pm
You must check the locks on the distribution database or on the Server in general. Too many locks can make that stored procedure time-out!
June 12, 2008 at 2:26 pm
TheSQLGuru (6/11/2008)
Peso (6/10/2008)
grevesz (6/9/2008)
If you start a load testing batch process in 10 parallel threads and let it run for an hour and a half, you exhaust your number range...
You...
June 11, 2008 at 3:19 pm
I would also vote for the use of a calendar table but just for the fun of it:
declare @mindate datetime, @maxdate datetime
select @mindate = left(convert(char(10),dateadd(m,-2,getdate()),112),6) + '01'
select @maxdate =...
June 11, 2008 at 1:51 pm
I don't quite understand how you determined that "order". Can you be more specific ?
June 11, 2008 at 1:29 pm
If Autoshrink is "ON" and you tried to run a "dbcc shrinkfile" you could get that message.
June 11, 2008 at 1:21 pm
In case you want to keep track of what's going on:
June 11, 2008 at 1:18 pm
Viewing 15 posts - 1,171 through 1,185 (of 5,103 total)