Here's a couple of things to think about/test...

Can you log into that database from either QA or Management Studio express from the server that is hosting your ASP app (and/or any...

Following the bouncing Parenthsis...

Cast to decimals to actually get a decimal that is then the outter cast to a varchar for output with the '%" symbol.

Have a look at the following and see if it gives you any ideas.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=362233

-Luke.

Unfortunately, performance tuning can be very dependent on your environment so it's very hard for us to say, do it this way and it'll always be better. Sure there...

Yeah I'd read the bit about XML and such, and was thinking it was a possibility for the future, but I was thinking that I'd most likely hit the upper...

I was thinking the same thing, but the trigger could be faster than executing it from the client machine. I'll have to do some testing...

Anyhow, it's actually a one...

Yeah, I'd planned on changing that, but what I'd really like to make happen is the insert to occur in 1 statement instead of having to make 2 separate database...

Check out the section on BCP titled "bcp utility, copying data from query to data file" from BOL.  I think you may be able to find your solution there.

-Luke.

Let's see... smart... hmm... Well I work for a State government... you do the math.

I too have had no difficulties installing anything really on a MS VM provided you install the tools etc... However, I typically install from ISO's not CD's because it's...

DTS jobs can't be easily scheduled?

Ive always had issues with this since joining this site. If you wait too long before posting back, you loose your message...

I've just gotten in the habit of writing...

I'd have to agree with the FTP task in DTS, however, since the one that comes with SQL 2000 isn't all that great have a look at http://www.sqldts.com/302.aspx. They...

At work I typically just let the Enterprise backup software take care of me. All of my code, DR docs etc are all backed up on a regular basis...

a quick search of this site, for Suspect Database, turned up the following article. http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/

However, If I were you, since you said you just installed EPO and I'm assuming...