My Guess is that your used ADODB or DAO - I've not used them to connect to a SQL Server database but have done so with Access Databases - the code below adds some records to an access db - I think you would need to change the provider - do you have a connection string for the SQL db

Sub DelFirstRec(
Dim rst As ADODB.Recordse
Set rst = New ADODB.Recordse
rst.Open "table name or SQL statement", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\___\db1.mdb;",
adOpenKeyset, adLockOptimisti
With rs
.AddNe
![1] = "1
![2] = "2
.Updat
.Clos
End Wit

End Sub