Search results for query: *

Do you want to know how to create it or apply it?? To create it search on the web for a free icon editor! To apply it, press Ctrl-J (whilst in your project) and on the bottom right you can attach an icon. PLEASE NOT foxpro is very poor in its icon handling a full colour icon will attach but...

We receive Error Reading File error when we have the following config: Terminal Services (TS) Server accessing applications and data on another server. Microsoft Knowledge Base Article - 299603 recommends having the data on the local drive of the TS server. We are getting to the point where...

Is there a way to obtain the last modified date of a table in sql.

This is what i did to get a list of primary keys and the column names. SELECT o.name as [Table], i.name AS [Index], c.name AS [Column], k.keyno as [Keyno] FROM sysindexkeys k INNER JOIN syscolumns c ON k.id = c.id AND k.colid = c.colid INNER JOIN sysindexes i ON k.id = i.id...

You can do this using the following method: First you need to begin a transaction then select the record with the UPDLOCK option. as soon as you commit or rollback the record is released BEGIN TRANSACTION SELECT SOMEFIELD FROM SOMETABLE WITH (UPDLOCK) do some other processing COMMIT or ROLLBACK