Best advice I can offer is to palm off the payment handling to one of the few websites that are already setup for this.

If you have to take the...

How about posting the query and the tables involved. Maybe we can come up with a solution that reduces your tempdb usage.

One thing you get to know pretty quickly if you use EM for your development tool. Refresh, Refresh, Refresh and once more Refresh.

This is the dreaded Enterprise Manager refresh problem is it?

I'd be seriously considering talking to these users and working out what they're doing with 4-5 months worth of data in one report thats 500 pages long.

Is this an...

With that select statement, you're telling the server to give you everything and it's returning in 30 seconds. I don't know about anyone else, but if my 50 column table returned...

The best "fix" is re-analyse the purpose of the report and how the data is going to be used. I don't know of anyone in their right mind that would...

What account(s) are you using for the SQL Server and SQL Server Agent services? If you're not using LocalSystemAccount with 'Allow service to interact with desktop' enabled, then you'll never...

There is no need to create an new thread referring to a post you've already started.

Just reply to the same thread saying that you still need help and it will show...

There is no need to create an new thread referring to a post you've already started.

Just reply to the same thread saying that you still need help and it will...

Hmm ... that would be because you're querying the syslogins view which is based on the sysxlogins table.

The isntname column is derived from the xstatus column in sysxlogins using a bitwise...

For the identifier delimeters (brackets), in Query Analyzer, got Tools|Options and on the Script tab you can choose from,

Version dependent

None

[] -- 7.0 compatible

" " -- 6.5 compatible

For point...

"have you ever successfully used xp_smtp_mail on a server that didn't have IIS and SMTP services running"

Yes, we have one that resides of the domain in its own workgroup with...

raj, in your current trend of following up my posts with this message, I thought I'd point out a thread you seem to...

"You should be aware - no matter what format you use to create a table Query Analyzer or Enterprise Manager will always return your code in First format"

This is not...