Viewing 15 posts - 6,286 through 6,300 (of 9,715 total)
GSquared (3/16/2011)
Brandie Tarvin (3/16/2011)
Notifications on jobs are not related to job steps and not configured by step. They...
March 17, 2011 at 4:55 am
Jeff Moden (3/16/2011)
Craig Farrell (3/16/2011)
GilaMonster (3/16/2011)
I object, I'm a model of good behaviourwell, compared to others on that list anyway...
Isn't that like saying you're a 'nice' barbarian because you only...
March 17, 2011 at 4:51 am
CirquedeSQLeil (3/16/2011)
Buck has clothing problems.
TMI! TMI!
Someone get me the brain bleach!
:sick:
March 16, 2011 at 12:36 pm
I'm not sure what you mean by "and the end". Could you clarify?
Notifications on jobs are not related to job steps and not configured by step. They are a separate...
March 16, 2011 at 12:35 pm
edvard 19773 (3/15/2011)
The customer has two tables, which they use as their link to my db.
And they claim...
March 16, 2011 at 12:33 pm
Just a thought. Identity_Insert could be set ON for that table and data coming from elsewhere is forcing duplicate values in.
Or someone might have reseeded the table.
March 16, 2011 at 12:29 pm
I agree with Steve. It sounds like the code is missing something or deliberately excluding something.
Do a search in the catalog views for a proc with that name, then...
March 16, 2011 at 12:26 pm
You can also put a CASE statement in your ON clause, forcing the code to make up a number or default to a value that will keep the records that...
March 16, 2011 at 12:24 pm
One problem my workplace has with alerts and notifications. Email can be slow across the network (so can pages), which means we get notified of an event 2-10 minutes after...
March 16, 2011 at 12:20 pm
Why do you have notification set up in the plan? Why not set it up on the job as a "Notify Operator when job is completed?"
You need an operator, but...
March 16, 2011 at 12:17 pm
Oracle_91 (3/16/2011)
March 16, 2011 at 12:10 pm
What little I know of SQL Memory Allocation is this:
1) SQL tries to steal as much memory as possible from the operating system. If you don't throttle it in some...
March 16, 2011 at 11:53 am
There are a lot third party tools for sale that will monitor multiple servers, also. I believe both Imceda and Red Gate have software, along with several other companies.
Otherwise, as...
March 16, 2011 at 11:38 am
You can kill the process by using the KILL <SPID> command. And do what Pradeep suggested. Look at the command in a command line utility to make sure what sorts...
March 16, 2011 at 11:35 am
1) How do you know it's not returning all records? (I'll explain why I asked as soon as you answer.)
2) Production database or dev database?
3) What security settings do you...
March 16, 2011 at 11:33 am
Viewing 15 posts - 6,286 through 6,300 (of 9,715 total)