Viewing 15 posts - 16 through 30 (of 40 total)
was the result
August 11, 2005 at 1:29 pm
Well that does work. But, what I was tryig to do was something like this
select top 100 percent *
order by column1
This way view is pre sorted, since...
August 11, 2005 at 1:27 pm
tried it with the order by ..still get the error.
August 11, 2005 at 1:24 pm
Interesting enough I just refreshed my test server from a backup from production yesterday. And it fails on both servers.
Mind you, the only reason I even came across this was...
August 11, 2005 at 12:22 pm
So, that seems to eliminate the level as being suspect.
August 11, 2005 at 12:10 pm
That was the first thing checked but, not the cause of the issue.
I have my data center guys scrating thier heads over this one.
August 11, 2005 at 12:04 pm
No just like that. I first tried to add it toa view so that I could put in an ORDER BY. Then just tried a general select statement. As the...
August 11, 2005 at 10:22 am
No I checked that, and its the same
August 11, 2005 at 9:06 am
I went down the same path and also did not come across any software or canned process to log table \ view access via a 'SELECT'.
What worked best is to...
August 11, 2005 at 8:35 am
I support a SQL datawarehouse with similar requests. I do have a PowerBuilder front end that allows end users to run queries and export to execl. However, the more advanced power users extract...
July 29, 2005 at 8:44 am
I have the same issue with one of my servers. The original use of the server was to host a datawarehouse generated from our mainframe.
However, overtime I've been asked to...
July 20, 2005 at 8:04 am
What is the server default collation and what is the database in question collation?
July 18, 2005 at 8:30 am
Agreed, if Transformations are required then use DTS. Otherwise you would have to use first load to one table then run another script to move and or transform data to...
July 18, 2005 at 8:22 am
You have two other options.
1) run profiler and capture the results to a table. issue here is that you can not append the data. So you need two tables. one...
July 13, 2005 at 9:11 am
I currently have a table with 224 columns. It is a copy of an old mainframe customer file. Performance is not an issue. But that's becuase most of the columns...
July 6, 2005 at 8:37 am