Viewing 15 posts - 6,301 through 6,315 (of 9,725 total)
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
y.koteswarrao-652921 (3/4/2008)
HiIn a transaction log file , how a checkpoint works, and it's process,plz clarify.
Once you've read the suggested material, if you still have questions, post the part of the...
March 16, 2011 at 11:31 am
I believe SQL uses the same logic as it uses for Excel worksheets. It checks the first 10 rows of data and assigns nullability (as well as data type) based...
March 16, 2011 at 11:30 am
I would go with John's suggestion with one suggestion. If you are using a third party backup & restore tool, like Litespeed, you can do object restores. Which means you...
March 16, 2011 at 11:04 am
Can you add another file to your transaction log on a different drive and make it the Primary? Given enough space, trying to shrink your database or your data file...
March 16, 2011 at 11:01 am
EDIT: Erasing what I just said because it's not related to the question. DOH.
If your growth occurs at a certain point in the day, can't you use profiler to identify...
March 16, 2011 at 10:55 am
Viewing 15 posts - 6,301 through 6,315 (of 9,725 total)