Search results for query: *

Ok I am trying to write a little program (3 days work now) that will take one user and assign him rights to another users account to send as. (more rights once I get this one working). I am getting a Member not found error when I run this code. Most of this code is from a sample I am trying to...

Maybe a better way of asking is am I doing this process right. I created a DTS package (Local) and added a SQL connection and then added a Execute Sql Task that I put this code in. I then scheduled the Package to run every 5 minutes. Maybe there is a better way to do this?

I believe so. I get 3 of the 4 records in the DB. It just is dropping one of them 3 out of 4 times the DTS Package is run. Very wierd.

When I run the code in Query analyser it runs fine. It appears to be an issue only when it is scheduled to run. Manually it works perfectly. Thinking there has to be something wrong with the way DTS is running or something like that?

Ok maybe I am doing this completely wrong but I am getting weird results. Basically I have a package that reads 4 fields from one DB (server names) and inserts the name into an exec statement for each row found. The problem is it appears it isn't returning all the rows. It is dropping one or...

Thanks that worked. I should have asked earlier. Spent 1/2 of a day trying to figure it out.

Ok this is what I am trying to do. I need to select all rows from one table and feed them into a execute statement and have that statement run for each row of the other table. Not sure where to start? declare @ServerName VarChar(100) begin select @serverName = (Select server from...

Ok this is what I am trying to do. I need to select all rows from one table and feed them into a execute statement and have that statement run for each row of the other table. Not sure where to start? declare @ServerName VarChar(100) begin select @serverName = (Select server from...