How dare you cross the girls and not get your swimsuit.

Tell them you'll get a kilt instead:)

Are the sql services running for that instance?

Is the domain account locked or expired - or did the password change recently?

Is your SQL box 64 bit?

If so, try this:

Install the Oracle ODAC (available on the Oracle Technology Network) and a patch (#5043675 available on Metalink) that fixes a bug that...

What is your disk configuration?

What additional indexes do you have?

How long does it take to do:

Select Count(id) from yourtable

I think that beyond normalization, an exercise in re-defining the data dictionary...

To second the advice given:

Reattach the database first and then add the logins. I have encountered less problems that way.

Do you know the size estimate of the data that you are trying to move from Oracle into SQL2K?

GabyYYZ (10/13/2009)

---

Hi folks,

Apparently, Microsoft is releasing it's biggest set of patches in one day today, and among those is a SQL patch. I can't seem to find details on...

Here is a sort of starter script to show a little bit of the interaction. This will give a quick overview of some of the properties of your jobs....

One more thing to try is to check your ansi_warnings setting.

Try

set ansi_warnings on

execute your proc

If you get an error, then reverse the setting. And then add set ansi_warnings off...

Will you also script the job and show us that?

what have you done to troubleshoot?

Do you get an actual error message if you click the shortcut?

Looks like somebody uninstalled the management tools from the pic you sent - best guess.

ifila (9/17/2009)

---

When using the above command on a dual QUAD core machine, do i specify the number of processors as two or eight ?

Is this something worth changing to improve...

BTW, thanks for being helpful to us. You providing the table and index information really helps make this process go a lot smoother.

No. The reason for fragmentation is due to the lack of...