Actually, this is definitely a UI bug. It looks like it's selected when you create a new one, but it's not behind the scenes.

Just dropping down the enumerator type...

I've definitely seen it before, but have always been able to fix between some combination of switching the enumerator type to something other than File, then back again, or dragging...

Read above. You can't even select from the renamed table. It's incredibly difficult to get the data somewhere else in any way

Welsh Corgi (9/9/2011)

---

HowardW (9/9/2011)

---

Tried it out, also can't find a work-around (can't rename in the UI either). The only option I can find is to script the table, recreate it...

There would be a good argument for implementing this as a computed column (possibly persisted or indexed depending on it's use) if it will always be calculable based on other...

Ouch. This is looking tricky. You can't even refer to the object name in a select statement (even fully referenced). I've tried adding a synonym to it, which lets you...

Tried it out, also can't find a work-around (can't rename in the UI either). The only option I can find is to script the table, recreate it as the correct...

The OP did say it was by mistake. Does it work if you prefix it with dbo.tablename? E.g.:

sp_RENAME 'dbo.sp_columns','claims'

The problem is likely to do with the fact that sp_...

Yes, you could setup a SQL Profiler trace, or just have a look with sp_who2 (or the excellent 3rd party sp_whoisactive) while the blocking is occurring, however, if you can...

Agreed, depends on the isolation level. Even in Oracle, no-one could run an update on a row that had been affected by another user transaction if it hadn't been committed,...

Actually, I was referring to the Server Configuration values rather than the client connection settings in SSMS. E.g. the ones held here:

sp_configure...

Not sure I'm understanding you.

So, are you saying you've put the location the package needs to look for the database config in the database and asking how you can...

OK, if I'm understanding you correctly, you're effectively using a custom configuration rather than using SSIS's configuration settings.

That's fine, but at the end of the day, something has to...

You can set implicit transactions on by default as part of the user options server configurations parameter. The easiest way to modify this is through SSMS (right click on the...

Have a look here:

http://msdn.microsoft.com/en-us/library/cc895212.aspx

You can store config parameters in a database.

If you want help with anything specific, I'd ask a specific question, taking some care to explain it.