The way to do it would be to insert rows into the temp table and manipulate them, then select out all the rows as your message. Not sure how this...

Have you tried it with replacing SHEET$1 with something else?

There are numerous scripts on this site that will write a new file based on the date. I'd recommend different dates since I've had issues iwth a single file before.

I'd still think you are a junior DBA since so much of SQL Server is different from Access. There are definitely cross overs in the database design, understanding how tables...

Strange question, but I'd go with the union as well.

Agree with John. We came up with a hack to force changes in SQL2000, but we couldn't deal with complexity.

Are you sure that Mixed mode is enabled on the server? Make sure you're connecting the same way, same name/IP and same protocol.

Kerobin,

I sent a note to Idera on this and hopefully they will respond soon.

Shyam, there are a number of security changes to make SQL Server 2005 more secure. This behavior is probably one of them.

I tend to agree with Mike on this one. Don't want to have people use "unlimited roaming", don't sell it. Or at least don't complain that you're losing money on...

Maybe that's how you get 6000 posts: paste!

Norene has a good point.

Let's hope that these "problem customers" were in fact abusing their right to complain.

I think if you've had some experience and study to get the SQL cert, junior DBA is a job you should apply for. Don't forget that many people ask for...

I think that was in humor as well, or I hope so.

The problem is what is a "promise?" In most of my dealings, if someone asks me if I can...

No idea on Sp3. They are releasing rollups post SP2 about every other month.