Great question.

I did not find it ambiguous, in fact this line removed the ambiguity.

Unfortunately, I don't have an answer yet for the cause. We've restored the backup and run the reindexing job on another server (same SAN and disks though), but it...

Agreed, we've looked over our SAN logs, but haven't found the "smoking gun" yet. We're in the process of looking over our fiber channel logs. Just an FYI,...

Whoops, I suppose I wasn't reading the best in the heat of moment. You are correct, this is an SQL Server 2005 instance.

Thanks Gila. I was hoping to do a page restore, but I guess we're not looking good. I did read on BOL that we wouldn't be able to restore...

Thanks David, I appreciate your follow up comments and great article.

Given SQL 2005/2008 would you recommend the same solution,...

In regards to "The dreaded BIT field problem", what are your throughts on using an indexed filtered view instead of a table? IE

CREATE VIEW DocumentList WITH SchemaBinding

AS

SELECT DocumentID

FROM ProcessingQueue

WHERE...

I can see where this could come in handly during ETL processes.

In regards to creating a delimited list see the example here on MSDN http://msdn2.microsoft.com/en-us/library/ms131056.aspx. Using a CLR it...

adrinkwine (11/11/2009)

It appears the SQL Job isn't passing in my string value correctly. Its a basic UNC path to a folder, but the path does have some spaces it a...

After some thought I came up with the following solutions.

1. Turn a blind eye and hope for the best

2. Develop our own package configuration mechanism

3. Treat all warnings as errors

4....

I recently posted about Package Configurations throwing Warnings rather than Errors. I don't suppose you've solved that problem as well? My current solution treats all warnings as errors.

http://www.sqlservercentral.com/Forums/Topic724499-148-1.aspx#bm724516

Jamie Thompson noted this as a problem as well and provided us a link to an MSDN forum discussion here.

http://blogs.conchango.com/jamiethomson/archive/2006/05/25/SSIS_3A00_-Warning-but-no-error-if-an-environment-variable-is-missing.aspx

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/1f7fe0db-a770-40e6-9e27-161af19e8c6f/

I just found this on Connect. Please vote for it if you are affected by this issue.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127206

Also, I'm still looking for a viable work around. So far, I...

Perhaps using Persisted Computed Columns could provide the best of both worlds? Define the attributes as columns accordingly and then use the computed columns to be the bit stuffed...