I've got a quite expensive stored procedure in my SQL Server database. Launching it from the SQL Server Managment Studio requires some minutes. But I can't launch it via code using SqlCommand.

I've got this code:

```
spExecQuery = "EXEC [schema].[storedName]" 

```

If I use this vb.NET snippet:

```
Using sqlCmd As SqlCommand = New SqlCommand(spExecQuery, conn)
    sqlCmd.ExecuteNonQuery()
End Using

```

The script ends with "Timeout expired" error. But if I do:

```
Using sqlCmd As SqlCommand = New SqlCommand(spExecQuery, conn)
    sqlCmd.CommandTimeout = 0
    sqlCmd.ExecuteNonQuery()
End Using

```

The script never ends (it's running from at least 2 hours)... What am I missing? Thank you.