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...

edvard 19773 (3/15/2011)

---

I have app. 150 tables in the DB, which i control and uses.

The customer has two tables, which they use as their link to my db.

And they claim...

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.

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...

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...

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...

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...

Oracle_91 (3/16/2011)

---

This is first time taking the backup. Basically it is a sharepoint search database and now we are getting log fulll error and so we want take a full...

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...

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...

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...

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...

Once you've read the suggested material, if you still have questions, post the part of the...

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...

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...