You're welcome.

You can query AD. I don't have the code for that on me right now, but it can be done. Would that do what you need?

You can't build the string to be executed inside the Exec command. Build it as a variable first, then execute it.

You're welcome.

Instead of all of this:

CAST(DATEPART(yyyy, OPERATION_DT) AS varchar(10)) + '-' + CAST(DATEPART(m, OPERATION_DT) AS varchar(10)) + '-' + CAST(DATEPART(dd,

...

He's trying to figure out when a DTS package was last run, so he can figure out a migration/upgrade path for it. He has no logging, and it's not...

Check for what's running in the model database that it's conflicting with. There will be some incomplete transaction in model.

I don't think it directly creates a log entry or anything like that when you do that.

Do you have a trace or anything running on your server that might have...

I'm just not sure anything we've done here has had that kind of negative impact. I sure hope not.

You might be able to do that with the Import Wizard.

You're welcome.

When you say you are creating instances through the management consol, I'm not entirely sure what you mean.

The way I've always had to create new instances was to do an...

rog pike (1/26/2009)

---

Jeff Moden (1/26/2009)

---

I absolutely agree... and one of my favoritie proprietary pieces of code is UPDATE FROM... if that were not available, you'd end up having to do...

I'm not sure I'm clear on what you're running into.

You were able to connect with management studio at first, but now you can't?

Is the service still running?

Just a hint: Posting in really big letters just makes your post harder to read. It doesn't actually make anyone answer faster.

When you say you ran it from a...