Viewing 15 posts - 31,546 through 31,560 (of 39,821 total)
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...
August 31, 2007 at 8:27 am
Have you tried it with replacing SHEET$1 with something else?
August 31, 2007 at 8:23 am
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.
August 31, 2007 at 7:46 am
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...
August 31, 2007 at 7:45 am
Strange question, but I'd go with the union as well.
August 31, 2007 at 7:43 am
Agree with John. We came up with a hack to force changes in SQL2000, but we couldn't deal with complexity.
August 31, 2007 at 7:41 am
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.
August 31, 2007 at 7:40 am
Kerobin,
I sent a note to Idera on this and hopefully they will respond soon.
August 31, 2007 at 7:27 am
Shyam, there are a number of security changes to make SQL Server 2005 more secure. This behavior is probably one of them.
August 31, 2007 at 7:19 am
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...
August 30, 2007 at 3:48 pm
Norene has a good point.
Let's hope that these "problem customers" were in fact abusing their right to complain.
August 30, 2007 at 8:01 am
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...
August 29, 2007 at 4:32 pm
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...
August 29, 2007 at 3:40 pm
No idea on Sp3. They are releasing rollups post SP2 about every other month.
August 29, 2007 at 8:31 am
Viewing 15 posts - 31,546 through 31,560 (of 39,821 total)