This error indicates that you are trying to reference the first row of a DataTable (or other storage mechanism), but that object does not contain any rows.  Run your query...

Just delete the records from the table instead:

DELETE FROM dbo.employee

Can you post the T-SQL code from your SQL task?

I'm in the middle of just such a project. Ping me and I'll fill you in.

Can you post some code, particularly your connection string.

You'll have to post some of your VB.NET code for a solid answer, but judging by the error message you posted it appears that you may have forgotten to set...

Of course - just use the Create Table wizard and create a new table with a single column of type Date.  When updating this table, remember that Access requires some...

The SQL Server Connections  conference is well worth the trip.  I went a year ago (December '05) to Vegas, which was the same week that SQL Server 2005 was released. ...

Yes, but mine's the best.  It's in color......

I needed the same thing a while back.  Try this out.  It's not pretty, but it gets the job done.

If you are on SQL Server 2005, you could use also...

Actually you can run the 2 in parallel.  If you installed Express as the default instance, set up Standard as a named instance.  If Express is a named instance, you...

You can run queries against a remote SQL server by IP address.  You'll need to connect via TCP/IP in this case, so make sure that protocol is enabled.  Since you're...

Possibly a timeout, but I would suspect an interruption in network connectivity.

Frank,

Try removing the GO statement altogether.  This statement is simply a batch terminator, and assuming this is the only command you are running in this batch it is unnecessarily verbose to...

Ed,

I'm interested in this too - I have thought about writing a web or CE app that would keep track of baseball stats.  Let me know if you have found...