Right.

Thanks

Thanks for your reply. I had to convince business to agree with limiting the length to 8000, or I have to have the application to explicitly record history on each...

Sorry, cannot provide you with the sample code, as this is not a consistent and staight forward issue.

I did a bit more research, I suspect it's related to the Eager...

I don't think the Data is the issue, as this is only happening with SQL 2008 not on SQL 2005 and 2000. (We tested with identical data which works on...

SQL Agent Job scheduler itself is very light, the minimal interval SQL Server supports natively is 1 minute. If you goal is to let you job response to new files...

I personally don't recommend people enforcing Cascade Delete thru Constraints, unless you 100% sure you always want to clean up the children records when a DELETE is issued on parent...

Accounts like "LOCAL Service", "Network Service" only have access to local resources on that box, those accounts will not have access to remote network resources.

To resolve your issue, you...

First, try to add the programs you are using to your windows firewall exception, as using ServerName\InstanceName to access named instance invokes a sql server discovery process, which uses UDP...