Viewing 15 posts - 38,266 through 38,280 (of 39,466 total)
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
You could just build the sql and then do a replace for ' with ''. I think Brian has the best idea.
Steve Jones
January 22, 2002 at 4:10 pm
No idea if Brian's suggestion is wrong. Each column, table, or database can have a different code page/collation sequence.
Steve Jones
January 22, 2002 at 4:08 pm
This is a really long way to go about this. Can you just post the resulting trigger code?
This looks like the right track. You check for updated() and do the...
January 22, 2002 at 4:06 pm
Viewing 15 posts - 38,266 through 38,280 (of 39,466 total)