Without seeing the VB.Net, it's a bit hard to speculate ... especially in terms of what's getting logged and what log you're referring to and what kind of error checking...

Everything that you want to have happen together (either all committing or all rolling back) goes in the same TRY block. If any part of that block of code...

Haven't had issues with SQL 2008 specifically, but I have had cases where the MS license server locked out a particular key. I had un-installed and was trying to...

If this is an everyday (or at least very regular) process, I would highly suggest taking the opportunity to learn and use SSIS.

Looks like the placement of the 'End' on your 'If' is preventing the cursor from looping, try ...

<snip>

While@@FETCH_STATUS=0

BEGIN

if @Statisticvalue <= 100

BEGIN

Set @strExec=N'Insert'+' '+'demo2'+' '+'(Databasename,SchemaName,Tablename,

Columnname,Statistic,Statisticsubpart,Statisticvalue,Snapshotdate)'

Set @strExec=@strExec+'Select'+' '+''''+@Database+''''+','+

+''''+@SchemaName+''''+','

+''''+@TableName+''''+','

+''''+@ColumnName+''''+','

+'''CountDistinct'''+','

+'Convert(varChar(100), '+@ColumnName+')'+','

+'Count(0)'+','

+'Getdate()'

Set @strExec=@strExec+' '+'From'+'...

Seeing as how this is posted in the 'SQL Server 2008' section, you should be using TRY/CATCH blocks instead. (The TRY would include the commit and the CATCH would...

When you're local the whole file needs to come over the network to your local box and then back again across the network to be inserted into the database. ...