Recent content by WDfog

Thanks for the info. I will see what I can chase down.

I believe so. There's a good chance she's been added to the domain admin group.

Does an end user have any recourse to prove if another person is accessing their email account? Are there audit trail settings that can be turned on through the Outlook client? I have a user who is positive her email account is being accessed by another person. (She 's finding specific...

Thank you for insight! I was pulling out all hacks that I know to break into this thing, and was being defeated at every turn. My ego feels my better now. I will coordinate with the user group to see how we can get regular backups, at least, done for their data. Thank you!

A dept in my company just setup an ACT! server which uses MS SQL Server 2000 as the back-end. Unfortunately, it appears that ACT installs a hacked up version of SQL Server in that none of the GUI tools are installed on that server. We are not allowed to have the sa password either...

I think I understand. The project is complete, so simply remove access to it. A little burdensome to go through each user, but it is a solution I can do as we dont exactly complete tons of projects all at once. (Heh- unfortunately.) Thank you very much for the response! I will be trying...

I have a SQL 7 server that references another linked SQL 7 server in SQL statements, that runs in a job once an hour. Job ran fine for awhile and suddenly started failing. When running the code manually I receive the following error: Server: Msg 7399, Level 16, State 1, Line 4 OLE DB provider...

Hmm. Thank you for the response. =) Unforunately, I'been told this answer, and I find it an unacceptable one. My company runs reports, including year-end reports, on the estimated and actual hours of these projects. Deleting them would defeat the purpose of having them all in a database. I...

I'm setting up two devices to handle the backup of my database: one for the database itself and one for it's transaction log. The database will be backed up once a day, and the device will be overwritten (INIT) so there is only one copy of the database at any given time within that device...

My company has just recently implemented the use of MS Project 2000 and MS Project Central. Once a project has been completed, is there anyway to eliminate it from view in Project Central's timesheet view? Thanks, WDFog

Hi, I'm currently using both MS Project and ProjectCentral as a timesheet tracking utility. All MS Projects are currently being stored via ODBC driver to a SQL Server database outside of the Project Central database. When updating one particular project, I receive an error that either the...

Either would be fine. We used both SQL Server 7.0, and then upgraded to SQL 2000 without issue.

No cursors necessary. Just add the third table into the fray. SELECT A.*, B.BID, B.Bname FROM TableA A INNER JOIN TableB2A BA ON A.AID = BA.AID INNER JOIN TableB B ON BA.BID = B.BID WHERE BA.BID = @findMe

Is there anyway to read a transaction log? At this time, if I want to see sql commands issued during a procedure, I use the SQL Profiler tool. Was wondering if anyone knew of a method for reading the transaction log for sql events that have occurred. Thanks

I dont believe MS SQL Server has this option. Sounds like Oracle is attempting to be convenient and drop any tables that are related to the table being dropped (ie. tables with foreign keys to this one). With SQL Server, you will need to drop all the "child" tables first, then drop...