I'd pipe the output of the execute results task to a file and search it. This is probably the best technique, though your search routine may be cumbersome.

I did a...

Yikes, I hate triggers. If you must, Brian's suggestion is easier, but ift may come back to haunt you if the requirements change.

Steve Jones

steve@dkranch.net

Don;t think so. I get this for trusted connections for sa.

Steve Jones

steve@dkranch.net

Thanks for the followup. Do you remember the Q article?

Steve Jones

steve@dkranch.net

Identities are not good or bad in and of themselves. they do solve problems and in my experience, they can ease loads because I get data that does not have...

user_name will be unique IF your users do not share passwords or machines. host_name has nothing to do with it. I can hard code "awarren" in the host_name parameter for...

You can set a FK between them, but you would need to set a unique index on both tables to ensure that it is not a 1:many.

Steve Jones

steve@dkranch.net

You are welcome. Glad it worked.

Steve Jones

steve@dkranch.net

Good article. One thing to keep in mind is this depends on your client application. We use Cold Fusion and the multiple result sets don't always work. also, sometimes two...

This seemed to work

create table #ReceiptsPhysical

(part_no int

, location char( 2)

, recv_date datetime

)

create clustered index pn_loc_recvdate on #ReceiptsPhysical(part_no, location, recv_date desc)

insert #ReceiptsPhysical

select 1, 'A', getdate()

insert #ReceiptsPhysical

select 2, 'B', getdate()

insert...

Not too much has changed. I like Brian Knight's Admin 911 book.

Steve Jones

steve@dkranch.net

Apologies for not debugging the code, but it's quite a bit. If the text field auditing is a real problem, I'd look at the Lumigent product advertised on this site...

You don't have any real "ordering" in the Transact table. How can you determine the "opening balance". Wihtout some date or flag, this isn't really possible. Depending on natural order...

Not sure I understand. If there is not EOL marker, how can SQL fix this?

You could use an ActiveX script to check the first character of the file for a...

np. just trying to clarify. Didn't want to pick on you.

Steve Jones

steve@dkranch.net