When I set the protection level to "EcryptAllWithPassword", I am getting this when opening a package save with password:

"Document contains one or more extremely long lines of text"

Is this normal?

Thanks Greg for you reply.

If I use "EcryptAllWithPassword" and providing the password in the dtexec command for the parent package, what do I need to do set it up for...

Okay, I might have found a work around byy using variable.

Rem

I have following steps:

http://www.dushu.de/englishbook/wrox.expert.sql.server.2005.integration.services/final/bbl0043.html

But each time I face an error, the OnError event handler failed. Is it because the definition of "[System::ErrorDescription]" in my table is not...

Did you tried to attach a Maintenance Cleanup task after your backup? I think you will have better luck.

I will be using a T-SQL Statement to run DBCCs.

I am curious to see if the DBCC maintenance plan is working for someone.

Thanks

Thanks for all your hints.

What about USPS CASS CERTIFICATION, any experiences with it?

I am not sure which one to try first. Any hints?

Please note the original post!!!

"

Since a few weeks, our SQL server (2005 64 bits Standard Edition running on Windows 2003 DataCenter) has some issues performance wise. A few times...

Power Schemes is actually set to "Always On". Not sure what to do next.

Thanks.

I got a confirmation from our sysadmin, Hyper-threading was not enabling.

We have 4x4quad CPUs on that box. I am seeing 16 CPUs, this mean HT is not enabled.

Should...

By setting Processors Affinity & I/O Affinity, Am I OK, or I should totally disable HT?

Forgot to add the version...

Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows...

The hardware has 8 CPU (Hyper-Threading). CPUs 0 to 5 are Processors Affinity while 6 to 15 are I/O Affinity (because I was seeing entry like this on e...

Currently the server had 16GB of memory and 8gb are assigned (as min & max) to SQL server. As of now, there is no other application running in the...