The IS lock is most likely in a wait status while the X lock is in a grant status.

Check sys.dm_tran_locks and see what is happening there. I am seeing...

Gary Varga (3/4/2013)

---

I think it needs a reevaluation as it does not appear to work. I have submitted, voted and viewed far too many that appear to be valid that...

thx for the question.

Evil Kraig F (3/3/2013)

---

Unlike Jason, I work in a shop where we have a dedicated SSIS box. There are benefits, but they're not readily apparently. However, it's also...

That kind of setup would not provide any real benefit as far as SSIS is concerned. You would be paying for the licenses for an additional server, just to...

Please please please get rid of that sideshow.:cool:

Jeff Moden (3/1/2013)

---

Heh... my goodness. Why would anyone consider being "stuck" in SQL Server being "stuck"? I actually gave up the front-end world (11 years ago) to work...

WALL

Data Retention is a business rule around specific processes that have been created for your data. How to change that retention period will depend on how the process was...

FLIP

Here is an article I wrote on the topic to export the packages.

http://jasonbrimhall.info/2010/12/28/ssis-multiple-file-export/

Thanks for the question.

EZ PZ

This should do what you need. If it doesn't work, I wonder if there may be some firewall policy or server security blocking you.

gwmi win32_service -comp (gc servers.txt) |

select...

The path is hard coded into the registry. If you need to retrieve it from a different location, it will require changing the registry for each person that will...