All you need to do is run the setup program for SQL Server.  On the options dialog, it will ask if you want to install a default instance (this will...

Glad I could help.

Nice one, Shane.  I had not heard of those tokens before, and had always written code to get those values (like time stamping a backup file).  Just goes to show...

As you are new to this, here is a tip that may help you.  Take a look at how to debug stored procedures using Query Analyzer.  Write and create the...

You likely would be better off writing the stored procedure to accept the two parameters, and having the sproc to create each record.  Use a For statement and loop txtNumberPayments...

A little more direct than using the full maintenance plan wizard is to use the sqlmaint utility.  Check the paramaters in BOL.  You can specify all you need, without having...

It would be much easier not using DTS at all.  First setup the AS/400 as a linked server.  Then write a stored procedure that reads your log able and, in...

I think you're problem is trying to store a null in a Session variable.  That cannot be done.  You must have some code elsewhere that sets the dataset column value...

I would recommend using the either the maintenance plan or sqlmaint program, so that you easily have named backups with date/time embedded.  Do a full backup once a day, as...

It sounds like in your web application, you are using ADO recordset to add/update records, and you are putting a value of 0 (zero) in the data field.  Try to...

By default, MSDE SP3 will not install any network protocols (TCP, named pipes, etc).  You will always be able to connect on the same machine using Shared memory protocol.  If no...

I know that the quickest way to refresh these table would be to use DTS.

I would disagree with that.  The quickest way, especially from code, would be to use...

Use the Client Network utility.

Ahh, cat's out of the bag, too early.

You might have two instances of SQL Server on your machine (which is legitimate, SQL Server Std/Personal/MSDE allow up to 16 instances).  Or you might have one instance and registered...