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...

You're welcome. One other thing I though of is that if you declare the objects with case sensitive names (like columns), they will be returned as such. This must be...

Any changes to DTS packages that might attach files? Perhaps some file attachment is causing the failure. There is an error in the KB mentioning sending open files.

Steve Jones

steve@dkranch.net

You can restore with move option. This allows you to move the log file.

Or buy a bigger disk.

Steve Jones

steve@dkranch.net

The datatype is int. A property of this column is identity.

Steve Jones

steve@dkranch.net