I can't open the package because it is encrypted.

Error2Error loading PHSTI_STORE_INFO.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You...

earnest.williams (1/26/2012)

---

I'm a student and a newbie with databases. I was wondering if anyone could provide me some information on constraints. What would the basic way to write...

Subscriptions are implemented as SQL Server jobs. You can directly run the job. The jobs are named using teh GUID Of the report (this could be the subscriptionID).

That...

Can you attach the package? The error is saying you have an invalid character in the XML usually "<" or ">". Without seeing the package it's hard to...

Sounds an awful lot like this, http://social.msdn.microsoft.com/Forums/en-IE/sqldatabaseengine/thread/233da267-7d61-425e-bdce-58241a7769aa.

Doesn't seem like those statements should deadlock unless you have 2 transactions where the access path is reversed like this:

Transaction 1

UPDATE TBL_REQUESTVALUES_OBJECT_PROPERTY

SET PROPERTY_VALUE_CLASS_NAME = NULL

...

Okay, Jason don't report me. Just found this in an SP:

IF 1 = 1 -- Placeholder in case there is an actual conditional on this block

There is code in...

SkyBox (1/26/2012)

---

That's great information Jack. It's difficult to scope this without a list of their apps - based on the list I have so far, there will be about 25-40...

Evil Kraig F (1/26/2012)

---

I agree with Jack on most points but personally I'd use AD groups, not individual users, for security assignment. This way all the security associations exist...

SkyBox (1/26/2012)

---

You...

Posting a query plan would be helpful as well. Here's a video on how to do that if you don't know already.

Can you provide the DDL for the Foreign Key Constraints? I'm trying to figure out why there would need to be an Exclusive lock taken on PK_TBL_REQUESTVALUES_OBJECT_PROPERTY. That...

What else is happening on each box? It sounds like there would be a lot more happening on the original server which means SQL Server may not have the...

Once you've done everything that has been suggested. You should also set the size of tempdb accordingly so it does not need to autogrow. You may find...

I think you are looking for the undocumented xp_fileexist procedure. Here's a an article[/url] on it.

In this day and age, I'd recommend looking into a PowerShell solution for it,...