Viewing 15 posts - 38,551 through 38,565 (of 39,754 total)
Is this a copy objects task? If so, I've had numerous problems with those.
Steve Jones
January 23, 2002 at 12:01 pm
January 23, 2002 at 11:59 am
Or suck in the data into a table and process it there. I agree with Brian and Andy, pls post more info.
Steve Jones
January 23, 2002 at 11:58 am
you can get the hostname() from the system, but this is passed by the client. Also, because of proxy servers and NAT, IP addresses are not necessarily unique.
Steve Jones
January 23, 2002 at 11:57 am
January 23, 2002 at 11:56 am
January 23, 2002 at 11:14 am
the other alterative is to write something that stores the connection info and then compares that with the current info and takes action. Then run this every minute or so....
January 23, 2002 at 11:13 am
January 23, 2002 at 11:07 am
January 23, 2002 at 11:04 am
Don't think so. I think the sort order while apply for both tables and data.
Steve Jones
January 23, 2002 at 11:00 am
Roughly the same connection, but the rendering code may be different. QA builds a grid and formats from the results, which can be slow for large result sets.
Steve Jones
January 23, 2002 at 10:57 am
January 23, 2002 at 10:54 am
Can you define "last accessed". Is this the last change or the last time a select occurred against a table. Or the last time a stored procedure was executed?
Steve Jones
January 23, 2002 at 8:17 am
This looks good. The only thing is it will not work for multi row updates. Something to keep in mind.
I'll dbl check the syntax and mock something up as I...
January 22, 2002 at 4:53 pm
Since I don't work with indexes constantly, I just use _NDX1, NDX2, etc. For clustered I use _IDX. Holdovers from the past.
I tend to tune and then let things alone...
January 22, 2002 at 4:13 pm
Viewing 15 posts - 38,551 through 38,565 (of 39,754 total)