... the sales_order_log and the sales_ord_curr_yr table are on the local database.... match the object in the UPDATE clause 'myserver.mydb.dbo.sales_order_log'.... reference machine1, where the sales_order_log table resides? Sorry to be so ...I run an update versus this table on one server and the ... sales_ord_curr_yr is located on the server yourserver. The job above runs ...

...> the sales_order_log and the sales_ord_curr_yr table are on the local database. ... match the object in the UPDATE clause 'myserver.mydb.dbo.sales_order_log'.... reference machine1, where the sales_order_log table resides? Sorry to be so ... run an update versus this table on one server and the ... sales_ord_curr_yr is located on the server yourserver. The job above runs ...

... the sales_order_log and the sales_ord_curr_yr table are on the local database. ... reference machine1, where the sales_order_log table resides? Sorry to be so ... run an update versus this table on one server and the ... is housed. The query is: -- update order log non ds/dn ... sales_ord_curr_yr is located on the server yourserver. The job above runs ...

... data is collected in a table, sales_order_log, on one of the ... run an update versus this table on one server and the ...is housed. The query is: -- update order log non ds/dn...I get this error message: Server: Msg 117, Level 15, State...sales_ord_curr_yr is located on the server yourserver. The job above runs...fine on the same server the table and the curr_yr file...

... data is collected in a table, sales_order_log, on one of the ... run an update versus this table on one server and the ... is housed. The query is: -- update order log non ds/dn ... I get this error message: Server: Msg 117, Level 15, State ... prefixes. The maximum is 3. The table sales_order_log is on the...sales_ord_curr_yr is located on the server yourserver. The job above runs...

... get them into a table in SQL server. As far as ... transfer the data into SQL server. As I look around for ... a network location the SQL server can 'see' so it can ... by the user? Can SQL server watch network directories and just ... in when the file is updated, or a regularly scheduled SQL ... into something we can ask questions to later... Once you grab...

...and get them into a table in SQL server. As far as I...directly transfer the data into SQL server. As I look around for options...to a network location the SQL server can 'see' so it can ... by the user? Can SQL server watch network directories and just ... in when the file is updated, or a regularly scheduled SQL ... into something we can ask questions to later... Once you grab ...

... indulgence if this is an obvious question. I'm running on XP, using sql server 2005 and VFP 9.0. I...a view. I know I can update fields by naming them: =sqlexec(xx...selected from table test on the server. The field wcode is updated from...has a hundred fields, can I update it from the cursor without manually...there a more global way of updating all the fields without enumerating ...

...indulgence if this is an obvious question. I'm running on XP, using sql server 2005 and VFP 9.0. ...a view. I know I can update fields by naming them: =sqlexec(xx...This works----otest is a cursor selected from table test on the server. The field wcode is updated ...has a hundred fields, can I update it from the cursor without ... a more global way of updating all the fields without enumerating ...

... Server work: If the column in question has the IDENTITY attribute, then you cannot UPDATE that value. You can specify a...IDENTITY INSERT ON. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver...I need to update from Access a table in SQL SERVER 2005 that...the import data tool. Then, my question is Can I do that in SQL SERVER 2005 ?. if not, is there any...