thanks for the replys guys.

this is the solution i came up with in the end, some borrorwed some new.

SELECT * tbl_locations

WHERE CompanyName = 'someCompanyName'

ORDER BY CONVERT(int, REPLACE(CONVERT(nvarchar, SUBSTRING(IP, 1,...

to get around this, I had to create a stored procedure and loop through table 1, then check for the first record in table2, then update table 1 with the...

well, at worst case. it will be a good learning experence..

I'm sure it will be fine.. what the worst that could happen, not like the whole business is relying on...

doh... i've always called them Indexes, or IDs, "note to self - call them identities"

sorry all, my bad..

thanks

Dave

thanks for the replies guys.

urm.. yes and no, i think??

example. ( data in the tables)

tableA

ID, Name, address1, Address2

1, dave, somestreet, hull

3, frank, anotherstreet, leeds

4, john, yetanotherstreet, scunthorpe

tableB

ID, TableAID, AccountNo, SortCode,...

I guess it depends on what the SP is doing?

select, update or delete?

you need to view the tables permissions, and for the Apple user allow them to select, update or...

I had a similar task not so long ago.

not sure if its the right way, but it worked for me.

I Added a field into the table called LastModified with...

ahh.. I've just read on google that SQL 2k doesn't have a tool for querying the Transaction log.

so i'm now looking at these

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm

http://www.apexsql.com/sql_tools_log.asp

Dave

Yeah, I would if i could.. 🙁

its not my system, its Navision and I don't have anything to do with the Application side of things.

I could alter the SP's...

Ive not tried it, but try this

http://www.lazydba.com/sql/1__16047.html

Dave

thanks Nebojsa

I'll give it a whirl!

cheers

Dave

ahh, my weakness,

I really should buy a book on writing Stored Procedures 🙁

I'll give it go..whats the worst that could happen 😉

cheers Paul

Dave

Thanks for the reply paul.

this is the script that ive come up with so far...

ActiveX Script

' db connection

set dbConn= createObject("ADODB.connection")

dbConn.mode = adModeReadWrite

dbConn.connectionstring = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=myUserAccount;Initial Catalog=MyDatabaseName;Data Source=172.20.1.7;...

yeah, I thought that was the case John.

I've requested that dates are handled in the following manner when inserting and retrieving. 07\Jan\2008. this way, the SQL / Client will...

ok

Many thanks for the reply.

Dave