See this FAQ for a quick summary of your options:

http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=6&faqid=252

I hope it helps,

-Al

Funny thing about people and their computers...

The computer is completing millions of processes every second, but...

The best approach is to test the SQL code out separately from the ASP code to get a feel for the number of records you should see.

My current employment position...

Hang with me because I don't really have any hands-on experience with MSDE. All I know is MSDE uses the same engine as SQL server more or less.

If this...

Hehe.. Joe... We had that problem too!!

At first I planned to write another VBS script deal with that problem as well. But then...

We had (and still have) a problem with data like that here. The solution we came up with and seems to be working as expected is to pre-prepare the...

This behavior your describing has my SQL Server Bat-senses tingling in the direction of an authentication issue.

Questions -

Do the users that are supposed to have access rights to the MSDE...

When setting up servers for replication, make sure that the SQL Server Agent service in both systems is started using a network user account that has DBO rights in both...

I would trust the following

If you run this quick query against the master database:

SELECT @@Version

and it returns the version:

8.00.0818

Then you are ok.

...

I also have to side with the "best practice" of cleaning up after yourself when it comes to temp tables. It may eat a few extra CPU cycles to...

Another Web Application server to consider may be Macromedia ColdFusion MX. ColdFusion Markup Language has a very short learning curve compared to most other "web enabling" technologies. Circumstances...