There are quite a few products out there that do parts of what you're looking for, but I'm not aware of anything that does the whole kit and kaboodle off...

Pass-through Windows authentication is possible. However, I believe the user account must be a local account on the SQL Server box itself. If the username/password matches, you're in.

Preferably, though, you...

If you have a trace running, you can capture the hostname the source passed, but this isn't guaranteed to be accurate. You could also use network traces or an IDS...

Profiler and the trace stored procedures can also be used to audit logins. I omitted that.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

All of this is SQL 7.0, someone else will have to comment on SQL 6.5 as I no longer have the docs or a working install.

Look at Books Online for...

Is it possible to drop a semaphore file that is copied immediately after the actual data file? A 1-byte file or something of that sort. Or is possible to have...

What are you trying to audit? Just logins? Queries as well? Changes in data?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

SQL Server 2000 can, here's how:

http://support.microsoft.com/default.aspx?scid=kb;en-us;294453

I don't know of a KB article for SQL Server 7, but you could give the same instructions a try.

As for Yukon, it may be...

If the view and the tables are in the same database, and they are all owned by the same user (such as dbo), you only have to apply permissions to...

True, but keep in mind if search suffixes are properly configured on the workstation, it'll append the domain suffix when doing a DNS lookup to find the server. For example,...

How does the user deposit the file. Is it an automated process? Same file name each time?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Looks like this got posted twice. Continue responses in this thread so we can keep everything together:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=19335&FORUM_ID=8&CAT_ID=1&Topic_Title=How+to+get+Time+from+Getdate%28%29&Forum_Title=T%2DSQL

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Frank, I have a feeling you will be the first to 2500 between the two of us.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL...

Yes, views are updateable and have their own sets of permissions. So long as the owners are the same between the views and the base tables, ownership chaining occurs, meaning...

Perhaps you can tailor some of the access through views? It's not everything, but you may be able to restrict some access that way.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish...