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

In the event of an abnormal termination, there isn't any "event" necessarily.

What you could do is write a sproc to compare the results of sp_who with your table and look...

Strange. No idea, but thanks for the followup.

Steve Jones

steve@dkranch.net

Andy is right. This is supplied through the ADO connection and there is no validation or verification. I can easily send a query from my workstation as host_name() "AWarren" if...

Agree with Brian. There is no way in SQL to track the access, other than profiler. You could use a sniffer, but profiler essentially does that. you could also implement...