Search results for query: *

I finally did get it-forgot about 4-part notation-already had linked server. found another interesting issue-could not run distributed queries after above completed due to MSDTC error. Found solution on this link to correct MSDTC issue: http://support.microsoft.com/?kbid=873160

I need to create a trigger on Server A to delete two tables on Server B. Tables are same name and replicated. The trigger would run after replication successful on Server A. Pls. advise on syntax for accessing Server B table from Server A.

I have replication working fine on both ends-problem is replication only allows use of time schedule, which I don't like;I have to use triggers to invoke replication. I have been trying to create a linked server to invoke my SQL job on the SUB(Server A) from PUB on Server B. I was successful at...

I was able to get triggers to work after review of SQL Books Online..thx Next issue: I have merge replication setup on two servers (server A is SUB, server B is PUB). When I insert new record in server B table1, I need trigger to replicate new record to server A table1. Not sure how to trigger...

I need to run sql job based on a record being inserted to a table. The record gets inserted baed on merge replication from other clients, after insert I want a job to invoke. How to make this happen? running SQL 2K5-familiar w/ running sql jobs, never used triggers-not sure how to create...

Using Excel 2002 on NT4 box can not add MSCOMM.ocx object to worksheet-error msg. 'can't insert object' no further help. Pls. advise on how to add object. thx..bt

I am having same problem, but not successful. I have a Sheet1 with a cmdStart_click(). I need this event to start when Excel 2002 is opened. Pls. advise on how to make this happen. thx..bt7403

How to stop job from moving to next step if no records match per FETCH routine below. ----------------------------------------------------------- USE Process GO declare @lot varchar (25),@sap varchar(10), @process varchar(10) DECLARE field_cursor CURSOR FOR SELECT product_order, sap_no...

I have a SQL job w/ 5 steps: 1. Fetch records routine and update Table A 2. run SSIS pkg. 3. delete records from Table B 4. delete records from Table A 5. delete records from Table C Although Step 1 ran okay, update could not perform because values were not avail. at the time. However the...

I have confirmed the use of item #20 per FAQ above does not work based on use of Connection property along w/ DynamiceFilename. The recommended step# 20 does not indicate property to set,so I assumed Connection was expected. Anyway, pls. update FAQ and post completed. thxx..

I tried to script the two jobs together, but they will not run as SQL query (error: specified @name already exists). If I change the @name it will run once only as it now exists and can not run again under same name. Still trying. Anybody got an answer on this one? thx.bt7403

I have two SQL jobs running on set schedule (every 15mins.) One job is a Fetch routine; the second job is an SSIS pkg. My concerns are decreased db performance as these jobs consume alot of time to execute. I can add both job tasks into one SQL job to run, but I want a trigger to execute the...

GO ahead and confirm #20 will not work.

The FAQ shown works great minus item #20. 20. In the "Expressions" field click the drop down and select your variable "User::DynamicFileName". Setting this expression does not work. Because the resultset has the variable this expression would not be needed anyway. I want to thank those who...