Have I been asleep at the wheel?  I had never heard of Jumpstart TV.  This looks like a great resource....

Just shooting in the dark here, but have you checked the file size of your data file?  There is a finite limit on the file size of SSCE, and you...

Frank,

You have one comma too many within your parentheses:

, Year INT NOT NULL

,

)

Take out the last comma and you're good to go.

hth

Tim

If I read this correctly, you will actually need two queries - the first to pull the supplemental field names, and the second to pull legitimate data.  I don't know...

I've asked the same question myself, but have never received clarification.  Yes, you can install the client tools on another machine without installing SQL Server, but you might be out...

The full version of SQL Server Management Studio is bundled with all commercial versions of SQL Server 2005.  The Express edition is a free download that can be used to...

Your source file has column names AND valid data in the first line?  How does that work?

When you use the OleDB provider for .NET and parameterized queries, you'll need to use a little different syntax than you would use directly in Access:

.SelectCommand="SELECT srno, userid, proname, descr,...

I agree with Lynn.  Microsoft certifications have lost much of their value recently, and this is a good step toward making certification a legitimate barometer of one's skills.  Though I...

If you're moving from one database to another, remember to qualify your identifiers:

INSERT [db1].[dbo].[Table1] (my_column)

SELECT my_column FROM [db2].[dbo].[Table2]

Hey Ryan,

I've never tried this, but I don't know of a reason that SSEE would not run side-by-side with SQL Server 7.0.  If you have the 7.0 instance configured as...

Good morning,

You shouldn't run into any problems using the SQL Server Management Studio to connect to a SQL Server 2000 database.  However, your T-SQL capabilities are still limited to those...

I recently worked up a solution not unlike what you are describing.  Essentially, I created a stored procedure that allows the user to pass a comma-separated list for each search parameter. ...

Checkout http://forums.asp.net.  It's a very busy forum site - it is moderated but the moderators are quick to process new posts.  There are a lot of MVPs and Microsofties there,...

I used to be one of those "cursor is a four-letter word" people - I avoided them at all costs.  Recently though - call it experience or just getting soft...