Search results for query: *

That would be the easy way, but our app passes in only a where clause for this particular feature, so it would require quite an effort to modify . I've never seen a situation where SQL Server would return the data unsorted, so I'm trying to figure out what is going on with the Server side...

Hello, I have a client that has a view with a top x and an order by. When you do a simple query against the view, it returns sorted, as soon as you add a where clause to your query, the sort goes away - any thoughts?

Hi, I have tables A and B. A has data like an ID, and some other fields, B has the same ID, and other fields. I'm trying to produce a view that combines the two horizontally to make it easier for reporting for some of my users. In essence, A has: 1 2 3 B has 1,10 1,20 1,30 2,5 2,6 2,7 I'd...

Thanks, I was heading in that direction! Phil

Hi, any thoughts on why our transaction log file on our server (sql 7) would show opening file x, starting up database x, then seconds later closing file x, then starting it all up again (and again and again)? Perhaps this is normal when we do a commit from ADO, just seemed a bit odd.

Hi, trying to research this and haven't found much info yet. A client called to say that they had lost a bunch of transactions that had been entered into a sql 2000 db via our custom vb/ado app. Coincidentally, the same day that the transactions disappeared, the server ran out of disk space...

Thanks!

I thought this would be a piece of cake, but it hasn't gone as smoothly as I expected. I need to drop a bunch of views, but I don't want to hardcode the drop command since the names change. When I try to do a drop view @viewname it gives me a syntax error - am I missing something? Phil

If I have an app that requires a different version of mfc42.dll than is in my windows system32 directory, can I copy it into my app directory and it will be used when the app launches? Additionally, does it need to be registered, or will it's presence cause it to be loaded when the app loads...

We've got a custom app that a client has been using for years with success (16 bit vb app), they applied a service pack update to Citrix (2 I believe) a couple of months ago, and now, when our app launches, it dies most times before it even makes it to the login screen. Other times the login...

Hello, we want to have a view that users utilize to see data. There is a lot of logic that goes into the view so that they can only see their particular records. Is there any way to allow them to update data within the view, but not give them any access to the base table that the view is made...

Hi, we have a VB app that uses ado to put an image into a SQL Server table. If I go into Access and run a report, I can't pull up the image. If I link to the table from Access, and paste in an image I can then run reports on it, but my VB app can't understand the image - any thoughts? Thanks, PH