Good to hear, I have implemented this solution many times.. In SSIS 2008 it is slightly easier, because the lookup in 2008 has a failed lookup path instead of...

For Case A I would say you have some blocking going on, definitely see who is doing it.

For Case B I would say indexing and tuning sounds right. Your...

I have had a devil of a time with bigint, I always end up converting it to a string and using it that way..

CEWII

Lets see if I understand..

You have data in excel that periodically changes. Once it changes you want automatic updates to the table.

You want to load it into a table,...

Our company does something similar, an additional sa like account is created. The rationale is that the sa account is well known. The password gets periodically reset and...

You might try looking at the System Log to see if there is a security event at the same, or near the time. I did a shutdown on my...

Yeah, thats going to be messy isn't it..

CEWII

Your install is almost certainly fine, your problem is very clear, and is well known..

It all becomes clear right here:

You are trying to...

Quite frankly I just don't think you can do it..

CEWII

Some process is sending a stop to the service control manager.. That can't be prevented since it happens and is normal.... Only a fairly high level user could...

Actually you can do nearly anything that can generate a true/false condition.. You often use () to set up which goes with which comparison..

Try this:

IF ...

Mark,

I am having a problem here.. I looked at Matt's query and it works almost the same as mine. You state that you want one row, while your...

SQL ORACLE (9/17/2009)

---

One instance is default, another is a named instance.

What if the two SQL Server database instances on a standalone server share the same IP?

What if the two SQL...

I"m thinking you had a highly fragmented table that has never had an index rebuild. Does this table have a Primary Key and/or Clustered Index (usually the same one),...

Provided I understand your goal..

Step 1 inserts data into some table, we'll call dbo.Table_1, you know how to do this I think..

Step 2, code to insert from a query that...