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...
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...
Have written an ActiveX Document project on a Win98 machine and it does not run on a Win2000 machine, and vice versa. An activex document project created on the Win2000 machine does not run on the Win98 machine.
Anyone have experience with this that would know what is going on here?
Thanks...
Excellent! The quotes work positively as a varchar. Plus, I stopped executing my string as a N'....' and switched to executing a variable that stores the full SQL statement.
Thank you *very* much!
I have a stored procedure that will be receiving parameters to build the WHERE clause of the SQL statement. I'm allowing users to select more than one item for each column so am having to use the IN clause. My statement looks like the following:
EXEC (N'SELECT col1, col2 FROM Table1 WHERE...
I'm creating some reports in Crystal version 7 with SQL Server 7, and have found the running totals to be troublesome. (My data sources are stored procedures.) The simplest of requirements (sum everything) can leave out a number and cause an incorrect result. I read one of the FAQs posted...
Thanks for the info everyone. You've essentially confirmed exactly what I thought. The hardware group wants to rebuild my server, so I'll probably be redoing all my databases with the restore method so they can be moved to new drives if necessary. (This is a SQL Server 7 setup btw.)
I was...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.